| Bug #25695 | mysqld is locked and hangs during backup | ||
|---|---|---|---|
| Submitted: | 18 Jan 2007 14:51 | Modified: | 30 Jan 2007 7:45 |
| Reporter: | Oli Sennhauser | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.1.14 | OS: | Linux (Linux Suse 9.3) |
| Assigned to: | CPU Architecture: | Any | |
[18 Jan 2007 15:51]
Valeriy Kravchuk
Thank you for a problem report. Please, describe exact steps used to backup.
[18 Jan 2007 18:13]
Oli Sennhauser
mysqldump --user=root --all-databases --single-transaction --master-data=2 --flush-logs --quick
[29 Jan 2007 15:40]
Sveta Smirnova
Thank you for the report. I can not repeat it with last BK sources on machine with NPTL 2.3.6 Please, provide output of getconf GNU_LIBPTHREAD_VERSION on yours.
[29 Jan 2007 16:29]
Oli Sennhauser
getconf GNU_LIBPTHREAD_VERSION NPTL 2.3.4
[30 Jan 2007 7:45]
Sveta Smirnova
Thank you for the report. I can not repeat it using current BK sources.
[30 Jan 2007 10:41]
Oli Sennhauser
Hi Sveta I can easily repeate it on my machine... So how can we find together a solution? Regards Oli
[31 Jan 2007 11:02]
Sveta Smirnova
Hi Oli, your issue was tested on 4 different machines without success. Seems problem is your environment.
[31 Jan 2007 11:21]
Oli Sennhauser
Ok. Then let us forget about it...
Description: I wanted to do a backup for testing on my laptop. Backup did not work mysqld hangs. connecting with other client is not possible anymore... How to repeat: can be reproduced at will (probably) on my laptop. I can try to ship the db if wanted... mysql@laptop:~/product/mysql-5.1.14/data [mysql-5.1.14, 3313]> strace mysql -u root execve("/u00/app/mysql/product/mysql-5.1.14/bin/mysql", ["mysql", "-u", "root"], [/* 69 vars */]) = 0 uname({sys="Linux", node="laptop", ...}) = 0 ... read(3, "# SYSOPT\nsysopt \t\t3281/udp # S"..., 4096) = 4096 close(3) = 0 munmap(0x40018000, 4096) = 0 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0 socket(PF_FILE, SOCK_STREAM, 0) = 3 fcntl64(3, F_SETFL, O_RDONLY) = 0 fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR) connect(3, {sa_family=AF_FILE, path="/u00/app/mysql/tmp/mysql-3313.sock"}, 110) = 0 setsockopt(3, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported) setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 setsockopt(3, SOL_SOCKET, SO_RCVTIMEO, "\2003\341\1\0\0\0\0", 8) = 0 read(3, "=\0\0\0\n5.1.14-beta-log\0\r\0\0\0d3p]aPK"..., 16384) = 65 stat64("/usr/local/mysql/share/mysql/charsets/Index.xml", 0xbfffda00) = -1 ENOENT (No such file or directory) setsockopt(3, SOL_SOCKET, SO_SNDTIMEO, "\2003\341\1\0\0\0\0", 8) = 0 write(3, "&\0\0\1\205\246\3\0\0\0\0\1\10\0\0\0\0\0\0\0\0\0\0\0\0"..., 42) = 42 setsockopt(3, SOL_SOCKET, SO_RCVTIMEO, "\2003\341\1\0\0\0\0", 8) = 0 read(3, <unfinished ...> Suggested fix: no idea