DDL in multi-statement will cause a crash

Bug #1049024 reported by Seppo Jaakola
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Fix Released
Low
Seppo Jaakola

Bug Description

If DDL is part of a multi-statement, the server may crash.

To reproduce, run multi statement, .e.g like:
mysql --delimiter ':' -e"create table if not exists test.t1(i int); select 1; :"

=> the node will replicate both statements in TO isolation.

This is potential cause for the problem observed in MariaDB project: https://mariadb.atlassian.net/browse/MDEV-523

Changed in codership-mysql:
status: New → In Progress
importance: Undecided → Low
assignee: nobody → Seppo Jaakola (seppo-jaakola)
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

This turned out to be fundamental issue in multi-statement processing. problem surfaces when multi-statement escalates in retrying mode.
Fix has been pushed in: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3791. However, testing has been quite minimal, we will need reliable regression test for this.

Changed in codership-mysql:
status: In Progress → Fix Committed
milestone: none → 5.5.27-23.7
Changed in codership-mysql:
status: Fix Committed → In Progress
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

a regression happened (https://mariadb.atlassian.net/browse/MDEV-541)
Aborted idle session did not clear aborted flag, fixed in change set: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3795

Changed in codership-mysql:
status: In Progress → Fix Committed
Changed in codership-mysql:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.