MySQL patches by Codership

UNIV_SYNC_DEBUG build asserts with cascading FK load

Bug #1248921 reported by Seppo Jaakola on 2013-11-07

This bug affects 1 person

	Status	Importance	Assigned to	Milestone
MySQL patches by Codership	Status tracked in 5.6
5.5	Fix Released	Medium	Seppo Jaakola	MySQL patches by Codership 5.5.34-25.9
5.6	Fix Released	Medium	Seppo Jaakola	MySQL patches by Codership 5.6.14-25.1
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC	Status tracked in 5.6
5.5	Fix Released	Undecided	Unassigned	Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC 5.5.34-25.9
5.6	Fix Released	Undecided	Unassigned	Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC 5.6.14-25.1

Bug Description

Server built with UNIV_SYNC_DEBUG will assert if SQL load has delete statements on tables with foreign key constraints with ON DELETE CASCADE option.

Revision history for this message

Seppo Jaakola (seppo-jaakola) wrote on 2013-11-07:

Regression test for lp:1089490 triggers this issue, one node is enough for reproducing

Revision history for this message

Seppo Jaakola (seppo-jaakola) wrote on 2013-11-07:

The underlying issue is that latching order is violated in wsrep_row_upd_index_is_foreign() function.

'assert' comes from sync_thread_add_level(), where latching order is checked, offending latch level added in wsrep_row_upd_index_is_foreign() is: SYNC_DICT_OPERATION