UNIV_SYNC_DEBUG build asserts with cascading FK load

Bug #1248921 reported by Seppo Jaakola on 2013-11-07
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
Medium
Seppo Jaakola
5.6
Medium
Seppo Jaakola
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Fix Released
Undecided
Unassigned
5.6
Fix Released
Undecided
Unassigned

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.

Seppo Jaakola (seppo-jaakola) wrote :

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

Seppo Jaakola (seppo-jaakola) wrote :

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

Seppo Jaakola (seppo-jaakola) wrote :

Fix pushed in wsrep-5.6 in revision: http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/4016

Here foreign index is checked in upper level to avoid violating the latching protocol

summary: - UNIV_SYNC_DEBUG build asserts with casacading FK load
+ UNIV_SYNC_DEBUG build asserts with cascading FK load

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1512

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers