Percona XtraDB Cluster - HA scalable solution for MySQL

wsrep commit callback does not release mdl locks

Reported by Teemu Ollakka on 2013-10-28
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
High
Teemu Ollakka
5.6
High
Teemu Ollakka
Percona XtraDB Cluster
Status tracked in Trunk
5.6
Undecided
Unassigned
Trunk
Undecided
Unassigned

Bug Description

Running statements

  create table foo (a int);
  insert into foo values (1);
  truncate foo;

on one node make slaves to log MDL conflicts

131028 7:01:23 [Note] WSREP: MDL conflict
request: (5 seqno 214 wsrep (1, 1, 0) cmd 0 8 truncate foo)
granted: (3 seqno 213 wsrep (1, 0, 0) cmd 0 133 (null))
131028 7:01:23 [Note] WSREP: MDL ticket: type: shared write space: TABLE db: test name: foo
131028 7:01:23 [Note] WSREP: MDL BF-BF conflict
request: (5 seqno 214 wsrep (1, 1, 0) cmd 0 8 truncate foo)
granted: (3 seqno 213 wsrep (1, 0, 0) cmd 0 133 (null))
131028 7:01:23 [Note] WSREP: MDL ticket: type: shared write space: TABLE db: test name: foo

This indicates that MDL locks are not released properly on slaves at commit time.

5.5 and 5.6 only.

Related branches

This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers