MySQL patches by Codership

  1. Bug #1240098
  2. Comment #3

Comment 3 for bug 1240098

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Re: Deadlock when dropping and creating temporary table on Percona XtraDB Cluster 5.5.33

Thanks for reporting this.

I am able to reproduce this.

Mainly with wsrep_debug I see the following:

==============
131022 10:37:40 [Note] WSREP: skipping tmp table DML: THD: 3 tmp: 2 SQL: CREATE TEMPORARY TABLE test_bug AS
  SELECT
    *
  FROM
    test_bug_source
131022 10:37:42 [Warning] WSREP: SQL statement was ineffective, THD: 3, buf: 139
QUERY: COMMIT
 => Skipping replication
131022 10:37:42 [Note] WSREP: commit failed for reason: 3
131022 10:37:42 [Note] WSREP: conflict state: 0
131022 10:37:42 [Note] WSREP: cluster conflict due to certification failure for threads:
131022 10:37:42 [Note] WSREP: Victim thread:
   THD: 3, mode: local, state: executing, conflict: cert failure, seqno: 49
   SQL: COMMIT
131022 10:37:42 [Note] WSREP: COMMIT failed, MDL released: 3
131022 10:37:42 [Note] WSREP: cert failure, thd: 3 is_AC: 0, retry: 0 - 1 SQL: COMMIT

=============================