Comment 12 for bug 1314854

Revision history for this message
Celest Pantophlet (celestp) wrote :

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