Comment 22 for bug 1240098
Revision history for this message
| Raghavendra D Prabhu (raghavendra-prabhu) wrote Re: CTAS fails with explicit TEMPORARY tables | binlogging enabled | #22 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
35a32c5
(Get the code!)
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