Cascading foreign key causes crash with innodb plugin in 0.8 series

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

Bug Description

In 0.8.2 build, when starting the server with innodb plugin a crash happens in foreign key cascading phase.
Here's the steps to reproduce the crash with demo package:

   1. MYSQL_PORT=3307 mysql-galera -g gcomm:// --plugin
   2. mysql -uroot -prootpass -h0 -P3307 test
   3. mysql> create table t1 (i int primary key);
   4. mysql> create table t2 ( i int primary key, j int, foreign key (j) references test.t1 (i) on delete cascade);
   5. insert into t1 values (1);
   6. insert into t2 values (10,1);
   7. delete from t1;

Changed in codership-mysql:
importance: Undecided → Critical
assignee: nobody → Seppo Jaakola (seppo-jaakola)
status: New → In Progress
Changed in codership-mysql:
status: In Progress → Fix Committed
Changed in codership-mysql:
status: Fix Committed → Fix Released
status: Fix Released → 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.