When I disable innodb_unsafe_for_binlogs , and ran the test I see the following? ------------- 140430 23:30:47 [Note] WSREP: cluster conflict due to high priority abort for threads: 140430 23:30:47 [Note] WSREP: Winning thread: THD: 43095, mode: total order, state: executing, conflict: no conflict, seqno: 140251 SQL: truncate table tbl_base 140430 23:30:47 [Note] WSREP: Victim thread: THD: 50048, mode: local, state: committing, conflict: must abort, seqno: -1 SQL: INSERT INTO tbl_base (reg_name , reg_key , reg_secret , description , reg_status , user_id , owner_id) VALUES ("1618_akdrgdb003_name" ,"0031618" ,"1618_akdrgdb003_pw" ,"1618-akdrgdb003" ,"active" ,"1618_akdrgdb003_id" ,"A_accessorLoadtestCk_1") 140430 23:30:47 [Note] WSREP: BF kill (1, seqno: 140251), victim: (50048) trx: 9185454 140430 23:30:47 [Note] WSREP: Aborting query: INSERT INTO tbl_base (reg_name , reg_key , reg_secret , description , reg_status , user_id , owner_id) VALUES ("1618_akdrgdb003_name" ,"0031618" ,"1618_akdrgdb003_pw" ,"1618-akdrgdb003" ,"active" ,"1618_akdrgdb003_id" ,"A_accessorLoadtestCk_1") 140430 23:30:47 [Note] WSREP: victim 9185454 in MUST ABORT state 140430 23:30:47 [Note] WSREP: MDL victim killed at add_ticket 140430 23:30:47 [Note] WSREP: trx conflict for key 0 74657374 74626c5f62617365 : source: 4a6c8c29-cff5-11e3-bf2a-33f8b3f78fde versi on: 2 local: 1 state: MUST_ABORT flags: 1 conn_id: 50048 trx_id: 9185454 seqnos (l: 16735, g: 140252, s: 140250, d: 139798, ts: 139 8900647665050495) <--X--> source: 4a6c8c29-cff5-11e3-bf2a-33f8b3f78fde version: 2 local: 1 state: APPLYING flags: 65 conn_id: 43095 trx_id: -1 seqnos (l: 16734, g: 140251, s: 140249, d: 140250, ts: 1398900647649096183) 140430 23:30:47 [Note] WSREP: commit failed for reason: 3 --------------------------
When I disable innodb_ unsafe_ for_binlogs , and ran the test I see the following? akdrgdb003_ name"
,"0031618"
,"1618_ akdrgdb003_ pw"
,"1618- akdrgdb003"
,"active"
,"1618_ akdrgdb003_ id"
,"A_accessorL oadtestCk_ 1") akdrgdb003_ name"
,"0031618"
,"1618_ akdrgdb003_ pw"
,"1618- akdrgdb003"
,"active"
,"1618_ akdrgdb003_ id"
,"A_accessorL oadtestCk_ 1") cff5-11e3- bf2a-33f8b3f78f de versi cff5-11e3- bf2a-33f8b3f78f de version: 2 local: 1 state: APPLYING flags: 65 conn_id: 43095 6183) ------- ------- -----
-------------
140430 23:30:47 [Note] WSREP: cluster conflict due to high priority abort for threads:
140430 23:30:47 [Note] WSREP: Winning thread:
THD: 43095, mode: total order, state: executing, conflict: no conflict, seqno: 140251
SQL: truncate table tbl_base
140430 23:30:47 [Note] WSREP: Victim thread:
THD: 50048, mode: local, state: committing, conflict: must abort, seqno: -1
SQL: INSERT INTO
tbl_base (reg_name
, reg_key
, reg_secret
, description
, reg_status
, user_id
, owner_id)
VALUES ("1618_
140430 23:30:47 [Note] WSREP: BF kill (1, seqno: 140251), victim: (50048) trx: 9185454
140430 23:30:47 [Note] WSREP: Aborting query: INSERT INTO
tbl_base (reg_name
, reg_key
, reg_secret
, description
, reg_status
, user_id
, owner_id)
VALUES ("1618_
140430 23:30:47 [Note] WSREP: victim 9185454 in MUST ABORT state
140430 23:30:47 [Note] WSREP: MDL victim killed at add_ticket
140430 23:30:47 [Note] WSREP: trx conflict for key 0 74657374 74626c5f62617365 : source: 4a6c8c29-
on: 2 local: 1 state: MUST_ABORT flags: 1 conn_id: 50048 trx_id: 9185454 seqnos (l: 16735, g: 140252, s: 140250, d: 139798, ts: 139
8900647665050495) <--X--> source: 4a6c8c29-
trx_id: -1 seqnos (l: 16734, g: 140251, s: 140249, d: 140250, ts: 139890064764909
140430 23:30:47 [Note] WSREP: commit failed for reason: 3
-------