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
=============================
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
======= ======= ======= ======= =