Cascading foreign key causes crash with innodb plugin in 0.8 series
Bug #841669 reported by
Seppo Jaakola
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.