[debian-mysql] Bug#664639: Re: Bug#664639: mysqladmin flush-logs fails: more debugging output required?

Bjoern Boschman bjoern at boschman.de
Tue Jun 19 09:08:06 UTC 2012


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

reassign 664639 mysql-server-5.5
retitle 664639 mysqld_safe creates logfile as root which prevents
mysqld from appending
thanks


Hi,

I've attached strace output from mysqladmin.
As you can see the errormsg 'ERROR 1105 (HY000): Unknown error' is
generated by the mysqld process.

Also I've attached an strace output from the running mysql daemon.
There you can see that the error is generated because of this:

[pid 12372] open("/var/log/mysql/error.log",
O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission denied)

I've checked the file permissions and mysqld, which is running as user
mysql, cannot write to that logfile:

- -rw-rw---- 1 root adm 8075 Jun 19 10:25 /var/log/mysql/error.log

With logging enabled via mysql.cnf
[mysqld]
log-error = /var/log/mysql/error.log


But how comes that this file is owned by root?

Having a look into that logfile the first line gives the answer:

120313 12:27:41 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql

This means the logfile initially has been created by the mysqld_safe
process (umask 007) and therefor is not writeable for the mysqld process.

Currently I do not have an idea how to fix this, but I'll stay on track


Cheers
Bjoern
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk/gQXYACgkQABMWRpwdNungwACgvgafRpyB1Npa2jK6OL2vV+72
a5YAoL2sZzYZUSJwGHHGVunpxheahVUG
=wKnm
-----END PGP SIGNATURE-----
-------------- next part --------------
execve("/usr/bin/mysqladmin", ["/usr/bin/mysqladmin", "--defaults-file=/etc/mysql/debia"..., "flush-logs"], [/* 16 vars */]) = 0
brk(0)                                  = 0x7fe3d82dc000
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) = 0x7fe3d680a000
access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=17326, ...}) = 0
mmap(NULL, 17326, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fe3d6805000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/libpthread.so.0", O_RDONLY)  = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360Y\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=131258, ...}) = 0
mmap(NULL, 2208640, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d63d3000
mprotect(0x7fe3d63ea000, 2093056, PROT_NONE) = 0
mmap(0x7fe3d65e9000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x16000) = 0x7fe3d65e9000
mmap(0x7fe3d65eb000, 13184, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe3d65eb000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/usr/lib/libmysqlclient.so.16", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\232\5\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=2217984, ...}) = 0
mmap(NULL, 4318408, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d5fb4000
mprotect(0x7fe3d6181000, 2097152, PROT_NONE) = 0
mmap(0x7fe3d6381000, 331776, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1cd000) = 0x7fe3d6381000
mmap(0x7fe3d63d2000, 1224, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe3d63d2000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/libcrypt.so.1", O_RDONLY)    = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P\n\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=35104, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe3d6804000
mmap(NULL, 2318784, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d5d7d000
mprotect(0x7fe3d5d85000, 2093056, PROT_NONE) = 0
mmap(0x7fe3d5f84000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7000) = 0x7fe3d5f84000
mmap(0x7fe3d5f86000, 184768, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe3d5f86000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/libnsl.so.1", O_RDONLY)      = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\300@\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=89064, ...}) = 0
mmap(NULL, 2194128, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d5b65000
mprotect(0x7fe3d5b7a000, 2093056, PROT_NONE) = 0
mmap(0x7fe3d5d79000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14000) = 0x7fe3d5d79000
mmap(0x7fe3d5d7b000, 6864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe3d5d7b000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/usr/lib/libz.so.1", O_RDONLY)    = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260\"\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=93936, ...}) = 0
mmap(NULL, 2188976, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d594e000
mprotect(0x7fe3d5965000, 2093056, PROT_NONE) = 0
mmap(0x7fe3d5b64000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x16000) = 0x7fe3d5b64000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/usr/lib/libstdc++.so.6", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P\243\5\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=1043976, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe3d6803000
mmap(NULL, 3223576, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d563a000
mprotect(0x7fe3d5730000, 2097152, PROT_NONE) = 0
mmap(0x7fe3d5930000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xf6000) = 0x7fe3d5930000
mmap(0x7fe3d5939000, 81944, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe3d5939000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/libm.so.6", O_RDONLY)        = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360>\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=530736, ...}) = 0
mmap(NULL, 2625768, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d53b8000
mprotect(0x7fe3d5438000, 2097152, PROT_NONE) = 0
mmap(0x7fe3d5638000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x80000) = 0x7fe3d5638000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/libgcc_s.so.1", O_RDONLY)    = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P-\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=90504, ...}) = 0
mmap(NULL, 2186232, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d51a2000
mprotect(0x7fe3d51b8000, 2093056, PROT_NONE) = 0
mmap(0x7fe3d53b7000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fe3d53b7000
close(3)                                = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/libc.so.6", O_RDONLY)        = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\355\1\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1437064, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe3d6802000
mmap(NULL, 3545160, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe3d4e40000
mprotect(0x7fe3d4f99000, 2093056, PROT_NONE) = 0
mmap(0x7fe3d5198000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x158000) = 0x7fe3d5198000
mmap(0x7fe3d519d000, 18504, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe3d519d000
close(3)                                = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe3d6801000
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe3d67ff000
arch_prctl(ARCH_SET_FS, 0x7fe3d67ff720) = 0
mprotect(0x7fe3d5198000, 16384, PROT_READ) = 0
mprotect(0x7fe3d5638000, 4096, PROT_READ) = 0
mprotect(0x7fe3d5930000, 28672, PROT_READ) = 0
mprotect(0x7fe3d5d79000, 4096, PROT_READ) = 0
mprotect(0x7fe3d5f84000, 4096, PROT_READ) = 0
mprotect(0x7fe3d6381000, 28672, PROT_READ) = 0
mprotect(0x7fe3d65e9000, 4096, PROT_READ) = 0
mprotect(0x7fe3d6a16000, 4096, PROT_READ) = 0
mprotect(0x7fe3d680c000, 4096, PROT_READ) = 0
munmap(0x7fe3d6805000, 17326)           = 0
set_tid_address(0x7fe3d67ff9f0)         = 6452
set_robust_list(0x7fe3d67ffa00, 0x18)   = 0
futex(0x7fffed55909c, FUTEX_WAKE_PRIVATE, 1) = 0
futex(0x7fffed55909c, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, NULL, 7fe3d67ff720) = -1 EAGAIN (Resource temporarily unavailable)
rt_sigaction(SIGRTMIN, {0x7fe3d63d8870, [], SA_RESTORER|SA_SIGINFO, 0x7fe3d63e1ff0}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x7fe3d63d8900, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x7fe3d63e1ff0}, NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0
brk(0)                                  = 0x7fe3d82dc000
brk(0x7fe3d82fd000)                     = 0x7fe3d82fd000
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = 0
sendto(3, "\2\0\0\0\22\0\0\0\t\0\0\0services\0", 21, MSG_NOSIGNAL, NULL, 0) = 21
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 5000) = 1 ([{fd=3, revents=POLLIN|POLLHUP}])
recvmsg(3, {msg_name(0)=NULL, msg_iov(2)=[{"services\0", 9}, {"\270O\3\0\0\0\0\0", 8}], msg_controllen=24, {cmsg_len=20, cmsg_level=SOL_SOCKET, cmsg_type=SCM_RIGHTS, {4}}, msg_flags=MSG_CMSG_CLOEXEC}, MSG_CMSG_CLOEXEC) = 17
mmap(NULL, 217016, PROT_READ, MAP_SHARED, 4, 0) = 0x7fe3d67ca000
close(4)                                = 0
close(3)                                = 0
rt_sigaction(SIGPIPE, {SIG_IGN, [PIPE], SA_RESTORER|SA_RESTART, 0x7fe3d4e72230}, {SIG_DFL, [], 0}, 8) = 0
stat("/etc/mysql/debian.cnf", {st_mode=S_IFREG|0600, st_size=333, ...}) = 0
open("/etc/mysql/debian.cnf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0600, st_size=333, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe3d6809000
read(3, "# Automatically generated for De"..., 4096) = 333
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x7fe3d6809000, 4096)            = 0
rt_sigaction(SIGINT, {0x7fe3d68122b0, [INT], SA_RESTORER|SA_RESTART, 0x7fe3d4e72230}, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGTERM, {0x7fe3d68122b0, [TERM], SA_RESTORER|SA_RESTART, 0x7fe3d4e72230}, {SIG_DFL, [], 0}, 8) = 0
socket(PF_FILE, SOCK_STREAM, 0)         = 3
fcntl(3, F_SETFL, O_RDONLY)             = 0
fcntl(3, F_GETFL)                       = 0x2 (flags O_RDWR)
fcntl(3, F_GETFL)                       = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
connect(3, {sa_family=AF_FILE, path="/var/run/mysqld/mysqld.sock"}, 110) = 0
fcntl(3, F_SETFL, O_RDWR)               = 0
setsockopt(3, SOL_SOCKET, SO_RCVTIMEO, "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(3, SOL_SOCKET, SO_SNDTIMEO, "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(3, SOL_IP, IP_TOS, [8], 4)   = -1 EOPNOTSUPP (Operation not supported)
setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
poll([{fd=3, events=POLLIN}], 1, 43200000) = 1 ([{fd=3, revents=POLLIN}])
read(3, "C\0\0\0\n5.1.61-0+squeeze1-log\0G\316\7\0u"..., 16384) = 71
stat("/usr/share/mysql/charsets/Index.xml", {st_mode=S_IFREG|0644, st_size=18261, ...}) = 0
open("/usr/share/mysql/charsets/Index.xml", O_RDONLY) = 4
read(4, "<?xml version='1.0' encoding=\"ut"..., 18261) = 18261
close(4)                                = 0
write(3, "F\0\0\1\205\242\0\200\0\0\0@\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 74) = 74
read(3, "\7\0\0\2\0\0\0\2\0\0\0", 16384) = 11
poll([{fd=3, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(3, "\2\0\0\0\7\2", 6)             = 6
read(3, "\26\0\0\1\377Q\4#HY000Unknown error", 16384) = 26
write(2, "\7", 1)                       = 1
write(2, "/usr/bin/mysqladmin", 19/usr/bin/mysqladmin)     = 19
write(2, ": ", 2: )                       = 2
write(2, "refresh failed; error: 'Unknown "..., 38refresh failed; error: 'Unknown error') = 38
write(2, "\n", 1
)                       = 1
write(3, "\1\0\0\0\1", 5)               = 5
shutdown(3, 2 /* send and receive */)   = 0
close(3)                                = 0
exit_group(1)                           = ?
-------------- next part --------------
Process 8996 attached with 13 threads - interrupt to quit
[pid  4621] read(16,  <unfinished ...>
[pid 12372] futex(0x7f2b986da2c4, FUTEX_WAIT_PRIVATE, 180432, NULL <unfinished ...>
[pid  9010] futex(0x7f2b986da2c4, FUTEX_WAIT_PRIVATE, 180432, NULL <unfinished ...>
[pid  9007] rt_sigtimedwait([HUP QUIT ALRM TERM TSTP], NULL, NULL, 8 <unfinished ...>
[pid  9006] futex(0x7f2b99672564, FUTEX_WAIT_PRIVATE, 393739, NULL <unfinished ...>
[pid  9005] select(0, NULL, NULL, NULL, {0, 972285} <unfinished ...>
[pid  9004] select(0, NULL, NULL, NULL, {0, 11724} <unfinished ...>
[pid  9003] select(0, NULL, NULL, NULL, {0, 25185} <unfinished ...>
[pid  9001] futex(0x7f2b99bafcf4, FUTEX_WAIT_PRIVATE, 959417, NULL <unfinished ...>
[pid  9000] futex(0x7f2b99bafc44, FUTEX_WAIT_PRIVATE, 368053, NULL <unfinished ...>
[pid  8999] futex(0x7f2b99bafb94, FUTEX_WAIT_PRIVATE, 560869, NULL <unfinished ...>
[pid  8998] futex(0x7f2b99bafae4, FUTEX_WAIT_PRIVATE, 551, NULL <unfinished ...>
[pid  8996] select(13, [11 12], NULL, NULL, NULL <unfinished ...>
[pid  9004] <... select resumed> )      = 0 (Timeout)
[pid  9004] select(0, NULL, NULL, NULL, {1, 0} <unfinished ...>
[pid  9003] <... select resumed> )      = 0 (Timeout)
[pid  9003] select(0, NULL, NULL, NULL, {1, 0} <unfinished ...>
[pid  9005] <... select resumed> )      = 0 (Timeout)
[pid  9005] select(0, NULL, NULL, NULL, {5, 0} <unfinished ...>
[pid  9004] <... select resumed> )      = 0 (Timeout)
[pid  9004] select(0, NULL, NULL, NULL, {1, 0} <unfinished ...>
[pid  9003] <... select resumed> )      = 0 (Timeout)
[pid  9003] select(0, NULL, NULL, NULL, {1, 0} <unfinished ...>
[pid  8996] <... select resumed> )      = 1 (in [12])
[pid  8996] fcntl(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0
[pid  8996] accept(12, {sa_family=AF_FILE, NULL}, [2]) = 15
[pid  8996] fcntl(12, F_SETFL, O_RDWR)  = 0
[pid  8996] getsockname(15, {sa_family=AF_FILE, path="/var/run/mysql\1"}, [30]) = 0
[pid  8996] fcntl(15, F_SETFL, O_RDONLY) = 0
[pid  8996] fcntl(15, F_GETFL)          = 0x2 (flags O_RDWR)
[pid  8996] fcntl(15, F_SETFL, O_RDWR|O_NONBLOCK) = 0
[pid  8996] setsockopt(15, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
[pid  8996] futex(0x7f2b986da2c4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x7f2b986da2c0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1} <unfinished ...>
[pid 12372] <... futex resumed> )       = 0
[pid  8996] <... futex resumed> )       = 1
[pid 12372] futex(0x7f2b986d9700, FUTEX_WAIT_PRIVATE, 2, NULL <unfinished ...>
[pid  8996] futex(0x7f2b986d9700, FUTEX_WAKE_PRIVATE, 1 <unfinished ...>
[pid 12372] <... futex resumed> )       = -1 EAGAIN (Resource temporarily unavailable)
[pid  8996] <... futex resumed> )       = 0
[pid 12372] futex(0x7f2b986d9700, FUTEX_WAKE_PRIVATE, 1 <unfinished ...>
[pid  8996] select(13, [11 12], NULL, NULL, NULL <unfinished ...>
[pid 12372] <... futex resumed> )       = 0
[pid 12372] setsockopt(15, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
[pid 12372] write(15, "C\0\0\0\n5.1.61-0+squeeze1-log\0m`\1\0;"..., 71) = 71
[pid 12372] read(15, "F\0\0\1", 4)      = 4
[pid 12372] read(15, "\205\242\0\200\0\0\0@\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 70) = 70
[pid 12372] write(15, "\7\0\0\2\0\0\0\2\0\0\0", 11) = 11
[pid 12372] read(15, "\2\0\0\0", 4)     = 4
[pid 12372] read(15, "\7\2", 2)         = 2
[pid 12372] open("./", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 19
[pid 12372] getdents(19, /* 15 entries */, 32768) = 560
[pid 12372] getdents(19, /* 0 entries */, 32768) = 0
[pid 12372] close(19)                   = 0
[pid 12372] write(18, "\3566\340O\4\200\0\0\0002\0\0\0\234\0\0\0@\0\4\0\0\0\0\0\0\0mysql"..., 50) = 50
[pid 12372] fdatasync(18)               = 0
[pid 12372] close(18)                   = 0
[pid 12372] close(9)                    = 0
[pid 12372] open("./mysqld-relay-bin.index", O_RDWR|O_CREAT, 0660) = 9
[pid 12372] fdatasync(9)                = 0
[pid 12372] lseek(9, 0, SEEK_END)       = 78
[pid 12372] lseek(9, 0, SEEK_CUR)       = 78
[pid 12372] open("./mysqld-relay-bin.~rec~", O_RDWR|O_CREAT, 0660) = 18
[pid 12372] lseek(18, 0, SEEK_CUR)      = 0
[pid 12372] lseek(18, 0, SEEK_END)      = 0
[pid 12372] close(18)                   = 0
[pid 12372] unlink("./mysqld-relay-bin.~rec~") = 0
[pid 12372] unlink("./mysqld-relay-bin.~rec~") = -1 ENOENT (No such file or directory)
[pid 12372] open("./mysqld-relay-bin.~rec~", O_RDWR|O_CREAT, 0660) = 18
[pid 12372] lseek(18, 0, SEEK_CUR)      = 0
[pid 12372] write(18, "./mysqld-relay-bin.000310\n", 26) = 26
[pid 12372] fdatasync(18)               = 0
[pid 12372] open("./mysqld-relay-bin.000310", O_RDWR|O_CREAT|O_APPEND, 0660) = 19
[pid 12372] lseek(19, 0, SEEK_CUR)      = 0
[pid 12372] lseek(19, 0, SEEK_CUR)      = 0
[pid 12372] lseek(19, 0, SEEK_END)      = 0
[pid 12372] lseek(19, 0, SEEK_END)      = 0
[pid 12372] write(19, "\376bin\3566\340O\17\200\0\0\0f\0\0\0j\0\0\0\0\0\4\0005.1.61-"..., 106) = 106
[pid 12372] fdatasync(19)               = 0
[pid 12372] write(9, "./mysqld-relay-bin.000310\n", 26) = 26
[pid 12372] fdatasync(9)                = 0
[pid 12372] close(18)                   = 0
[pid 12372] unlink("./mysqld-relay-bin.~rec~") = 0
[pid 12372] fdatasync(17)               = 0
[pid 12372] close(17)                   = 0
[pid 12372] open("/var/log/mysql/slow.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = 17
[pid 12372] lseek(17, 0, SEEK_CUR)      = 0
[pid 12372] lseek(17, 0, SEEK_CUR)      = 0
[pid 12372] write(17, "/usr/sbin/mysqld, Version: 5.1.6"..., 176) = 176
[pid 12372] open("/var/log/mysql/error.log", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission denied)
[pid 12372] write(15, "\26\0\0\1\377Q\4#HY000Unknown error", 26) = 26
[pid 12372] read(15, "\1\0\0\0", 4)     = 4
[pid 12372] read(15, "\1", 1)           = 1
[pid 12372] shutdown(15, 2 /* send and receive */) = 0
[pid 12372] close(15)                   = 0
[pid 12372] futex(0x7f2b986da2c4, FUTEX_WAIT_PRIVATE, 180434, NULL <unfinished ...>
[pid  9004] <... select resumed> )      = 0 (Timeout)
[pid  9004] select(0, NULL, NULL, NULL, {1, 0} <unfinished ...>
[pid  9003] <... select resumed> )      = 0 (Timeout)
[pid  9003] select(0, NULL, NULL, NULL, {1, 0} <unfinished ...>
Process 8996 detached
Process 8998 detached
Process 8999 detached
Process 9000 detached
Process 9001 detached
Process 9003 detached
Process 9004 detached
Process 9005 detached
Process 9006 detached
Process 9007 detached
Process 9010 detached
Process 12372 detached
Process 4621 detached


More information about the pkg-mysql-maint mailing list