Bug #47098 | assert in MDL_context::destroy on HANDLER <damaged merge table> OPEN | ||
---|---|---|---|
Submitted: | 3 Sep 2009 11:27 | Modified: | 7 Mar 2010 1:56 |
Reporter: | Matthias Leich | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S3 (Non-critical) |
Version: | 5.4 | OS: | Any |
Assigned to: | Lars-Erik Bjørk | CPU Architecture: | Any |
Tags: | handler, mdl, merge |
[3 Sep 2009 11:27]
Matthias Leich
[22 Sep 2009 7:35]
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/84045 2830 lars-erik.bjork@sun.com 2009-09-22 This is a patch for bug#47098 assert in MDL_context::destroy on HANDLER <damaged merge table> OPEN The assert occurs in MDL_context::destroy when the conenction is terminated, because all mdl_tickets have not been released. MERGE tables does not support being opened using the HANDLER ... OPEN command, and trying to do so will result in an error. In the event of an error, all tables that are openend, should be closed again. The fix for bug#45781 made sure that this also works for MERGE tabeles, which causes multiple talbes to be opened. This fix extends the fix for bug#45781, by ensuring that also all locks are released, when MERGE tables are involved. modified: mysql-test/r/merge.result mysql-test/t/merge.test sql/sql_handler.cc
[22 Sep 2009 11:23]
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/84103 2831 lars-erik.bjork@sun.com 2009-09-22 This is a patch for bug#47098 assert in MDL_context::destroy on HANDLER <damaged merge table> OPEN. The assert occurs in MDL_context::destroy when the connection is terminated, because all mdl_tickets have not been released. MERGE tables do not support being opened using the HANDLER ... OPEN command, and trying to do so will result in an error. In the event of an error, all tables that are opened, should be closed again. The fix for bug#45781 made sure that this also works for MERGE tables, which causes multiple tables to be opened. This fix extends the fix for bug#45781, by ensuring that also all locks are released, when MERGE tables are involved. modified: mysql-test/r/merge.result mysql-test/t/merge.test sql/sql_handler.cc
[22 Sep 2009 11:28]
Lars-Erik Bjørk
Pushed into mysql-6.0-codebase-bugfixing, 6.0.14-alpha
[30 Sep 2009 8:17]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20090929093622-1mooerbh12e97zux) (version source revid:alik@sun.com-20090923103200-kyo2bakdo6tfb2fb) (merge vers: 6.0.14-alpha) (pib:11)
[1 Oct 2009 17:11]
Paul DuBois
Noted in 6.0.14 changelog. When HANDLER OPEN was attempted on a MERGE table, an error occurred because this is an unsupported operation, but locks could remain unreleased. Setting report to NDI pending push into 5.4.x.
[9 Dec 2009 13:36]
Lars-Erik Bjørk
Pushed to mysql-next-4284 (5.6.0-beta)
[16 Feb 2010 16:46]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100216101445-2ofzkh48aq2e0e8o) (version source revid:kostja@sun.com-20091211154405-c9yhiewr9o5d20rq) (merge vers: 6.0.14-alpha) (pib:16)
[16 Feb 2010 16:55]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100216101208-33qkfwdr0tep3pf2) (version source revid:kostja@sun.com-20091210084103-l4f8u62u4evoy3dc) (pib:16)
[17 Feb 2010 1:10]
Paul DuBois
Setting report to Need Merge pending push of Celosia into release tree.
[6 Mar 2010 10:55]
Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@mysql.com-20100216221947-luyhph0txl2c5tc8) (merge vers: 5.5.99-m3) (pib:16)
[7 Mar 2010 1:56]
Paul DuBois
Noted in 5.5.3 changelog.
[13 Apr 2010 5:00]
Paul DuBois
Correction: Not present in any 5.5.x release. 5.5.3 changelog entry removed.