This is what it looks like with wsrep-debug:
a)
========================================================================== 131111 20:12:19 [Note] WSREP: skipping tmp table DML: THD: 3 tmp: 2 SQL: CREATE TEMPORARY TABLE test_bug AS SELECT * FROM test_bug_source 131111 20:12:22 [Warning] WSREP: SQL statement was ineffective, THD: 3, buf: 141 QUERY: commit => Skipping replication 131111 20:12:22 [Note] WSREP: commit failed for reason: 3 131111 20:12:22 [Note] WSREP: conflict state: 0 131111 20:12:22 [Note] WSREP: cluster conflict due to certification failure for threads: 131111 20:12:22 [Note] WSREP: Victim thread: THD: 3, mode: local, state: executing, conflict: cert failure, seqno: -1 SQL: commit 131111 20:12:22 [Note] WSREP: COMMIT failed, MDL released: 3 131111 20:12:22 [Note] WSREP: cert failure, thd: 3 is_AC: 0, retry: 0 - 1 SQL: commit
=========================================================================
As per "skipping tmp table DML: " , the CREATE TEMPORARY TABLE succeeds but the
This is what it looks like with wsrep-debug:
a)
======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ====
131111 20:12:19 [Note] WSREP: skipping tmp table DML: THD: 3 tmp: 2 SQL: CREATE TEMPORARY TABLE test_bug AS
SELECT
*
FROM
test_bug_source
131111 20:12:22 [Warning] WSREP: SQL statement was ineffective, THD: 3, buf: 141
QUERY: commit
=> Skipping replication
131111 20:12:22 [Note] WSREP: commit failed for reason: 3
131111 20:12:22 [Note] WSREP: conflict state: 0
131111 20:12:22 [Note] WSREP: cluster conflict due to certification failure for threads:
131111 20:12:22 [Note] WSREP: Victim thread:
THD: 3, mode: local, state: executing, conflict: cert failure, seqno: -1
SQL: commit
131111 20:12:22 [Note] WSREP: COMMIT failed, MDL released: 3
131111 20:12:22 [Note] WSREP: cert failure, thd: 3 is_AC: 0, retry: 0 - 1 SQL: commit
======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ===
As per "skipping tmp table DML: " , the CREATE TEMPORARY TABLE succeeds but the