Bug #49960 | Deadlock on a concurrent workload involving transactional lock table | ||
---|---|---|---|
Submitted: | 28 Dec 2009 14:41 | Modified: | 27 May 2010 9:41 |
Reporter: | Philip Stoev | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S2 (Serious) |
Version: | next-mr-wl3561 | OS: | Any |
Assigned to: | Ingo Strüwing | CPU Architecture: | Any |
[28 Dec 2009 14:41]
Philip Stoev
[28 Dec 2009 14:42]
Philip Stoev
Thread stacks for 49960
Attachment: bug49960.stacks.txt (text/plain), 29.12 KiB.
[28 Dec 2009 14:54]
Philip Stoev
Code and binary: http://mysql-systemqa.s3.amazonaws.com/var-bug49960.zip Source: revision-id: ingo.struewing@sun.com-20091221154123-51irmivi5ey9mt57 date: 2009-12-21 16:41:23 +0100 build-date: 2009-12-28 16:54:47 +0200 revno: 2943 branch-nick: mysql-next-mr-wl3561
[28 Dec 2009 16:00]
Philip Stoev
zz file for 49960
Attachment: bug49960.zz (application/octet-stream, text), 691 bytes.
[28 Dec 2009 16:00]
Philip Stoev
yy file for 49960
Attachment: bug49960.yy (application/octet-stream, text), 69.67 KiB.
[28 Dec 2009 16:02]
Philip Stoev
To reproduce with the RQG: $ perl runall.pl \ --grammar=conf/WL5004_sql.yy \ --gendata=conf/WL5004_data.zz \ --basedir=/build/bzr/mysql-next-mr-wl3561/ \ --queries=100K \ --mysqld=--secure-file-priv=/tmp \ --mysqld=--innodb-lock-wait-timeout=1 \ --mysqld=--log-output=file \ --mysqld=--skip-safemalloc This test will usually terminate due to other crashes and assertions, however once every few runs, the deadlock will happen. You will observe that all the output from the RQG will stop and that SHOW PROCESSLIST will show that all queries have hanged beyond all reasonable timeout.
[28 Dec 2009 16:03]
Philip Stoev
In the RQG command line, please use the YY and ZZ files as attached to the bug report.
[27 May 2010 9:41]
Ingo Strüwing
This had been reported against a former attempt to backport WL#3561. It does no longer belong to any existing software any more. In similar tests against the new backport this hasn't been seen again.