Open
Description
Tail of the error log:
151028 11:55:08 [Note] WSREP: Victim thread:
THD: 9400, mode: local, state: executing, conflict: cert failure, seqno: 92018
SQL: INSERT INTO lp1019473 VALUES (5,5,'C-10011')
151028 11:55:08 [Note] WSREP: wsrep retrying AC query: INSERT INTO lp1019473 VALUES (5,5,'C-10011')
151028 11:55:08 [Note] WSREP: commit failed for reason: 3
151028 11:55:08 [Note] WSREP: conflict state: 0
151028 11:55:08 [Note] WSREP: cluster conflict due to certification failure for threads:
151028 11:55:08 [Note] WSREP: Victim thread:
THD: 9400, mode: local, state: executing, conflict: cert failure, seqno: 92020
SQL: INSERT INTO lp1019473 VALUES (5,5,'C-10011')
151028 11:55:08 [Note] WSREP: cert failure, thd: 9400 is_AC: 1, retry: 1 - 1 SQL: INSERT INTO lp1019473 VALUES (5,5,'C-10011')
151028 11:55:08 [Note] WSREP: releasing retry_query: conf 0 sent 0 kill 0 errno 1213 SQL INSERT INTO lp1019473 VALUES (5,5,'C-10011')
151028 11:55:08 [Note] WSREP: commit failed for reason: 3
151028 11:55:08 [Note] WSREP: conflict state: 0
151028 11:55:08 [Note] WSREP: cluster conflict due to certification failure for threads:
151028 11:55:08 [Note] WSREP: Victim thread:
THD: 9404, mode: local, state: executing, conflict: cert failure, seqno: 92031
SQL: DELETE FROM lp1019473 WHERE fid=1 AND uid=1
151028 11:55:08 [Note] WSREP: cluster conflict due to high priority abort for threads:
151028 11:55:08 [Note] WSREP: Winning thread:
THD: 4, mode: applier, state: executing, conflict: no conflict, seqno: 92030
SQL: (null)
151028 11:55:08 [Note] WSREP: Victim thread:
THD: 9404, mode: local, state: executing, conflict: cert failure, seqno: -1
SQL: DELETE FROM lp1019473 WHERE fid=1 AND uid=1
151028 11:55:08 [Note] WSREP: BF kill (1, seqno: 92030), victim: (9404) trx: 140155
151028 11:55:08 [Note] WSREP: Aborting query: DELETE FROM lp1019473 WHERE fid=1 AND uid=1
151028 11:55:08 [Note] WSREP: victim 140155 in state 7
151028 11:55:08 [Note] WSREP: wsrep retrying AC query: DELETE FROM lp1019473 WHERE fid=1 AND uid=1
WSREP: BF victim waiting
WSREP: c_lock != wait lock
RECORD LOCKS space id 0 page no 360 n bits 320 index `GEN_CLUST_INDEX` of table `test`.`lp1019473` trx id 2237E lock_mode X locks rec but not gap
Record lock, heap no 246 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 6; hex 000000009708; asc ;;
1: len 6; hex 00000002237e; asc #~;;
2: len 7; hex 10000003392bce; asc 9+ ;;
3: len 4; hex 00000001; asc ;;
4: len 4; hex 00000001; asc ;;
5: len 7; hex 432d3130303231; asc C-10021;;
RECORD LOCKS space id 0 page no 342 n bits 1056 index `uid` of table `test`.`lp1019473` trx id 2237E lock_mode X locks rec but not gap waiting
Record lock, heap no 718 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 4; hex 00000001; asc ;;
1: len 6; hex 000000009708; asc ;;
WSREP: c_lock canceled 140158
151028 11:55:08 [Note] WSREP: releasing retry_query: conf 0 sent 0 kill 0 errno 1213 SQL DELETE FROM lp1019473 WHERE fid=1 AND uid=1
Backtrace:
gdb.txt
To reproduce, run regression test for lp:1019473 from galera repository.