Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.1.2
-
Windows 10 22H2
Docker version 24.0.5, build ced0996
Docker Compose version v2.20.2-desktop.1
Docker-Compose-File: see Attachments
using MariaDB v. 11.1.2 with docker compose
Image information (uname -a):
Linux 23b7ba3f4fbc 5.4.72-microsoft-standard-WSL2 #1 SMP Wed Oct 28 23:40:43 UTC 2020 x86_64 x86_64 x86_64 GNU/LinuxWindows 10 22H2 Docker version 24.0.5, build ced0996 Docker Compose version v2.20.2-desktop.1 Docker-Compose-File: see Attachments using MariaDB v. 11.1.2 with docker compose Image information (uname -a): Linux 23b7ba3f4fbc 5.4.72-microsoft-standard-WSL2 #1 SMP Wed Oct 28 23:40:43 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
Description
Hi everyone,
I am encountering the following problem:
I have a database which consists of three tables: users, abonnements, and user_abonnements. users and abonnements have unique IDs and user_abonnements is used to model the relation between users and abonnements (see attachment dump.sql). Until each abonnement should now have a starting date (validFrom) and an end date (validTo), I add two columns using the following queries to the table:
alter table user_abonnements |
add validFrom date not null; |
|
|
alter table user_abonnements |
add validTo date null; |
This works just fine. As a user can also subscribe to the same abonnement multiple times (after the first subscription has ended), I want to add "validFrom" to the primary key such that the columns userID, abonnementID, and validFrom are considered as the primary key. However, when trying to drop the current primary key (userID, abonnementID) of the table, the MariaDB-Server crashes (see docker.log) while executing the following query:
alter table user_abonnements |
drop primary key; |
I think the server should return an error, stating that the primary key not be dropped because it is used for foreign keys instead of letting the server crash.
Attachments
Issue Links
- duplicates
-
-
- Closed
-
- relates to
-
-
- Open
-
Activity
Hi,
following information (without the legal and private information) is printed using winver:
Windows 10
|
Microsoft Windows
|
Version 22H2 (Build 19045.3693)
|
Additional Information, which is also printed inside the legal information: I'm using Windows 10 Pro
Running the images provided by you produces the following output:
> docker run quay.io/danielgblack/wsl8443:ubunu2004 strace ./wsl8443
|
execve("./wsl8443", ["./wsl8443"], 0x7ffd66f6f740 /* 3 vars */) = 0
|
brk(NULL) = 0x561546c38000
|
arch_prctl(0x3001 /* ARCH_??? */, 0x7ffcb92054a0) = -1 EINVAL (Invalid argument)
|
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
|
fstat(3, {st_mode=S_IFREG|0644, st_size=8984, ...}) = 0
|
mmap(NULL, 8984, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7ffbf17f3000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libc.so.6", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\300A\2\0\0\0\0\0"..., 832) = 832
|
pread64(3, "\6\0\0\0\4\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 784, 64) = 784
|
pread64(3, "\4\0\0\0\20\0\0\0\5\0\0\0GNU\0\2\0\0\300\4\0\0\0\3\0\0\0\0\0\0\0", 32, 848) = 32
|
pread64(3, "\4\0\0\0\24\0\0\0\3\0\0\0GNU\0\346x\376T\245\322\302\t/\216G\353\v3\20^"..., 68, 880) = 68
|
fstat(3, {st_mode=S_IFREG|0755, st_size=2029592, ...}) = 0
|
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ffbf17f1000
|
pread64(3, "\6\0\0\0\4\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 784, 64) = 784
|
pread64(3, "\4\0\0\0\20\0\0\0\5\0\0\0GNU\0\2\0\0\300\4\0\0\0\3\0\0\0\0\0\0\0", 32, 848) = 32
|
pread64(3, "\4\0\0\0\24\0\0\0\3\0\0\0GNU\0\346x\376T\245\322\302\t/\216G\353\v3\20^"..., 68, 880) = 68
|
mmap(NULL, 2037344, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7ffbf15ff000
|
mmap(0x7ffbf1621000, 1540096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x22000) = 0x7ffbf1621000
|
mmap(0x7ffbf1799000, 319488, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x19a000) = 0x7ffbf1799000
|
mmap(0x7ffbf17e7000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1e7000) = 0x7ffbf17e7000
|
mmap(0x7ffbf17ed000, 13920, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7ffbf17ed000
|
close(3) = 0
|
arch_prctl(ARCH_SET_FS, 0x7ffbf17f2540) = 0
|
mprotect(0x7ffbf17e7000, 16384, PROT_READ) = 0
|
mprotect(0x5615457dd000, 4096, PROT_READ) = 0
|
mprotect(0x7ffbf1823000, 4096, PROT_READ) = 0
|
munmap(0x7ffbf17f3000, 8984) = 0
|
openat(AT_FDCWD, "/tmp/testfile", O_RDWR|O_CREAT|O_EXCL, 0660) = 3
|
write(2, "file /tmp/testfile opened - fd 3"..., 33file /tmp/testfile opened - fd 3
|
) = 33
|
rename("/tmp/testfile", "/tmp/movedtestfile") = 0
|
fstat(3, {st_mode=S_IFREG|0640, st_size=0, ...}) = 0
|
write(2, "stat fd 3 successful\n", 21stat fd 3 successful
|
) = 21
|
close(3) = 0
|
unlink("/tmp/testfile") = -1 ENOENT (No such file or directory)
|
unlink("/tmp/movedtestfile") = 0
|
exit_group(0) = ?
|
+++ exited with 0 +++
|
|
|
> docker run quay.io/danielgblack/wsl8443:ubunu2204 strace ./wsl8443
|
execve("./wsl8443", ["./wsl8443"], 0x7fffd999f8b0 /* 3 vars */) = 0
|
brk(NULL) = 0x560f9ca0c000
|
arch_prctl(0x3001 /* ARCH_??? */, 0x7fff6b4d4080) = -1 EINVAL (Invalid argument)
|
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f22aafd6000
|
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=8735, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 8735, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f22aafd3000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libc.so.6", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P\237\2\0\0\0\0\0"..., 832) = 832
|
pread64(3, "\6\0\0\0\4\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 784, 64) = 784
|
pread64(3, "\4\0\0\0 \0\0\0\5\0\0\0GNU\0\2\0\0\300\4\0\0\0\3\0\0\0\0\0\0\0"..., 48, 848) = 48
|
pread64(3, "\4\0\0\0\24\0\0\0\3\0\0\0GNU\0\244;\374\204(\337f#\315I\214\234\f\256\271\32"..., 68, 896) = 68
|
newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=2216304, ...}, AT_EMPTY_PATH) = 0
|
pread64(3, "\6\0\0\0\4\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 784, 64) = 784
|
mmap(NULL, 2260560, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f22aadab000
|
mmap(0x7f22aadd3000, 1658880, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x28000) = 0x7f22aadd3000
|
mmap(0x7f22aaf68000, 360448, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1bd000) = 0x7f22aaf68000
|
mmap(0x7f22aafc0000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x214000) = 0x7f22aafc0000
|
mmap(0x7f22aafc6000, 52816, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f22aafc6000
|
close(3) = 0
|
mmap(NULL, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f22aada8000
|
arch_prctl(ARCH_SET_FS, 0x7f22aada8740) = 0
|
set_tid_address(0x7f22aada8a10) = 9
|
set_robust_list(0x7f22aada8a20, 24) = 0
|
rseq(0x7f22aada90e0, 0x20, 0, 0x53053053) = 0
|
mprotect(0x7f22aafc0000, 16384, PROT_READ) = 0
|
mprotect(0x560f9b22e000, 4096, PROT_READ) = 0
|
mprotect(0x7f22ab010000, 8192, PROT_READ) = 0
|
prlimit64(0, RLIMIT_STACK, NULL, {rlim_cur=8192*1024, rlim_max=RLIM64_INFINITY}) = 0
|
munmap(0x7f22aafd3000, 8735) = 0
|
openat(AT_FDCWD, "/tmp/testfile", O_RDWR|O_CREAT|O_EXCL, 0660) = 3
|
write(2, "file /tmp/testfile opened - fd 3"..., 33file /tmp/testfile opened - fd 3
|
) = 33
|
rename("/tmp/testfile", "/tmp/movedtestfile") = 0
|
newfstatat(3, "", {st_mode=S_IFREG|0640, st_size=0, ...}, AT_EMPTY_PATH) = 0
|
write(2, "stat fd 3 successful\n", 21stat fd 3 successful
|
) = 21
|
close(3) = 0
|
unlink("/tmp/testfile") = -1 ENOENT (No such file or directory)
|
unlink("/tmp/movedtestfile") = 0
|
exit_group(0) = ?
|
+++ exited with 0 +++
|
For the second test on resolving this, I can't get it to work. Everything works as expected until I will execute the
docker run -d --name mdev32814 -v mdev32814:/var/lib/mysql:z --cap-add=CAP_SYS_PTRACE mariadb:11.1.2 bash -c 'apt-get update && apt-get install -y strace ; gosu mysql strace -f mariadbd'
|
Then I get the windows error stating that the command "apt-get" could not be found - this tells me, Windows tries to execute that on its own system and not inside the docker container. Unfortunately, I'm not that deep inside docker to exactly know how to fix that. I also tried to only run the image and then execute "apt-get update && apt-get install -y strace ; gosu mysql strace -f mariadbd" using interactive shell. This works so far, but when trying to run "mariadb -u mu -pmu mdev32814 -e 'alter table user_abonnements drop primary key;'" inside the container, I get the information, that the table "mdev32814.user_abonnements" does not exist. As I see, this should automatically be imported using the first docker run. If I just import it inside the running mariadb:11.1.2-container using "mariadb -u mu -pmu mdev32814 < ./dump.sql" and then execute "strace mariadb -u mu -pmu mdev32814 -e 'alter table user_abonnements drop primary key;'" I get the following output:
execve("/usr/bin/mariadb", ["mariadb", "-u", "mu", "-pmu", "mdev32814", "-e", "alter table user_abonnements dro"...], 0x7fff1c2ec4c0 /* 11 vars */) = 0
|
brk(NULL) = 0x56536af0f000
|
arch_prctl(0x3001 /* ARCH_??? */, 0x7ffd1c2fdd60) = -1 EINVAL (Invalid argument)
|
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fcbfa9a4000
|
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=7383, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 7383, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fcbfa9a2000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libedit.so.2", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=216376, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 233536, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbfa968000
|
mmap(0x7fcbfa970000, 122880, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x8000) = 0x7fcbfa970000
|
mmap(0x7fcbfa98e000, 53248, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x26000) = 0x7fcbfa98e000
|
mmap(0x7fcbfa99b000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x32000) = 0x7fcbfa99b000
|
mmap(0x7fcbfa99e000, 12352, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fcbfa99e000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libncurses.so.6", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=157776, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 160160, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbfa940000
|
mmap(0x7fcbfa947000, 102400, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7000) = 0x7fcbfa947000
|
mmap(0x7fcbfa960000, 24576, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x20000) = 0x7fcbfa960000
|
mmap(0x7fcbfa966000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x25000) = 0x7fcbfa966000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libtinfo.so.6", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=200136, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 203040, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbfa90e000
|
mmap(0x7fcbfa91c000, 69632, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe000) = 0x7fcbfa91c000
|
mmap(0x7fcbfa92d000, 57344, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1f000) = 0x7fcbfa92d000
|
mmap(0x7fcbfa93b000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2c000) = 0x7fcbfa93b000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libssl.so.3", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=667864, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 669680, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbfa86a000
|
mmap(0x7fcbfa888000, 372736, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1e000) = 0x7fcbfa888000
|
mmap(0x7fcbfa8e3000, 118784, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x79000) = 0x7fcbfa8e3000
|
mmap(0x7fcbfa900000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x95000) = 0x7fcbfa900000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libcrypto.so.3", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=4447536, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 4461760, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbfa428000
|
mmap(0x7fcbfa4da000, 2478080, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xb2000) = 0x7fcbfa4da000
|
mmap(0x7fcbfa737000, 860160, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x30f000) = 0x7fcbfa737000
|
mmap(0x7fcbfa809000, 385024, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3e0000) = 0x7fcbfa809000
|
mmap(0x7fcbfa867000, 9408, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fcbfa867000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libz.so.1", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=108936, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 110776, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbfa40c000
|
mprotect(0x7fcbfa40e000, 98304, PROT_NONE) = 0
|
mmap(0x7fcbfa40e000, 69632, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7fcbfa40e000
|
mmap(0x7fcbfa41f000, 24576, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x7fcbfa41f000
|
mmap(0x7fcbfa426000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x19000) = 0x7fcbfa426000
|
close(3) = 0
|
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fcbfa40a000
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libstdc++.so.6", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=2260296, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 2275520, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbfa1de000
|
mprotect(0x7fcbfa278000, 1576960, PROT_NONE) = 0
|
mmap(0x7fcbfa278000, 1118208, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9a000) = 0x7fcbfa278000
|
mmap(0x7fcbfa389000, 454656, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1ab000) = 0x7fcbfa389000
|
mmap(0x7fcbfa3f9000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x21a000) = 0x7fcbfa3f9000
|
mmap(0x7fcbfa407000, 10432, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fcbfa407000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libc.so.6", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P\237\2\0\0\0\0\0"..., 832) = 832
|
pread64(3, "\6\0\0\0\4\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 784, 64) = 784
|
pread64(3, "\4\0\0\0 \0\0\0\5\0\0\0GNU\0\2\0\0\300\4\0\0\0\3\0\0\0\0\0\0\0"..., 48, 848) = 48
|
pread64(3, "\4\0\0\0\24\0\0\0\3\0\0\0GNU\0i8\235HZ\227\223\333\350s\360\352,\223\340."..., 68, 896) = 68
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=2216304, ...}, AT_EMPTY_PATH) = 0
|
pread64(3, "\6\0\0\0\4\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 784, 64) = 784
|
mmap(NULL, 2260560, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbf9fb6000
|
mmap(0x7fcbf9fde000, 1658880, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x28000) = 0x7fcbf9fde000
|
mmap(0x7fcbfa173000, 360448, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1bd000) = 0x7fcbfa173000
|
mmap(0x7fcbfa1cb000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x214000) = 0x7fcbfa1cb000
|
mmap(0x7fcbfa1d1000, 52816, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fcbfa1d1000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libbsd.so.0", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=89096, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 94432, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbf9f9e000
|
mprotect(0x7fcbf9fa2000, 69632, PROT_NONE) = 0
|
mmap(0x7fcbf9fa2000, 53248, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4000) = 0x7fcbf9fa2000
|
mmap(0x7fcbf9faf000, 12288, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x11000) = 0x7fcbf9faf000
|
mmap(0x7fcbf9fb3000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14000) = 0x7fcbf9fb3000
|
mmap(0x7fcbf9fb5000, 224, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fcbf9fb5000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libm.so.6", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=940560, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 942344, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbf9eb7000
|
mmap(0x7fcbf9ec5000, 507904, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe000) = 0x7fcbf9ec5000
|
mmap(0x7fcbf9f41000, 372736, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x8a000) = 0x7fcbf9f41000
|
mmap(0x7fcbf9f9c000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe4000) = 0x7fcbf9f9c000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libgcc_s.so.1", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=125488, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 127720, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbf9e97000
|
mmap(0x7fcbf9e9a000, 94208, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3000) = 0x7fcbf9e9a000
|
mmap(0x7fcbf9eb1000, 16384, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1a000) = 0x7fcbf9eb1000
|
mmap(0x7fcbf9eb5000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1d000) = 0x7fcbf9eb5000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libmd.so.0", O_RDONLY|O_CLOEXEC) = 3
|
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=47472, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fcbf9e95000
|
mmap(NULL, 49384, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fcbf9e88000
|
mmap(0x7fcbf9e8a000, 28672, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7fcbf9e8a000
|
mmap(0x7fcbf9e91000, 8192, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9000) = 0x7fcbf9e91000
|
mmap(0x7fcbf9e93000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa000) = 0x7fcbf9e93000
|
close(3) = 0
|
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fcbf9e86000
|
mmap(NULL, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fcbf9e83000
|
arch_prctl(ARCH_SET_FS, 0x7fcbf9e83740) = 0
|
set_tid_address(0x7fcbf9e83a10) = 461
|
set_robust_list(0x7fcbf9e83a20, 24) = 0
|
rseq(0x7fcbf9e840e0, 0x20, 0, 0x53053053) = 0
|
mprotect(0x7fcbfa1cb000, 16384, PROT_READ) = 0
|
mprotect(0x7fcbf9e93000, 4096, PROT_READ) = 0
|
mprotect(0x7fcbf9eb5000, 4096, PROT_READ) = 0
|
mprotect(0x7fcbf9f9c000, 4096, PROT_READ) = 0
|
mprotect(0x7fcbf9fb3000, 4096, PROT_READ) = 0
|
mprotect(0x7fcbfa3f9000, 45056, PROT_READ) = 0
|
mprotect(0x7fcbfa426000, 4096, PROT_READ) = 0
|
mprotect(0x7fcbfa809000, 372736, PROT_READ) = 0
|
mprotect(0x7fcbfa900000, 40960, PROT_READ) = 0
|
mprotect(0x7fcbfa93b000, 16384, PROT_READ) = 0
|
mprotect(0x7fcbfa966000, 4096, PROT_READ) = 0
|
mprotect(0x7fcbfa99b000, 8192, PROT_READ) = 0
|
mprotect(0x56536ac56000, 69632, PROT_READ) = 0
|
mprotect(0x7fcbfa9de000, 8192, PROT_READ) = 0
|
prlimit64(0, RLIMIT_STACK, NULL, {rlim_cur=8192*1024, rlim_max=RLIM64_INFINITY}) = 0
|
munmap(0x7fcbfa9a2000, 7383) = 0
|
getrandom("\x36\x07\x19\x42\x6a\xe3\x93\x5b", 8, GRND_NONBLOCK) = 8
|
brk(NULL) = 0x56536af0f000
|
brk(0x56536af30000) = 0x56536af30000
|
ioctl(0, TCGETS, {B38400 opost isig icanon echo ...}) = 0
|
ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0
|
dup(1) = 3
|
close(3) = 0
|
newfstatat(AT_FDCWD, "/etc/my.cnf", 0x7ffd1c2fa560, 0) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/etc/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=1127, ...}, 0) = 0
|
openat(AT_FDCWD, "/etc/mysql/my.cnf", O_RDONLY|O_CLOEXEC) = 3
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=1127, ...}, AT_EMPTY_PATH) = 0
|
read(3, "# The MariaDB configuration file"..., 4096) = 1127
|
openat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/", O_RDONLY|O_NONBLOCK|O_CLOEXEC|O_DIRECTORY) = 4
|
newfstatat(4, "", {st_mode=S_IFDIR|0755, st_size=4096, ...}, AT_EMPTY_PATH) = 0
|
brk(0x56536af55000) = 0x56536af55000
|
getdents64(4, 0x56536af228c0 /* 8 entries */, 32768) = 312
|
getdents64(4, 0x56536af228c0 /* 0 entries */, 32768) = 0
|
close(4) = 0
|
newfstatat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/05-skipcache.cnf", {st_mode=S_IFREG|0644, st_size=46, ...}, 0) = 0
|
openat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/05-skipcache.cnf", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=46, ...}, AT_EMPTY_PATH) = 0
|
read(4, "[mariadb]\nhost-cache-size=0\nskip"..., 4096) = 46
|
read(4, "", 4096) = 0
|
close(4) = 0
|
newfstatat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/50-client.cnf", {st_mode=S_IFREG|0644, st_size=575, ...}, 0) = 0
|
openat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/50-client.cnf", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=575, ...}, AT_EMPTY_PATH) = 0
|
read(4, "#\n# This group is read by the cl"..., 4096) = 575
|
read(4, "", 4096) = 0
|
close(4) = 0
|
newfstatat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/50-mariadb-clients.cnf", {st_mode=S_IFREG|0644, st_size=263, ...}, 0) = 0
|
openat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/50-mariadb-clients.cnf", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=263, ...}, AT_EMPTY_PATH) = 0
|
read(4, "#\n# These groups are read by Mar"..., 4096) = 263
|
read(4, "", 4096) = 0
|
close(4) = 0
|
newfstatat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/50-server.cnf", {st_mode=S_IFREG|0644, st_size=3567, ...}, 0) = 0
|
openat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/50-server.cnf", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=3567, ...}, AT_EMPTY_PATH) = 0
|
read(4, "#\n# These groups are read by Mar"..., 4096) = 3567
|
read(4, "", 4096) = 0
|
close(4) = 0
|
newfstatat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/60-galera.cnf", {st_mode=S_IFREG|0644, st_size=572, ...}, 0) = 0
|
openat(AT_FDCWD, "/etc/mysql/mariadb.conf.d/60-galera.cnf", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=572, ...}, AT_EMPTY_PATH) = 0
|
read(4, "#\n# * Galera-related settings\n#\n"..., 4096) = 572
|
read(4, "", 4096) = 0
|
close(4) = 0
|
brk(0x56536af4b000) = 0x56536af4b000
|
openat(AT_FDCWD, "/etc/mysql/conf.d/", O_RDONLY|O_NONBLOCK|O_CLOEXEC|O_DIRECTORY) = 4
|
newfstatat(4, "", {st_mode=S_IFDIR|0755, st_size=4096, ...}, AT_EMPTY_PATH) = 0
|
getdents64(4, 0x56536af2a9b0 /* 2 entries */, 32768) = 48
|
getdents64(4, 0x56536af2a9b0 /* 0 entries */, 32768) = 0
|
close(4) = 0
|
read(3, "", 4096) = 0
|
close(3) = 0
|
newfstatat(AT_FDCWD, "/root/.my.cnf", 0x7ffd1c2fa560, 0) = -1 ENOENT (No such file or directory)
|
socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
|
connect(3, {sa_family=AF_UNIX, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
|
close(3) = 0
|
socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
|
connect(3, {sa_family=AF_UNIX, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
|
close(3) = 0
|
newfstatat(AT_FDCWD, "/etc/nsswitch.conf", {st_mode=S_IFREG|0644, st_size=494, ...}, 0) = 0
|
newfstatat(AT_FDCWD, "/", {st_mode=S_IFDIR|0755, st_size=4096, ...}, 0) = 0
|
openat(AT_FDCWD, "/etc/nsswitch.conf", O_RDONLY|O_CLOEXEC) = 3
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=494, ...}, AT_EMPTY_PATH) = 0
|
read(3, "# /etc/nsswitch.conf\n#\n# Example"..., 4096) = 494
|
read(3, "", 4096) = 0
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=494, ...}, AT_EMPTY_PATH) = 0
|
close(3) = 0
|
openat(AT_FDCWD, "/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=7383, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 7383, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fcbfa9a2000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/glibc-hwcaps/x86-64-v3/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/glibc-hwcaps/x86-64-v3", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/glibc-hwcaps/x86-64-v2/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/glibc-hwcaps/x86-64-v2", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/tls/haswell/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/tls/haswell/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/tls/haswell/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/tls/haswell", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/tls/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/tls/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/tls/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/tls", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/haswell/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/haswell/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/haswell/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/haswell", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64-linux-gnu", {st_mode=S_IFDIR|0755, st_size=4096, ...}, 0) = 0
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/glibc-hwcaps/x86-64-v3/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/glibc-hwcaps/x86-64-v3", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/glibc-hwcaps/x86-64-v2/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/glibc-hwcaps/x86-64-v2", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/tls/haswell/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/tls/haswell/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/tls/haswell/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/tls/haswell", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/tls/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/tls/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/tls/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/tls", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/haswell/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/haswell/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/haswell/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/haswell", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu", {st_mode=S_IFDIR|0755, st_size=4096, ...}, 0) = 0
|
openat(AT_FDCWD, "/lib/glibc-hwcaps/x86-64-v3/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/glibc-hwcaps/x86-64-v3", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/glibc-hwcaps/x86-64-v2/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/glibc-hwcaps/x86-64-v2", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/tls/haswell/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/tls/haswell/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/tls/haswell/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/tls/haswell", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/tls/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/tls/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/tls/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/tls", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/haswell/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/haswell/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/haswell/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/haswell", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/lib", {st_mode=S_IFDIR|0755, st_size=4096, ...}, 0) = 0
|
openat(AT_FDCWD, "/usr/lib/glibc-hwcaps/x86-64-v3/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/glibc-hwcaps/x86-64-v3", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/glibc-hwcaps/x86-64-v2/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/glibc-hwcaps/x86-64-v2", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/tls/haswell/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/tls/haswell/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/tls/haswell/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/tls/haswell", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/tls/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/tls/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/tls/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/tls", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/haswell/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/haswell/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/haswell/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/haswell", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib/x86_64", 0x7ffd1c2fccd0, 0) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/libnss_db.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
newfstatat(AT_FDCWD, "/usr/lib", {st_mode=S_IFDIR|0755, st_size=4096, ...}, 0) = 0
|
munmap(0x7fcbfa9a2000, 7383) = 0
|
openat(AT_FDCWD, "/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=7383, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 7383, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fcbfa9a2000
|
close(3) = 0
|
openat(AT_FDCWD, "/lib/x86_64-linux-gnu/libnss_db-2.35.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/libnss_db-2.35.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/lib/libnss_db-2.35.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/libnss_db-2.35.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
munmap(0x7fcbfa9a2000, 7383) = 0
|
openat(AT_FDCWD, "/etc/services", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
futex(0x7fcbfa866ba4, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866ba0, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866b9c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866ef0, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866b94, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866b90, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866778, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866a00, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866748, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866b98, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
openat(AT_FDCWD, "/usr/lib/ssl/openssl.cnf", O_RDONLY) = 3
|
futex(0x7fcbfa8664d0, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=12419, ...}, AT_EMPTY_PATH) = 0
|
read(3, "#\n# OpenSSL example configuratio"..., 4096) = 4096
|
read(3, "r type CA, the listed attributes"..., 4096) = 4096
|
read(3, "r:copy\n\n# DER hex encoding of an"..., 4096) = 4096
|
read(3, "ertout # insta.cert.pem\n\n[ssl_se"..., 4096) = 131
|
read(3, "", 4096) = 0
|
close(3) = 0
|
futex(0x7fcbfa866920, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866b80, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866b7c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa86670c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa866b8c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
futex(0x7fcbfa90d7c0, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
sysinfo({uptime=21962, loads=[0, 256, 0], totalram=16732278784, freeram=12907925504, sharedram=14331904, bufferram=447094784, totalswap=4294967296, freeswap=4294967296, procs=714, totalhigh=0, freehigh=0, mem_unit=1}) = 0
|
futex(0x7fcbfa90d7d4, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
rt_sigaction(SIGPIPE, {sa_handler=SIG_IGN, sa_mask=[PIPE], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fcbf9ff8520}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
|
futex(0x56536ad16ed4, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/locale-archive", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/share/locale/locale.alias", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_CTYPE", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_CTYPE", O_RDONLY|O_CLOEXEC) = 3
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=353616, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 353616, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fcbf9e2c000
|
close(3) = 0
|
openat(AT_FDCWD, "/usr/lib/x86_64-linux-gnu/gconv/gconv-modules.cache", O_RDONLY) = 3
|
newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=27002, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 27002, PROT_READ, MAP_SHARED, 3, 0) = 0x7fcbf9e25000
|
close(3) = 0
|
futex(0x7fcbfa1d0a6c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
getpid() = 461
|
socket(AF_UNIX, SOCK_STREAM, 0) = 3
|
fcntl(3, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
|
connect(3, {sa_family=AF_UNIX, sun_path="/run/mysqld/mysqld.sock"}, 110) = 0
|
clock_nanosleep(CLOCK_REALTIME, 0, {tv_sec=0, tv_nsec=1000}, NULL) = 0
|
fcntl(3, F_SETFL, O_RDONLY) = 0
|
setsockopt(3, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
|
setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
|
recvfrom(3, "i\0\0\0\n11.1.2-MariaDB-1:11.1.2+mar"..., 16384, MSG_DONTWAIT, NULL, NULL) = 109
|
sendto(3, "\276\0\0\1\214\242\277\0\0\0\0\1!\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 194, MSG_DONTWAIT|MSG_NOSIGNAL, NULL, 0) = 194
|
recvfrom(3, "\25\0\0\2\0\0\0\2@\0\0\0\f\1\n\tmdev32814", 16384, MSG_DONTWAIT, NULL, NULL) = 25
|
setsockopt(3, SOL_SOCKET, SO_RCVTIMEO_OLD, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
|
setsockopt(3, SOL_SOCKET, SO_SNDTIMEO_OLD, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
|
brk(0x56536af6c000) = 0x56536af6c000
|
brk(0x56536af8d000) = 0x56536af8d000
|
brk(0x56536afae000) = 0x56536afae000
|
brk(0x56536afcf000) = 0x56536afcf000
|
brk(0x56536aff0000) = 0x56536aff0000
|
newfstatat(AT_FDCWD, "/usr/share/mariadb/charsets/Index.xml", {st_mode=S_IFREG|0644, st_size=23509, ...}, 0) = 0
|
openat(AT_FDCWD, "/usr/share/mariadb/charsets/Index.xml", O_RDONLY|O_CLOEXEC) = 4
|
read(4, "<?xml version='1.0' encoding=\"ut"..., 23509) = 23509
|
close(4) = 0
|
futex(0x56536ad28b40, FUTEX_WAKE_PRIVATE, 2147483647) = 0
|
rt_sigaction(SIGINT, {sa_handler=0x56536a85c230, sa_mask=[INT], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fcbf9ff8520}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
|
rt_sigaction(SIGQUIT, {sa_handler=0x56536a85bf60, sa_mask=[QUIT], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fcbf9ff8520}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
|
rt_sigaction(SIGWINCH, {sa_handler=0x56536a859c60, sa_mask=[WINCH], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fcbf9ff8520}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
|
ioctl(0, TIOCGWINSZ, {ws_row=45, ws_col=251, ws_xpixel=0, ws_ypixel=0}) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_IDENTIFICATION", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_IDENTIFICATION", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=258, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 258, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbfa9dd000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_MEASUREMENT", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_MEASUREMENT", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=23, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 23, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbfa9a3000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_TELEPHONE", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_TELEPHONE", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=47, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 47, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbfa9a2000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_ADDRESS", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_ADDRESS", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=127, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 127, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbf9e24000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_NAME", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_NAME", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=62, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 62, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbf9e23000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_PAPER", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_PAPER", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=34, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 34, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbf9e22000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_MESSAGES", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_MESSAGES", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFDIR|0755, st_size=4096, ...}, AT_EMPTY_PATH) = 0
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_MESSAGES/SYS_LC_MESSAGES", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=48, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 48, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbf9e21000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_MONETARY", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_MONETARY", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=270, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 270, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbf9e20000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_COLLATE", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_COLLATE", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=1406, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 1406, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbf9e1f000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_TIME", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_TIME", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=3360, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 3360, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbf9e1e000
|
close(4) = 0
|
openat(AT_FDCWD, "/usr/lib/locale/C.UTF-8/LC_NUMERIC", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
|
openat(AT_FDCWD, "/usr/lib/locale/C.utf8/LC_NUMERIC", O_RDONLY|O_CLOEXEC) = 4
|
newfstatat(4, "", {st_mode=S_IFREG|0644, st_size=50, ...}, AT_EMPTY_PATH) = 0
|
mmap(NULL, 50, PROT_READ, MAP_PRIVATE, 4, 0) = 0x7fcbf9e1d000
|
close(4) = 0
|
sendto(3, ".\0\0\0\3alter table user_abonnement"..., 50, MSG_DONTWAIT|MSG_NOSIGNAL, NULL, 0) = 50
|
recvfrom(3, 0x56536af3ed00, 16384, MSG_DONTWAIT, NULL, NULL) = -1 EAGAIN (Resource temporarily unavailable)
|
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
|
recvfrom(3, "\27\0\0\1\377\377\377\1\2\2\0\0\0\rEnabling keys", 16384, MSG_DONTWAIT, NULL, NULL) = 27
|
recvfrom(3, 0x56536af3ed00, 16384, MSG_DONTWAIT, NULL, NULL) = -1 EAGAIN (Resource temporarily unavailable)
|
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
|
recvfrom(3, "\226\0\0\2\377\1\4#HY000Error on rename of "..., 16384, MSG_DONTWAIT, NULL, NULL) = 154
|
write(2, "ERROR", 5ERROR) = 5
|
write(2, " 1025 (HY000)", 13 1025 (HY000)) = 13
|
write(2, " at line 1", 10 at line 1) = 10
|
write(2, ": Error on rename of './mdev3281"..., 144: Error on rename of './mdev32814/#sql-alter-1-7' to './mdev32814/user_abonnements' (errno: 150 "Foreign key constraint is incorrectly formed")
|
) = 144
|
rt_sigaction(SIGQUIT, {sa_handler=SIG_IGN, sa_mask=[QUIT], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fcbf9ff8520}, {sa_handler=0x56536a85bf60, sa_mask=[QUIT], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fcbf9ff8520}, 8) = 0
|
rt_sigaction(SIGINT, {sa_handler=SIG_IGN, sa_mask=[INT], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fcbf9ff8520}, {sa_handler=0x56536a85c230, sa_mask=[INT], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7fcbf9ff8520}, 8) = 0
|
sendto(3, "\1\0\0\0\1", 5, MSG_DONTWAIT|MSG_NOSIGNAL, NULL, 0) = 5
|
close(3) = 0
|
brk(0x56536af5d000) = 0x56536af5d000
|
exit_group(1) = ?
|
+++ exited with 1 +++
|
Hope this helps. If you need further assistance, feel free to ask.
Thank you. First test are either wsl8443 is fixes in the Windows version you have or there's some other aspect of environment at play.
Yes, just the Winversion was desired thanks.
Seems I've no idea about powershell escaping. The one big arg 'apt-get upda ...' needs to be a single string without any powershell interpretation.
Sorry, the strace of the client isn't very useful. If you don't work it out (and don't spend too much time on it), I'll make a container that has strace installed and ready to run.
Hi,
sorry for the late reply. After you wrote that you seem to have "no idea about powershell escaping" I retried it with Powershell and I seem to be able to reproduce the strace output you requested. The output is not exactly the same, but a lot of the strace seems to match. Unfortunately, I am not able to read straces, but feel free to take a look and check the differences by yourself:
2023-11-30 22:10:18 [pid 367] recvfrom(46, "\3alter table user_abonnements dr"..., 46, MSG_DONTWAIT, NULL, NULL) = 46
|
2023-11-30 22:10:18 [pid 367] openat(AT_FDCWD, "./mdev32814/user_abonnements.frm", O_RDONLY|O_CLOEXEC) = 47
|
2023-11-30 22:10:18 [pid 367] read(47, "\376\1\n\f\26\0Z\0\1\0\255\5\0\0\342\3\t\0\0\0\0\0\0\0\0\0\0\2h\0\10\0"..., 64) = 64
|
2023-11-30 22:10:18 [pid 367] read(47, "\0\20K\372\21\t\217\304\21\356\272\30\2B\254\21\0\2\5\2\0\0U\4\0\0\2\3\0\0007\0"..., 1389) = 1389
|
2023-11-30 22:10:18 [pid 367] close(47) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084021000, 8192, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084023000, 4096, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.frm", {st_mode=S_IFREG|0660, st_size=1453, ...}, 0) = 0
|
2023-11-30 22:10:18 [pid 367] access("./mdev32814/user_abonnements.TRG", F_OK) = -1 ENOENT (No such file or directory)
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084024000, 32768, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] openat(AT_FDCWD, "./mysql/index_stats.frm", O_RDONLY|O_CLOEXEC) = 47
|
2023-11-30 22:10:18 [pid 367] read(47, "\376\1\n*\25\0Y\0\1\0^\6\0\0\371\1N\2\0\0\0\0\0\0\0\0\0\2<\0\t\0"..., 64) = 64
|
2023-11-30 22:10:18 [pid 367] read(47, "\0\20H\332\25\211\217\304\21\356\264\34\2B\254\21\0\2\5\1\0\256\4\0\0\1\4\0\0\n\0*"..., 1566) = 1566
|
2023-11-30 22:10:18 [pid 367] close(47) = 0
|
2023-11-30 22:10:18 [pid 367] getcwd("/var/lib/mysql", 1024) = 15
|
2023-11-30 22:10:18 [pid 367] readlink("/var/lib/mysql/mysql", 0x7f70e411cad0, 1023) = -1 EINVAL (Invalid argument)
|
2023-11-30 22:10:18 [pid 367] readlink("/var/lib/mysql/mysql/index_stats.MAI", 0x7f70e411cad0, 1023) = -1 EINVAL (Invalid argument)
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mysql/index_stats.MAI", {st_mode=S_IFREG|0660, st_size=8192, ...}, AT_SYMLINK_NOFOLLOW) = 0
|
2023-11-30 22:10:18 [pid 367] openat(-1, "/var", O_RDONLY|O_NOFOLLOW|O_CLOEXEC|O_PATH) = 47
|
2023-11-30 22:10:18 [pid 367] openat(47, "lib", O_RDONLY|O_NOFOLLOW|O_CLOEXEC|O_PATH) = 48
|
2023-11-30 22:10:18 [pid 367] close(47) = 0
|
2023-11-30 22:10:18 [pid 367] openat(48, "mysql", O_RDONLY|O_NOFOLLOW|O_CLOEXEC|O_PATH) = 47
|
2023-11-30 22:10:18 [pid 367] close(48) = 0
|
2023-11-30 22:10:18 [pid 367] openat(47, "mysql", O_RDONLY|O_NOFOLLOW|O_CLOEXEC|O_PATH) = 48
|
2023-11-30 22:10:18 [pid 367] close(47) = 0
|
2023-11-30 22:10:18 [pid 367] openat(48, "index_stats.MAI", O_RDWR|O_NOFOLLOW|O_CLOEXEC) = 47
|
2023-11-30 22:10:18 [pid 367] close(48) = 0
|
2023-11-30 22:10:18 [pid 367] pread64(47, "\376\376\t\3\f\2\2\\\0\327\0\207\1\23\0\4\0\0\1\0\0\0\3\3", 24, 0) = 24
|
2023-11-30 22:10:18 [pid 367] readlink("./mysql/index_stats.MAI", 0x7f70e411f150, 511) = -1 EINVAL (Invalid argument)
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mysql/index_stats.MAD", {st_mode=S_IFREG|0660, st_size=8192, ...}, AT_SYMLINK_NOFOLLOW) = 0
|
2023-11-30 22:10:18 [pid 367] pread64(47, "\376\376\t\3\f\2\2\\\0\327\0\207\1\23\0\4\0\0\1\0\0\0\3\3\0\0\0\0\0\0\0\0"..., 604, 0) = 604
|
2023-11-30 22:10:18 [pid 367] openat(AT_FDCWD, "./mysql/index_stats.MAD", O_RDWR|O_CLOEXEC) = 48
|
2023-11-30 22:10:18 [pid 367] getpid() = 342
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f708402c000, 4096, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f708402d000, 4096, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] access("./mysql/index_stats.TRG", F_OK) = -1 ENOENT (No such file or directory)
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\2\20\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\335I\344\363\217\304\21\356\274\17\2B\254\21"..., 4096, 4096) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\1\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096, 8192) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\2\21\0\0\1\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096, 12288) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\1\0\0\0\3\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096, 8192) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] openat(AT_FDCWD, "./mdev32814/#sql-alter-156-3.frm", O_RDWR|O_CREAT|O_TRUNC|O_CLOEXEC, 0660) = 49
|
2023-11-30 22:10:18 [pid 367] write(49, "\376\1\n\f\25\0Y\0\1\0\303\3\0\0\371\1\t\0\0\0\0\0\0\0\0\0\0\2F\0\10\0"..., 963) = 963
|
2023-11-30 22:10:18 [pid 367] fdatasync(49) = 0
|
2023-11-30 22:10:18 [pid 367] openat(AT_FDCWD, "./mdev32814/", O_RDONLY|O_CLOEXEC) = 50
|
2023-11-30 22:10:18 [pid 367] fdatasync(50) = 0
|
2023-11-30 22:10:18 [pid 367] close(50) = 0
|
2023-11-30 22:10:18 [pid 367] close(49) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f708402e000, 4096, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f708402f000, 4096, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\5", 1, 4098) = 1
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084030000, 4096, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084031000, 4096, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084032000, 4096, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814", {st_mode=S_IFDIR|0700, st_size=4096, ...}, 0) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "\316\260\22\5\0./mysql/innodb_index_stats."..., 4096, 61440) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] openat(AT_FDCWD, "./mdev32814/#sql-alter-156-3.ibd", O_RDWR|O_CREAT|O_EXCL|O_CLOEXEC, 0660) = 49
|
2023-11-30 22:10:18 [pid 367] fcntl(49, F_SETFL, O_RDONLY|O_DIRECT) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(49, "", {st_mode=S_IFREG|0660, st_size=0, ...}, AT_EMPTY_PATH) = 0
|
2023-11-30 22:10:18 [pid 367] fallocate(49, 0, 0, 65536) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(49, "", {st_mode=S_IFREG|0660, st_size=65536, ...}, AT_EMPTY_PATH) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(49, "", {st_mode=S_IFREG|0660, st_size=65536, ...}, AT_EMPTY_PATH) = 0
|
2023-11-30 22:10:18 [pid 367] fallocate(49, 0, 65536, 16384) = 0
|
2023-11-30 22:10:18 [pid 367] fdatasync(49) = 0
|
2023-11-30 22:10:18 [pid 367] fdatasync(49) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084033000, 12288, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "\316\260\22\5\0./mysql/innodb_index_stats."..., 4096, 61440) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084036000, 12288, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "\316\260\22\5\0./mysql/innodb_index_stats."..., 8192, 61440) = 8192
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/#sql-alter-156-3.frm", {st_mode=S_IFREG|0660, st_size=963, ...}, 0) = 0
|
2023-11-30 22:10:18 [pid 367] sendto(46, "\27\0\0\1\377\377\377\1\2\2\0\0\0\rEnabling keys", 27, MSG_DONTWAIT, NULL, 0) = 27
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "tID_fkn_diff_pfx01\0\0\0\0\0,\204\0\0\0.\2\ve"..., 4096, 65536) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\6", 1, 4098) = 1
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.ibd", {st_mode=S_IFREG|0660, st_size=114688, ...}, 0) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/#sql-backup-156-3.ibd", 0x7f70e4122580, 0) = -1 ENOENT (No such file or directory)
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "tID_fkn_diff_pfx01\0\0\0\0\0,\204\0\0\0.\2\ve"..., 4096, 65536) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] rename("./mdev32814/user_abonnements.ibd", "./mdev32814/#sql-backup-156-3.ibd") = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "tID_fkn_diff_pfx01\0\0\0\0\0,\204\0\0\0.\2\ve"..., 4096, 65536) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] rename("./mdev32814/user_abonnements.frm", "./mdev32814/#sql-backup-156-3.frm") = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\7", 1, 4098) = 1
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084039000, 8192, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f708403b000, 8192, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/#sql-alter-156-3.ibd", {st_mode=S_IFREG|0660, st_size=81920, ...}, 0) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.ibd", 0x7f70e4122580, 0) = -1 ENOENT (No such file or directory)
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "tID_fkn_diff_pfx01\0\0\0\0\0,\204\0\0\0.\2\ve"..., 4096, 65536) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] rename("./mdev32814/#sql-alter-156-3.ibd", "./mdev32814/user_abonnements.ibd") = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(16, "", {st_mode=S_IFREG|0600, st_size=0, ...}, AT_EMPTY_PATH) = 0
|
2023-11-30 22:10:18 [pid 367] lseek(16, 0, SEEK_SET) = 0
|
2023-11-30 22:10:18 [pid 367] write(2, "2023-11-30 21:10:18 3 [ERROR] In"..., 1882023-11-30 21:10:18 3 [ERROR] InnoDB: In ALTER TABLE `mdev32814`.`user_abonnements` has or is referenced in foreign key constraints which are not compatible with the new table definition.
|
2023-11-30 22:10:18 ) = 188
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.ibd", {st_mode=S_IFREG|0660, st_size=81920, ...}, 0) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "tID_fkn_diff_pfx01\0\0\0\0\0,\204\0\0\0.\2\ve"..., 4096, 65536) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] rename("./mdev32814/user_abonnements.ibd", "./mdev32814/#sql-alter-156-3.ibd") = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\1", 1, 4098) = 1
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "tID_fkn_diff_pfx01\0\0\0\0\0,\204\0\0\0.\2\ve"..., 8192, 65536) = 8192
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "G\0\tmdev32814\1\31#mysql50##sql-alte"..., 4096, 69632) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] unlink("./mdev32814/#sql-alter-156-3.cfg") = -1 ENOENT (No such file or directory)
|
2023-11-30 22:10:18 [pid 367] unlink("./mdev32814/#sql-alter-156-3.ibd") = 0
|
2023-11-30 22:10:18 [pid 367] close(49) = 0
|
2023-11-30 22:10:18 [pid 367] unlink("./mdev32814/#sql-alter-156-3.frm") = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f708403d000, 8192, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f708403f000, 8192, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] mprotect(0x7f7084041000, 8192, PROT_READ|PROT_WRITE) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/#sql-backup-156-3.ibd", {st_mode=S_IFREG|0660, st_size=114688, ...}, 0) = 0
|
2023-11-30 22:10:18 [pid 367] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.ibd", 0x7f70e4122580, 0) = -1 ENOENT (No such file or directory)
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "G\0\tmdev32814\1\31#mysql50##sql-alte"..., 4096, 69632) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] rename("./mdev32814/#sql-backup-156-3.ibd", "./mdev32814/user_abonnements.ibd") = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(15, "G\0\tmdev32814\1\31#mysql50##sql-alte"..., 4096, 69632) = 4096
|
2023-11-30 22:10:18 [pid 367] fdatasync(15) = 0
|
2023-11-30 22:10:18 [pid 367] rename("./mdev32814/#sql-backup-156-3.frm", "./mdev32814/user_abonnements.frm") = 0
|
2023-11-30 22:10:18 [pid 367] pwrite64(3, "\3", 1, 8192) = 1
|
2023-11-30 22:10:18 [pid 367] fdatasync(3) = 0
|
2023-11-30 22:10:18 [pid 367] sendto(46, "\230\0\0\2\377\1\4#HY000Error on rename of "..., 156, MSG_DONTWAIT, NULL, 0) = 156
|
2023-11-30 22:10:18 [pid 367] recvfrom(46, "\1\0\0\0", 4, MSG_DONTWAIT, NULL, NULL) = 4
|
2023-11-30 22:10:18 [pid 367] recvfrom(46, "\1", 1, MSG_DONTWAIT, NULL, NULL) = 1
|
2023-11-30 22:10:18 [pid 367] close(46) = 0
|
Hope this helps you to go any further with this issue.
wsl issue 8443
Thanks maaaak, that's what I asked you to produce and I assume this was executed in the same way as your original problem.
So you got the same docker output that I got when I did the Windows test. The original wsl8443 bug was under an ubuntu focal and had fstat library call implemented as the fstat system call. As a confirmation or not of the original wsl8443 problem can you produce the following.
docker run quay.io/danielgblack/wsl8443:ubunu2004 strace ./wsl8443docker run quay.io/danielgblack/wsl8443:ubunu2204 strace ./wsl8443(yes mistyped the tag name when pushed, oh well)
Can I get your winver.exe information too please?
There was also some differentiation in wsl 8443 of Docker desktop vs dockerd inside WSL. Maybe this was simply the difference of a Ubuntu focal vs Ubuntu jammy base and the different syscall?
On resolving this
I did fork of the bug MDEV-32840, as when a FK error is emitted the underlying server shouldn't be contining to do the alter.
Assuming its the same pattern as WSL 8443 in that some system calls have unexpected results leading MariaDB into an untested code path and crashing, this is what I've done on Linux to get a baseline (of something that doesn't crash).
mkdir /tmp/dmv dump.sql /tmp/dpodman volume create mdev32814podman run -d --name mdev32814 -v /tmp/d:/docker-entrypoint-initdb.d:z --env MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=1 --env MARIADB_USER=mu --env MARIADB_PASSWORD=mu --env MARIADB_DATABASE=mdev32814 -v mdev32814:/var/lib/mysql --cap-add=CAP_SYS_PTRACE mariadb:11.1.2podman stop mdev32814podman rm mdev32814podman run -d --name mdev32814 -v mdev32814:/var/lib/mysql:z --cap-add=CAP_SYS_PTRACE mariadb:11.1.2 sh -c 'apt-get update && apt-get install -y strace ; gosu mysql strace -f mariadbd'strace of: podman exec mdev32814 mariadb -u mu -pmu mdev32814 -e 'alter table user_abonnements drop primary key;'
[pid 355] recvfrom(45, "\3alter table user_abonnements dr"..., 46, MSG_DONTWAIT, NULL, NULL) = 46[pid 355] openat(AT_FDCWD, "./mdev32814/user_abonnements.frm", O_RDONLY|O_CLOEXEC) = 46[pid 355] read(46, "\376\1\n\f\26\0Z\0\1\0\255\5\0\0\342\3\t\0\0\0\0\0\0\0\0\0\0\2h\0\10\0"..., 64) = 64[pid 355] read(46, "\0\20\0371\25\177\207*\21\356\244A\332\313\6~a\337\5\2\0\0U\4\0\0\2\3\0\0007\0"..., 1389) = 1389[pid 355] close(46) = 0[pid 355] mprotect(0x7fa1e8021000, 8192, PROT_READ|PROT_WRITE) = 0[pid 355] mprotect(0x7fa1e8023000, 4096, PROT_READ|PROT_WRITE) = 0[pid 355] pwrite64(14, "\5\n\236&\4\3\t\0\2I\1<\310\315\322&\5\3\t\0\6e\1\360\214\206\31&\5\3\t\0"..., 2048, 72192) = 2048[pid 355] fdatasync(14) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.frm", {st_mode=S_IFREG|0660, st_size=1453, ...}, 0) = 0[pid 355] access("./mdev32814/user_abonnements.TRG", F_OK) = -1 ENOENT (No such file or directory)[pid 355] mprotect(0x7fa1e8024000, 32768, PROT_READ|PROT_WRITE) = 0[pid 355] openat(AT_FDCWD, "./mysql/index_stats.frm", O_RDONLY|O_CLOEXEC) = 46[pid 355] read(46, "\376\1\n*\25\0Y\0\1\0^\6\0\0\371\1N\2\0\0\0\0\0\0\0\0\0\2<\0\t\0"..., 64) = 64[pid 355] read(46, "\0\20\35\363\205~\207*\21\356\242\344\332\313\6~a\337\5\1\0\256\4\0\0\1\4\0\0\n\0*"..., 1566) = 1566[pid 355] close(46) = 0[pid 355] getcwd("/var/lib/mysql", 1024) = 15[pid 355] readlink("/var/lib/mysql/mysql", 0x7fa2540b9ad0, 1023) = -1 EINVAL (Invalid argument)[pid 355] readlink("/var/lib/mysql/mysql/index_stats.MAI", 0x7fa2540b9ad0, 1023) = -1 EINVAL (Invalid argument)[pid 355] newfstatat(AT_FDCWD, "./mysql/index_stats.MAI", {st_mode=S_IFREG|0660, st_size=8192, ...}, AT_SYMLINK_NOFOLLOW) = 0[pid 355] openat(-1, "/var", O_RDONLY|O_NOFOLLOW|O_CLOEXEC|O_PATH) = 46[pid 355] openat(46, "lib", O_RDONLY|O_NOFOLLOW|O_CLOEXEC|O_PATH) = 47[pid 355] close(46) = 0[pid 355] openat(47, "mysql", O_RDONLY|O_NOFOLLOW|O_CLOEXEC|O_PATH) = 46[pid 355] close(47) = 0[pid 355] openat(46, "mysql", O_RDONLY|O_NOFOLLOW|O_CLOEXEC|O_PATH) = 47[pid 355] close(46) = 0[pid 355] openat(47, "index_stats.MAI", O_RDWR|O_NOFOLLOW|O_CLOEXEC) = 46[pid 355] close(47) = 0[pid 355] pread64(46, "\376\376\t\3\f\2\2\\\0\327\0\207\1\23\0\4\0\0\1\0\0\0\3\3", 24, 0) = 24[pid 355] readlink("./mysql/index_stats.MAI", 0x7fa2540bc150, 511) = -1 EINVAL (Invalid argument)[pid 355] newfstatat(AT_FDCWD, "./mysql/index_stats.MAD", {st_mode=S_IFREG|0660, st_size=8192, ...}, AT_SYMLINK_NOFOLLOW) = 0[pid 355] pread64(46, "\376\376\t\3\f\2\2\\\0\327\0\207\1\23\0\4\0\0\1\0\0\0\3\3\0\0\0\0\0\0\0\0"..., 604, 0) = 604[pid 355] openat(AT_FDCWD, "./mysql/index_stats.MAD", O_RDWR|O_CLOEXEC) = 47[pid 355] getpid() = 337[pid 355] mprotect(0x7fa1e802c000, 8192, PROT_READ|PROT_WRITE) = 0[pid 355] access("./mysql/index_stats.TRG", F_OK) = -1 ENOENT (No such file or directory)[pid 355] mprotect(0x7fa1e802e000, 4096, PROT_READ|PROT_WRITE) = 0[pid 355] pwrite64(3, "\2\20\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0V8\261\33\207+\21\356\234F2\17\3\221"..., 4096, 4096) = 4096[pid 355] fdatasync(3) = 0[pid 355] pwrite64(3, "\1\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096, 8192) = 4096[pid 355] fdatasync(3) = 0[pid 355] pwrite64(3, "\2\21\0\0\1\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096, 12288) = 4096[pid 355] fdatasync(3) = 0[pid 355] pwrite64(3, "\1\0\0\0\3\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096, 8192) = 4096[pid 355] fdatasync(3) = 0[pid 355] openat(AT_FDCWD, "./mdev32814/#sql-alter-151-3.frm", O_RDWR|O_CREAT|O_TRUNC|O_CLOEXEC, 0660) = 48[pid 355] write(48, "\376\1\n\f\25\0Y\0\1\0\303\3\0\0\371\1\t\0\0\0\0\0\0\0\0\0\0\2F\0\10\0"..., 963) = 963[pid 355] fdatasync(48) = 0[pid 355] openat(AT_FDCWD, "./mdev32814/", O_RDONLY|O_CLOEXEC) = 49[pid 355] fdatasync(49) = 0[pid 355] close(49) = 0[pid 355] close(48) = 0[pid 355] mprotect(0x7fa1e802f000, 4096, PROT_READ|PROT_WRITE) = 0[pid 355] pwrite64(3, "\5", 1, 4098) = 1[pid 355] fdatasync(3) = 0[pid 355] mprotect(0x7fa1e8030000, 4096, PROT_READ|PROT_WRITE) = 0[pid 355] mprotect(0x7fa1e8031000, 4096, PROT_READ|PROT_WRITE) = 0[pid 355] mprotect(0x7fa1e8032000, 4096, PROT_READ|PROT_WRITE) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814", {st_mode=S_IFDIR|0700, st_size=4096, ...}, 0) = 0[pid 355] pwrite64(14, "nnements_abonnements_abonnementI"..., 1024, 73728) = 1024[pid 355] fdatasync(14) = 0[pid 355] openat(AT_FDCWD, "./mdev32814/#sql-alter-151-3.ibd", O_RDWR|O_CREAT|O_EXCL|O_CLOEXEC, 0660) = 48[pid 355] fcntl(48, F_SETFL, O_RDONLY|O_DIRECT) = 0[pid 355] newfstatat(48, "", {st_mode=S_IFREG|0660, st_size=0, ...}, AT_EMPTY_PATH) = 0[pid 355] fallocate(48, 0, 0, 65536) = 0[pid 355] newfstatat(48, "", {st_mode=S_IFREG|0660, st_size=65536, ...}, AT_EMPTY_PATH) = 0[pid 355] newfstatat(48, "", {st_mode=S_IFREG|0660, st_size=65536, ...}, AT_EMPTY_PATH) = 0[pid 355] fallocate(48, 0, 65536, 16384) = 0[pid 355] fdatasync(48) = 0[pid 355] fdatasync(48) = 0[pid 355] mprotect(0x7fa1e8033000, 12288, PROT_READ|PROT_WRITE) = 0[pid 355] pwrite64(14, "\4A\0\0\0\0\0\0\0\26\200\0\0\2\0\0\0!\0\0\0\0\0\0\0\0\0\0\0P\0\0"..., 1536, 74240) = 1536[pid 355] fdatasync(14) = 0[pid 355] mprotect(0x7fa1e8036000, 12288, PROT_READ|PROT_WRITE) = 0[pid 355] pwrite64(14, "@4\f\0u\0045\f\2\2019\3\303\10\4\377\323\2\6\v\303\4\4\377\323\2\6\v\303\4\4\377"..., 2048, 75264) = 2048[pid 355] fdatasync(14) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814/#sql-alter-151-3.frm", {st_mode=S_IFREG|0660, st_size=963, ...}, 0) = 0[pid 355] sendto(45, "\27\0\0\1\377\377\377\1\2\2\0\0\0\rEnabling keys", 27, MSG_DONTWAIT, NULL, 0) = 27[pid 355] pwrite64(14, "ages\1ID\275a D\5\3\6\216 0\0P!\f,\31\t\1leaf_pa"..., 512, 76800) = 512[pid 355] fdatasync(14) = 0[pid 355] pwrite64(3, "\6", 1, 4098) = 1[pid 355] fdatasync(3) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.ibd", {st_mode=S_IFREG|0660, st_size=114688, ...}, 0) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814/#sql-backup-151-3.ibd", 0x7fa2540bf580, 0) = -1 ENOENT (No such file or directory)[pid 355] pwrite64(14, "ages\1ID\275a D\5\3\6\216 0\0P!\f,\31\t\1leaf_pa"..., 1024, 76800) = 1024[pid 355] fdatasync(14) = 0[pid 355] rename("./mdev32814/user_abonnements.ibd", "./mdev32814/#sql-backup-151-3.ibd") = 0[pid 355] pwrite64(14, "nnements\1\25102\300 I\1/\3\16\1\1\0\0\0\0\0\0\340\200\0\0\0"..., 2048, 77312) = 2048[pid 355] fdatasync(14) = 0[pid 355] rename("./mdev32814/user_abonnements.frm", "./mdev32814/#sql-backup-151-3.frm") = 0[pid 355] pwrite64(3, "\7", 1, 4098) = 1[pid 355] fdatasync(3) = 0[pid 355] mprotect(0x7fa1e8039000, 8192, PROT_READ|PROT_WRITE) = 0[pid 355] mprotect(0x7fa1e803b000, 8192, PROT_READ|PROT_WRITE) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814/#sql-alter-151-3.ibd", {st_mode=S_IFREG|0660, st_size=81920, ...}, 0) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.ibd", 0x7fa2540bf580, 0) = -1 ENOENT (No such file or directory)[pid 355] pwrite64(14, "\0\08\340\203\0\0\0-\4\t\tmdev32814\20user_abonn"..., 1024, 78848) = 1024[pid 355] fdatasync(14) = 0[pid 355] rename("./mdev32814/#sql-alter-151-3.ibd", "./mdev32814/user_abonnements.ibd") = 0[pid 355] newfstatat(15, "", {st_mode=S_IFREG|0600, st_size=0, ...}, AT_EMPTY_PATH) = 0[pid 355] lseek(15, 0, SEEK_SET) = 0[pid 355] write(2, "2023-11-19 22:31:09 3 [ERROR] In"..., 1882023-11-19 22:31:09 3 [ERROR] InnoDB: In ALTER TABLE `mdev32814`.`user_abonnements` has or is referenced in foreign key constraints which are not compatible with the new table definition.) = 188[pid 355] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.ibd", {st_mode=S_IFREG|0660, st_size=81920, ...}, 0) = 0[pid 355] pwrite64(14, "\240\20\3\t\0\26mdev32814/#sql-alter-151-3"..., 1024, 79360) = 1024[pid 355] fdatasync(14) = 0[pid 355] rename("./mdev32814/user_abonnements.ibd", "./mdev32814/#sql-alter-151-3.ibd") = 0[pid 355] pwrite64(3, "\1", 1, 4098) = 1[pid 355] fdatasync(3) = 0[pid 355] pwrite64(14, "ibd\0./mdev32814/#sql-alter-151-3"..., 2560, 79872) = 2560[pid 355] fdatasync(14) = 0[pid 355] pwrite64(14, ".\3/\3\16\v\3\0\0\0\0\0:\340\204\0\0\0.\4\215\10\0\0\0\0\0\0\0\26\10\0"..., 512, 81920) = 512[pid 355] fdatasync(14) = 0[pid 355] unlink("./mdev32814/#sql-alter-151-3.cfg") = -1 ENOENT (No such file or directory)[pid 355] unlink("./mdev32814/#sql-alter-151-3.ibd") = 0[pid 355] close(48) = 0[pid 355] unlink("./mdev32814/#sql-alter-151-3.frm") = 0[pid 355] mprotect(0x7fa1e803d000, 8192, PROT_READ|PROT_WRITE) = 0[pid 355] mprotect(0x7fa1e803f000, 8192, PROT_READ|PROT_WRITE) = 0[pid 355] mprotect(0x7fa1e8041000, 8192, PROT_READ|PROT_WRITE) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814/#sql-backup-151-3.ibd", {st_mode=S_IFREG|0660, st_size=114688, ...}, 0) = 0[pid 355] newfstatat(AT_FDCWD, "./mdev32814/user_abonnements.ibd", 0x7fa2540bf580, 0) = -1 ENOENT (No such file or directory)[pid 355] pwrite64(14, ".\3/\3\16\v\3\0\0\0\0\0:\340\204\0\0\0.\4\215\10\0\0\0\0\0\0\0\26\10\0"..., 1024, 81920) = 1024[pid 355] fdatasync(14) = 0[pid 355] rename("./mdev32814/#sql-backup-151-3.ibd", "./mdev32814/user_abonnements.ibd") = 0[pid 355] pwrite64(14, "dev32814/#sql-backup-151-3\1\2748P\3 "..., 512, 82432) = 512[pid 355] fdatasync(14) = 0[pid 355] rename("./mdev32814/#sql-backup-151-3.frm", "./mdev32814/user_abonnements.frm") = 0[pid 355] pwrite64(3, "\3", 1, 8192) = 1[pid 355] fdatasync(3) = 0[pid 355] sendto(45, "\230\0\0\2\377\1\4#HY000Error on rename of "..., 156, MSG_DONTWAIT, NULL, 0) = 156[pid 355] recvfrom(45, "\1\0\0\0", 4, MSG_DONTWAIT, NULL, NULL) = 4[pid 355] recvfrom(45, "\1", 1, MSG_DONTWAIT, NULL, NULL) = 1[pid 355] close(45) = 0Evidently I'm a user of podman over docker but at you've seen, same command options.
Can you produce the same section of strace output under Windows? With this I might be able to either provide some durability for the unexpected inside MariaDB, and maybe do another minimal producer of a potentially new WSL bug.