[MDEV-32814] ALTER TABLE DROP PK crashes on WSL Created: 2023-11-15  Updated: 2023-11-30

Status: Open
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Docker
Affects Version/s: 11.1.2
Fix Version/s: 10.4, 10.6

Type: Bug Priority: Major
Reporter: Marc Troll Assignee: Daniel Black
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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/Linux

Attachments: File docker-compose.yml     Text File docker.log     File dump.sql    
Issue Links:
Relates
relates to MDEV-32840 Drop PK issues FK error (poorly), but... Open

 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.



 Comments   
Comment by Daniel Black [ 2023-11-16 ]

I tested on Linux for 11.1.2 and 11.1.3 and got the ALTER TABLE error (not the rename error) and without without the crash.

As is crashing in Windows WSL I strongly suspects its https://github.com/microsoft/WSL/issues/8443 that I've been waiting for them to fix. Its a ALTER TABLE in the same way as your test case.

Comment by Daniel Black [ 2023-11-16 ]

marko after erroring in the log " InnoDB: In ALTER TABLE `test`.`user_abonnements` has or is referenced in foreign key constraints which are not compatible with the new table definition." (better than the user message), why is a ALTER TABLE taking place? Cannot help the windows crash(without rewriting the rename spacespace code).

Comment by Marko Mäkelä [ 2023-11-16 ]

danblack, this looks like the ALGORITHM=COPY code path that basically does CREATE TABLE, INSERT…SELECT, RENAME TABLE and DROP TABLE behind the scenes. The native ha_innobase::commit_inplace_alter_table() (misleading name; it supports also some table rebuild) would work differently. The native ALTER TABLE refuses to do DROP PRIMARY KEY without ADD PRIMARY KEY, because we never implemented the logic to assign DB_ROW_ID values. Now, after MDEV-19506 is done, that might be more feasible.

The crash could occur because of incorrect error handling in the SQL layer. It could be that it wrongly assumes that the operation succeeded, and then goes on to rename the actually non-existing intermediate copy of the table.

Comment by Daniel Black [ 2023-11-17 ]

> The crash could occur because of incorrect error handling in the SQL layer.

Ack.

ALGORITHM=COPY is why the WSL is crashing (MDEV-24189) -> https://github.com/microsoft/WSL/issues/8443. Might need a work around if they don't fix that soon. I'll push a tiny test case to them and see how they go.

Comment by Daniel Black [ 2023-11-18 ]

maaaak as a minimal test for the reproduction of the Windows bug I produced the image. Can you try the following and see if you get an error on fstat

docker run quay.io/danielgblack/wsl8443 ./wsl8443

docker run quay.io/danielgblack/wsl8443 strace ./wsl8443

A linux environment I get:

$ podman run wsl8443:latest ./wsl8443
 
file /tmp/testfile opened - fd 3
 
stat fd 3 successful

$ podman run --rm --cap-add=CAP_SYS_PTRACE wsl8443:latest strace /wsl8443

 
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 +++

Code is podman run --rm wsl8443:latest cat /wsl8443.c

I'm expecting a "error on fstat errno 2" in your env.

I tried confirming on my Windows environment but I might have some misunderstanding how Docker Desktop and WSL integrate to produce this. If you can help me confirm this then I can get WSL team a minimal producer container.

Comment by Marc Troll [ 2023-11-19 ]

Hi Daniel,

I hope I understand you right: I just have to execute "docker run quay.io/danielgblack/wsl8443 ./wsl8443" and "docker run quay.io/danielgblack/wsl8443 strace ./wsl8443" respectively, right? If I do so, the following output is logged into my console:

> docker run quay.io/danielgblack/wsl8443 ./wsl8443
 
file /tmp/testfile opened - fd 3
 
stat fd 3 successful
 
 
 
> docker run quay.io/danielgblack/wsl8443 strace ./wsl8443
 
execve("./wsl8443", ["./wsl8443"], 0x7fff8665d590 /* 6 vars */) = 0
 
brk(NULL)                               = 0x199a000
 
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f31622b4000
 
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=24894, ...}, AT_EMPTY_PATH) = 0
 
mmap(NULL, 24894, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f31622ad000
 
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\220s\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
 
newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=1922136, ...}, 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, 1970000, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f31620cc000
 
mmap(0x7f31620f2000, 1396736, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x26000) = 0x7f31620f2000
 
mmap(0x7f3162247000, 339968, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x17b000) = 0x7f3162247000
 
mmap(0x7f316229a000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1ce000) = 0x7f316229a000
 
mmap(0x7f31622a0000, 53072, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f31622a0000
 
close(3)                                = 0
 
mmap(NULL, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f31620c9000
 
arch_prctl(ARCH_SET_FS, 0x7f31620c9740) = 0
 
set_tid_address(0x7f31620c9a10)         = 9
 
set_robust_list(0x7f31620c9a20, 24)     = 0
 
rseq(0x7f31620ca060, 0x20, 0, 0x53053053) = 0
 
mprotect(0x7f316229a000, 16384, PROT_READ) = 0
 
mprotect(0x403000, 4096, PROT_READ)     = 0
 
mprotect(0x7f31622e6000, 8192, PROT_READ) = 0
 
prlimit64(0, RLIMIT_STACK, NULL, {rlim_cur=8192*1024, rlim_max=RLIM64_INFINITY}) = 0
 
munmap(0x7f31622ad000, 24894)           = 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 +++

Can not find an "error on fstat errno 2", or did I misunderstand you?

Thanks for your efforts!

Comment by Daniel Black [ 2023-11-19 ]

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 ./wsl8443
 
 
 
docker 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/d
 
mv dump.sql /tmp/d
 
podman volume create mdev32814
 
podman 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.2
 
podman stop mdev32814
 
podman rm mdev32814
 
podman 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)                   = 0

Evidently 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.

Comment by Marc Troll [ 2023-11-20 ]

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.

Comment by Daniel Black [ 2023-11-22 ]

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.

Comment by Marc Troll [ 2023-11-30 ]

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.

Comment by Daniel Black [ 2023-11-30 ]

Thanks Marc.

Generated at Thu Feb 08 10:34:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.