Comments - V5.5.36 will only use default data directory
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Thanks Sergii for quick response. I was aware of Errno's 13 meaning but it doesn't explain why ib_logfile0 and ib_logfile1 could be created without any problems. Originally these 2 also had the same problem but once I deleted the old versions it solved the problem for them but not for aria_log_control. I recently had to re-install Mint16, MariaDb and everything. On my old system I could switch to any set of data files simply by changing the datadir in my.cnf. It's not a big deal but I prefer to keep my data on a separate partition for backup purposes.
I don't know then. Try to strace
mysqldand see why it gets errno 13Hi Sergii, I am attaching strace.log below to see if it makes any sense to you. It's all greek to me. I created with "sudo strace -f > strace.log 2>&1 service /etc/init.d/mysql start". For comparison I ran this command on my good folder /var/lib/mysql and on my bad folder /home/mysql (on different partition). The files in each folder were identical and permissions identical. Neither would start MariaDB so the 2 logs were identical. I could start /var/lib/mysql with the usual command "sudo /etc/init.d/mysql start".
execve("/usr/sbin/service", ["service", "/etc/init.d/mysql", "start"], [/* 58 vars */]) = 0 brk(0) = 0x19f8000 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fab0f32e000 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=104549, ...}) = 0 mmap(NULL, 104549, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fab0f314000 close(3) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/x86_64-linux-gnu/libc.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\360\36\2\0\0\0\0\0"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0755, st_size=1853400, ...}) = 0 mmap(NULL, 3961912, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fab0ed46000 mprotect(0x7fab0ef03000, 2097152, PROT_NONE) = 0 mmap(0x7fab0f103000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1bd000) = 0x7fab0f103000 mmap(0x7fab0f109000, 17464, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fab0f109000 close(3) = 0 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fab0f313000 mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fab0f311000 arch_prctl(ARCH_SET_FS, 0x7fab0f311740) = 0 mprotect(0x7fab0f103000, 16384, PROT_READ) = 0 mprotect(0x618000, 4096, PROT_READ) = 0 mprotect(0x7fab0f330000, 4096, PROT_READ) = 0 munmap(0x7fab0f314000, 104549) = 0 getpid() = 16040 rt_sigaction(SIGCHLD, {0x40ecd0, ~[RTMIN RT_1], SA_RESTORER, 0x7fab0ed7cff0}, NULL, 8) = 0 geteuid() = 1000 brk(0) = 0x19f8000 brk(0x1a19000) = 0x1a19000 getppid() = 16035 stat("/home/michael", {st_mode=S_IFDIR|0770, st_size=4096, ...}) = 0 stat(".", {st_mode=S_IFDIR|0770, st_size=4096, ...}) = 0 open("/usr/sbin/service", O_RDONLY) = 3 fcntl(3, F_DUPFD, 10) = 10 close(3) = 0 fcntl(10, F_SETFD, FD_CLOEXEC) = 0 rt_sigaction(SIGINT, NULL, {SIG_DFL, [], 0}, 8) = 0 rt_sigaction(SIGINT, {0x40ecd0, ~[RTMIN RT_1], SA_RESTORER, 0x7fab0ed7cff0}, NULL, 8) = 0 rt_sigaction(SIGQUIT, NULL, {SIG_DFL, [], 0}, 8) = 0 rt_sigaction(SIGQUIT, {SIG_DFL, ~[RTMIN RT_1], SA_RESTORER, 0x7fab0ed7cff0}, NULL, 8) = 0 rt_sigaction(SIGTERM, NULL, {SIG_DFL, [], 0}, 8) = 0 rt_sigaction(SIGTERM, {SIG_DFL, ~[RTMIN RT_1], SA_RESTORER, 0x7fab0ed7cff0}, NULL, 8) = 0 read(10, "#!/bin/sh\n\n#####################"..., 8192) = 4873 pipe([3, 4]) = 0 clone(Process 16041 attached child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x7fab0f311a10) = 16041 [pid 16041] close(10 <unfinished ...> [pid 16040] close(4 <unfinished ...> [pid 16041] <... close resumed> ) = 0 [pid 16040] <... close resumed> ) = 0 [pid 16041] close(3 <unfinished ...> [pid 16040] read(3, <unfinished ...> [pid 16041] <... close resumed> ) = 0 [pid 16041] dup2(4, 1) = 1 [pid 16041] close(4) = 0 [pid 16041] stat("/usr/local/sbin/basename", 0x7fffda5151a0) = -1 ENOENT (No such file or directory) [pid 16041] stat("/usr/local/bin/basename", 0x7fffda5151a0) = -1 ENOENT (No such file or directory) [pid 16041] stat("/usr/sbin/basename", 0x7fffda5151a0) = -1 ENOENT (No such file or directory) [pid 16041] stat("/usr/bin/basename", {st_mode=S_IFREG|0755, st_size=27216, ...}) = 0 [pid 16041] execve("/usr/bin/basename", ["basename", "/usr/sbin/service"], [/* 58 vars */]) = 0 [pid 16041] brk(0) = 0x97d000 [pid 16041] access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) [pid 16041] mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f4f97be0000 [pid 16041] access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory) [pid 16041] open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3 [pid 16041] fstat(3, {st_mode=S_IFREG|0644, st_size=104549, ...}) = 0 [pid 16041] mmap(NULL, 104549, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f4f97bc6000 [pid 16041] close(3) = 0 [pid 16041] access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) [pid 16041] open("/lib/x86_64-linux-gnu/libc.so.6", O_RDONLY|O_CLOEXEC) = 3 [pid 16041] read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360\36\2\0\0\0\0\0"..., 832) = 832 [pid 16041] fstat(3, {st_mode=S_IFREG|0755, st_size=1853400, ...}) = 0 [pid 16041] mmap(NULL, 3961912, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f4f975f8000 [pid 16041] mprotect(0x7f4f977b5000, 2097152, PROT_NONE) = 0 [pid 16041] mmap(0x7f4f979b5000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1bd000) = 0x7f4f979b5000 [pid 16041] mmap(0x7f4f979bb000, 17464, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f4f979bb000 [pid 16041] close(3) = 0 [pid 16041] mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f4f97bc5000 [pid 16041] mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f4f97bc3000 [pid 16041] arch_prctl(ARCH_SET_FS, 0x7f4f97bc3740) = 0 [pid 16041] mprotect(0x7f4f979b5000, 16384, PROT_READ) = 0 [pid 16041] mprotect(0x605000, 4096, PROT_READ) = 0 [pid 16041] mprotect(0x7f4f97be2000, 4096, PROT_READ) = 0 [pid 16041] munmap(0x7f4f97bc6000, 104549) = 0 [pid 16041] brk(0) = 0x97d000 [pid 16041] brk(0x99e000) = 0x99e000 [pid 16041] open("/usr/lib/locale/locale-archive", O_RDONLY|O_CLOEXEC) = 3 [pid 16041] fstat(3, {st_mode=S_IFREG|0644, st_size=2919792, ...}) = 0 [pid 16041] mmap(NULL, 2919792, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f4f9732f000 [pid 16041] close(3) = 0 [pid 16041] fstat(1, {st_mode=S_IFIFO|0600, st_size=0, ...}) = 0 [pid 16041] mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f4f97bdf000 [pid 16041] write(1, "service\n", 8) = 8 [pid 16040] <... read resumed> "service\n", 128) = 8 [pid 16041] close(1 <unfinished ...> [pid 16040] read(3, <unfinished ...> [pid 16041] <... close resumed> ) = 0 [pid 16040] <... read resumed> "", 128) = 0 [pid 16041] munmap(0x7f4f97bdf000, 4096 <unfinished ...> [pid 16040] close(3 <unfinished ...> [pid 16041] <... munmap resumed> ) = 0 [pid 16040] <... close resumed> ) = 0 [pid 16041] close(2 <unfinished ...> [pid 16040] wait4(-1, <unfinished ...> [pid 16041] <... close resumed> ) = 0 [pid 16041] exit_group(0) = ? [pid 16041] +++ exited with 0 +++ <... wait4 resumed> [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 16041 --- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=16041, si_status=0, si_utime=0, si_stime=0} --- rt_sigreturn() = 16041 pipe([3, 4]) = 0 clone(Process 16042 attached child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x7fab0f311a10) = 16042 [pid 16040] close(4 <unfinished ...> [pid 16042] close(10 <unfinished ...> [pid 16040] <... close resumed> ) = 0 [pid 16042] <... close resumed> ) = 0 [pid 16040] read(3, <unfinished ...> [pid 16042] close(3) = 0 [pid 16042] dup2(4, 1) = 1 [pid 16042] close(4) = 0 [pid 16042] stat("/usr/local/sbin/basename", 0x7fffda5151a0) = -1 ENOENT (No such file or directory) [pid 16042] stat("/usr/local/bin/basename", 0x7fffda5151a0) = -1 ENOENT (No such file or directory) [pid 16042] stat("/usr/sbin/basename", 0x7fffda5151a0) = -1 ENOENT (No such file or directory) [pid 16042] stat("/usr/bin/basename", {st_mode=S_IFREG|0755, st_size=27216, ...}) = 0 [pid 16042] execve("/usr/bin/basename", ["basename", "/usr/sbin/service"], [/* 58 vars */]) = 0 [pid 16042] brk(0) = 0xfc3000 [pid 16042] access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) [pid 16042] mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f39c38ce000 [pid 16042] access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory) [pid 16042] open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3 [pid 16042] fstat(3, {st_mode=S_IFREG|0644, st_size=104549, ...}) = 0 [pid 16042] mmap(NULL, 104549, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f39c38b4000 [pid 16042] close(3) = 0 [pid 16042] access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) [pid 16042] open("/lib/x86_64-linux-gnu/libc.so.6", O_RDONLY|O_CLOEXEC) = 3 [pid 16042] read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360\36\2\0\0\0\0\0"..., 832) = 832 [pid 16042] fstat(3, {st_mode=S_IFREG|0755, st_size=1853400, ...}) = 0 [pid 16042] mmap(NULL, 3961912, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f39c32e6000 [pid 16042] mprotect(0x7f39c34a3000, 2097152, PROT_NONE) = 0 [pid 16042] mmap(0x7f39c36a3000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1bd000) = 0x7f39c36a3000 [pid 16042] mmap(0x7f39c36a9000, 17464, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f39c36a9000 [pid 16042] close(3) = 0 [pid 16042] mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f39c38b3000 [pid 16042] mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f39c38b1000 [pid 16042] arch_prctl(ARCH_SET_FS, 0x7f39c38b1740) = 0 [pid 16042] mprotect(0x7f39c36a3000, 16384, PROT_READ) = 0 [pid 16042] mprotect(0x605000, 4096, PROT_READ) = 0 [pid 16042] mprotect(0x7f39c38d0000, 4096, PROT_READ) = 0 [pid 16042] munmap(0x7f39c38b4000, 104549) = 0 [pid 16042] brk(0) = 0xfc3000 [pid 16042] brk(0xfe4000) = 0xfe4000 [pid 16042] open("/usr/lib/locale/locale-archive", O_RDONLY|O_CLOEXEC) = 3 [pid 16042] fstat(3, {st_mode=S_IFREG|0644, st_size=2919792, ...}) = 0 [pid 16042] mmap(NULL, 2919792, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f39c301d000 [pid 16042] close(3) = 0 [pid 16042] fstat(1, {st_mode=S_IFIFO|0600, st_size=0, ...}) = 0 [pid 16042] mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f39c38cd000 [pid 16042] write(1, "service\n", 8) = 8 [pid 16040] <... read resumed> "service\n", 128) = 8 [pid 16042] close(1 <unfinished ...> [pid 16040] read(3, <unfinished ...> [pid 16042] <... close resumed> ) = 0 [pid 16040] <... read resumed> "", 128) = 0 [pid 16042] munmap(0x7f39c38cd000, 4096 <unfinished ...> [pid 16040] close(3 <unfinished ...> [pid 16042] <... munmap resumed> ) = 0 [pid 16040] <... close resumed> ) = 0 [pid 16042] close(2 <unfinished ...> [pid 16040] wait4(-1, <unfinished ...> [pid 16042] <... close resumed> ) = 0 [pid 16042] exit_group(0) = ? [pid 16042] +++ exited with 0 +++ <... wait4 resumed> [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 16042 --- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=16042, si_status=0, si_utime=0, si_stime=0} --- rt_sigreturn() = 16042 chdir("/") = 0 faccessat(AT_FDCWD, "/etc/init//etc/init.d/mysql.conf", R_OK) = -1 ENOENT (No such file or directory) geteuid() = 1000 faccessat(AT_FDCWD, "/etc/init.d//etc/init.d/mysql", X_OK) = -1 ENOENT (No such file or directory) fcntl(1, F_DUPFD, 10) = 11 close(1) = 0 fcntl(11, F_SETFD, FD_CLOEXEC) = 0 dup2(2, 1) = 1 write(1, "/etc/init.d/mysql: unrecognized "..., 40/etc/init.d/mysql: unrecognized service ) = 40 dup2(11, 1) = 1 close(11) = 0 exit_group(1) = ? +++ exited with 1 +++Sorry, this strace log is useless to me, it doesn't trace mysqld process at all, it only traces service or bash or whatever will eventually start mysqld, but mysqld itself is not in the log.