xrow
commented
1 year ago I ran an strace with mcr.microsoft.com/mssql/server:2019-CU4-ubuntu-18.04.
I currently belive it is an selinux issue. Does mssql only support selinux being off? Is there a way to fix this?
uname({sysname="Linux", nodename="mssqlinst", ...}) = 0
openat(AT_FDCWD, "/var/opt/mssql/.system//instance_id", O_RDWR|O_CREAT|O_APPEND, 0666) = 14
fcntl(14, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0
lstat("/opt", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
lstat("/opt/mssql", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
lstat("/opt/mssql/lib", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
lstat("/opt/mssql/lib/system", 0x7ffeb4258430) = -1 ENOENT (No such file or directory)
gettid() = 640
gettid() = 640
getcpu([3], [0], NULL) = 0
openat(AT_FDCWD, "/dev/urandom", O_RDONLY) = 15
read(15, "sT\36Y\224\240Q\332", 8) = 8
pread64(7, "MZ\220\0\3\0\0\0\4\0\0\0\377\377\0\0\270\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 64, 3043328) = 64
pread64(7, "PE\0\0d\206\t\0\2435}^\0\0\0\0\0\0\0\0\360\0\" ", 24, 3043568) = 24
pread64(7, "\v\2\16\0\0\20\30\0\0\320\24\0\0\0\0\0\200c7\0\0\0 \0\0\0@j\0\0\0\0"..., 240, 3043592) = 240
mmap(0x6aa00000, 20971520, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x6aa00000
mmap(0x6aa00000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x2e7000) = 0x6aa00000
mmap(0x6ac00000, 1576960, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x2e8000) = 0x6ac00000
mmap(0x6ae00000, 557056, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x469000) = 0x6ae00000
mmap(0x6b000000, 241664, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x4f1000) = 0x6b000000
mmap(0x6b200000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x52c000) = 0x6b200000
mmap(0x6b400000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x53a000) = 0x6b400000
mmap(0x6b600000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x53b000) = 0x6b600000
mmap(0x6b800000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x53c000) = 0x6b800000
mmap(0x6ba00000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x53d000) = 0x6ba00000
mmap(0x6bc00000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 7, 0x53e000) = 0x6bc00000
mprotect(0x6aa00000, 4096, PROT_READ) = 0
mprotect(0x6ac00000, 2097152, PROT_READ|PROT_EXEC) = -1 EACCES (Permission denied)
gettid() = 640
gettid() = 640
getcpu([7], [0], NULL) = 0
futex(0x7ff504602008, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7ff5024e51a0, FUTEX_WAKE_PRIVATE, 2147483647) = 0
write(2, "/opt/mssql/bin/sqlservr: Unable "..., 71/opt/mssql/bin/sqlservr: Unable to start the process, with error 101.
) = 71
futex(0x7ff4fc3b7948, FUTEX_WAKE_PRIVATE, 2147483647) = 0
fstat(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
fstat(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
fstat(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
exit_group(1) = ?
+++ exited with 1 +++
carlosrodfern
thesqlsith
Hello,
I had been doing test with the image mssql/server:2022-latest. I was not able to start the image on my rke2 cluster with a centos 9 os. Since I had done successfull tests with podman, I tought this is clearly a permission issue. Though I did try to grant the pod as many permissions as possible, but the error persists.
The log highlights an error "Found less than 2 threads", but this seems unrelated.
I looked through the internet, but noone seem to have the same error I have and the error "RETAIL ASSERT: Expression=(NT_SUCCESS(status)) File=drtl.cpp Line=1550" doesn`t help me. I am stuck somehow.
My pod spec looks like this: