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:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1.14 OS:Linux (Linux Suse 9.3)
Assigned to: CPU Architecture:Any

[18 Jan 2007 14:51] Oli Sennhauser
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
[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...