Bug #54105 | assert in MDL_context::release_locks_stored_before | ||
---|---|---|---|
Submitted: | 31 May 2010 14:54 | Modified: | 22 Sep 2010 20:37 |
Reporter: | Matthias Leich | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S3 (Non-critical) |
Version: | 5.5+ | OS: | Any |
Assigned to: | Jon Olav Hauglid | CPU Architecture: | Any |
Tags: | mdl |
[31 May 2010 14:54]
Matthias Leich
[2 Jun 2010 9:48]
Matthias Leich
Archive with grammars and protocol of RQG run
Attachment: 54105.tgz (application/x-compressed-tar, text), 74.89 KiB.
[10 Aug 2010 13:48]
Jon Olav Hauglid
Repeatable in mysql-5.5-runtime-stage using RQG.
[10 Aug 2010 19:45]
Konstantin Osipov
I may have an idea for a solution based on the backtrace alone, let's discuss on IRC.
[12 Aug 2010 15:47]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/115616 3101 Jon Olav Hauglid 2010-08-12 Bug #54105 assert in MDL_context::release_locks_stored_before The problem was that SHOW CREATE EVENT released all metadata locks held by the current transaction. This made any exisiting savepoints invalid, triggering the assert when ROLLBACK TO SAVEPOINT later was executed. This patch fixes the problem by making sure SHOW CREATE EVENT only releases metadata locks acquired by the statement itself. Test case added to event_trans.test.
[13 Aug 2010 8:03]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/115641 3104 Jon Olav Hauglid 2010-08-13 Bug #54105 assert in MDL_context::release_locks_stored_before The problem was that SHOW CREATE EVENT released all metadata locks held by the current transaction. This made any exisiting savepoints invalid, triggering the assert when ROLLBACK TO SAVEPOINT later was executed. This patch fixes the problem by making sure SHOW CREATE EVENT only releases metadata locks acquired by the statement itself. Test case added to event_trans.test.
[13 Aug 2010 8:04]
Jon Olav Hauglid
Pushed to mysql-5.5-runtime (5.5.6).
[25 Aug 2010 9:23]
Bugs System
Pushed into mysql-5.5 5.5.6-m3 (revid:alik@ibmvm-20100825092002-2yvkb3iwu43ycpnm) (version source revid:alik@ibmvm-20100825092002-2yvkb3iwu43ycpnm) (merge vers: 5.5.6-m3) (pib:20)
[30 Aug 2010 8:31]
Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (version source revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (merge vers: 5.6.1-m4) (pib:21)
[30 Aug 2010 8:35]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (version source revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (pib:21)
[22 Sep 2010 20:37]
Paul DuBois
Noted in 5.5.6, 5.6.1 changelogs. SHOW CREATE EVENT released all metadata locks held by the current transaction. This invalidated any existing savepoints and raised an assertion if ROLLBACK TO SAVEPOINT was executed.