UNIV_SYNC_DEBUG build asserts with cascading FK load

Bug #1248921 reported by Seppo Jaakola
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
Fix Released
Medium
Seppo Jaakola
5.6
Fix Released
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.

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

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

Revision history for this message
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

Revision history for this message
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
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Other bug subscribers