Percona XtraDB Cluster - HA scalable solution for MySQL

UNIV_SYNC_DEBUG build asserts with cascading FK load

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
Status tracked in Trunk
5.6
Undecided
Unassigned
Trunk
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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers