2018-02-14 19:12:21 140510129694464 [Note] InnoDB: BF-BF X lock conflict,mode: 1027 supremum: 0 2018-02-14 19:12:21 140510129694464 [Note] InnoDB: conflicts states: my 0 locked 0 RECORD LOCKS space id 5 page no 428 n bits 96 index PRIMARY of table `foo`.`CA9176ed2945` trx id 225747 lock_mode X locks rec but not gap Record lock, heap no 24 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 363939616664343833363731326335653737; asc 699afd4836712c5e77;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c003f3; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 536368393137376330313761663466356563323062363833; asc Sch9177c017af4f5ec20b683;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 25 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 373139326166653435363765316266363464; asc 7192afe4567e1bf64d;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c00470; asc r p;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 527562636436373334636164356262643866383261386330; asc Rubcd6734cad5bbd8f82a8c0;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; 2018-02-14 19:12:21 140510129694464 [Note] InnoDB: SQL1: DELETE FROM `CA9176ed2945`¦m¦Z 2018-02-14 19:12:21 140510129694464 [Note] InnoDB: SQL2: DELETE FROM `VA13db63946f`¦m¦Z 2018-02-14 19:12:21 140510129694464 [ERROR] mysqld: Can't find record in 'CA9176ed2945' 2018-02-14 19:12:21 140510129694464 [ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table foo.CA9176ed2945; Can't find record in 'CA9176ed2945', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 1460595, Internal MariaDB error code: 1032 2018-02-14 19:12:21 140510129694464 [Warning] WSREP: RBR event 183 Delete_rows_v1 apply warning: 120, 108533 2018-02-14 19:12:21 140510129694464 [Warning] WSREP: Failed to apply app buffer: seqno: 108533, status: 1 at galera/src/trx_handle.cpp:apply():351 Retrying 2th time 2018-02-14 19:12:21 140510129694464 [Note] InnoDB: BF-BF X lock conflict,mode: 1027 supremum: 0 2018-02-14 19:12:21 140510129694464 [Note] InnoDB: conflicts states: my 0 locked 0 RECORD LOCKS space id 5 page no 428 n bits 96 index PRIMARY of table `foo`.`CA9176ed2945` trx id 225747 lock_mode X locks rec but not gap Record lock, heap no 2 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563623263393665323539636635; asc MAUcb2c96e259cf5;; 3: len 18; hex 303331323866643066626433333435313564; asc 03128fd0fbd334515d;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c0075e; asc r ^;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464750663630393933613061; asc FGPf60993a0a;; 9: len 24; hex 4f7261353035613734303863363530643730303832336434; asc Ora505a7408c650d700823d4;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 24 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 363939616664343833363731326335653737; asc 699afd4836712c5e77;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c003f3; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 536368393137376330313761663466356563323062363833; asc Sch9177c017af4f5ec20b683;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 25 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 373139326166653435363765316266363464; asc 7192afe4567e1bf64d;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c00470; asc r p;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 527562636436373334636164356262643866383261386330; asc Rubcd6734cad5bbd8f82a8c0;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 26 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 373734346530393238646530373535333863; asc 7744e0928de075538c;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c004ed; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 507572366138393964376333303563333434353431376263; asc Pur6a899d7c305c3445417bc;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 27 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 443930643833306638313762393530643439; asc D90d830f817b950d49;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c0056a; asc r j;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 416d61656632653331356131633839653034626533643633; asc Amaef2e315a1c89e04be3d63;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 28 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 4a3437396531346430303239633630616262; asc J479e14d0029c60abb;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c005e7; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 477261303561643435633833323564333264656462636662; asc Gra05ad45c8325d32dedbcfb;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 29 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 4b4e48653762633439373764303939303530; asc KNHe7bc4977d099050;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c00664; asc r d;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 43656e343237353938303163373333626237636365306531; asc Cen42759801c733bb7cce0e1;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 30 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 524e51636435313034303764616465353036; asc RNQcd510407dade506;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c006e1; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 417175373336613633303131663936633232336232323434; asc Aqu736a63011f96c223b2244;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; 2018-02-14 19:12:22 140510129694464 [Note] InnoDB: SQL1: DELETE FROM `CA9176ed2945`¦m¦Z 2018-02-14 19:12:22 140510129694464 [Note] InnoDB: SQL2: DELETE FROM `VA13db63946f`¦m¦Z 2018-02-14 19:12:22 140510129694464 [ERROR] mysqld: Can't find record in 'CA9176ed2945' 2018-02-14 19:12:22 140510129694464 [ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table foo.CA9176ed2945; Can't find record in 'CA9176ed2945', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 1460595, Internal MariaDB error code: 1032 2018-02-14 19:12:22 140510129694464 [Warning] WSREP: RBR event 183 Delete_rows_v1 apply warning: 120, 108533 2018-02-14 19:12:22 140510129694464 [Warning] WSREP: Failed to apply app buffer: seqno: 108533, status: 1 at galera/src/trx_handle.cpp:apply():351 Retrying 3th time 2018-02-14 19:12:22 140510129694464 [Note] InnoDB: BF-BF X lock conflict,mode: 1027 supremum: 0 2018-02-14 19:12:22 140510129694464 [Note] InnoDB: conflicts states: my 0 locked 0 RECORD LOCKS space id 5 page no 428 n bits 96 index PRIMARY of table `foo`.`CA9176ed2945` trx id 225747 lock_mode X locks rec but not gap Record lock, heap no 2 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563623263393665323539636635; asc MAUcb2c96e259cf5;; 3: len 18; hex 303331323866643066626433333435313564; asc 03128fd0fbd334515d;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c0075e; asc r ^;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464750663630393933613061; asc FGPf60993a0a;; 9: len 24; hex 4f7261353035613734303863363530643730303832336434; asc Ora505a7408c650d700823d4;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 24 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 363939616664343833363731326335653737; asc 699afd4836712c5e77;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c003f3; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 536368393137376330313761663466356563323062363833; asc Sch9177c017af4f5ec20b683;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 25 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 373139326166653435363765316266363464; asc 7192afe4567e1bf64d;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c00470; asc r p;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 527562636436373334636164356262643866383261386330; asc Rubcd6734cad5bbd8f82a8c0;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 26 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 373734346530393238646530373535333863; asc 7744e0928de075538c;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c004ed; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 507572366138393964376333303563333434353431376263; asc Pur6a899d7c305c3445417bc;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 27 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 443930643833306638313762393530643439; asc D90d830f817b950d49;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c0056a; asc r j;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 416d61656632653331356131633839653034626533643633; asc Amaef2e315a1c89e04be3d63;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 28 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 4a3437396531346430303239633630616262; asc J479e14d0029c60abb;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c005e7; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 477261303561643435633833323564333264656462636662; asc Gra05ad45c8325d32dedbcfb;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 29 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 4b4e48653762633439373764303939303530; asc KNHe7bc4977d099050;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c00664; asc r d;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 43656e343237353938303163373333626237636365306531; asc Cen42759801c733bb7cce0e1;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 30 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 524e51636435313034303764616465353036; asc RNQcd510407dade506;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c006e1; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 417175373336613633303131663936633232336232323434; asc Aqu736a63011f96c223b2244;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; 2018-02-14 19:12:22 140510129694464 [Note] InnoDB: SQL1: DELETE FROM `CA9176ed2945`¦m¦Z 2018-02-14 19:12:22 140510129694464 [Note] InnoDB: SQL2: DELETE FROM `VA13db63946f`¦m¦Z 2018-02-14 19:12:22 140510129694464 [ERROR] mysqld: Can't find record in 'CA9176ed2945' 2018-02-14 19:12:22 140510129694464 [ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table foo.CA9176ed2945; Can't find record in 'CA9176ed2945', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 1460595, Internal MariaDB error code: 1032 2018-02-14 19:12:23 140510129694464 [Warning] WSREP: RBR event 183 Delete_rows_v1 apply warning: 120, 108533 2018-02-14 19:12:23 140510129694464 [Warning] WSREP: Failed to apply app buffer: seqno: 108533, status: 1 at galera/src/trx_handle.cpp:apply():351 Retrying 4th time 2018-02-14 19:12:23 140510129694464 [Note] InnoDB: BF-BF X lock conflict,mode: 1027 supremum: 0 2018-02-14 19:12:23 140510129694464 [Note] InnoDB: conflicts states: my 0 locked 0 RECORD LOCKS space id 5 page no 428 n bits 96 index PRIMARY of table `foo`.`CA9176ed2945` trx id 225747 lock_mode X locks rec but not gap Record lock, heap no 2 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563623263393665323539636635; asc MAUcb2c96e259cf5;; 3: len 18; hex 303331323866643066626433333435313564; asc 03128fd0fbd334515d;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c0075e; asc r ^;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464750663630393933613061; asc FGPf60993a0a;; 9: len 24; hex 4f7261353035613734303863363530643730303832336434; asc Ora505a7408c650d700823d4;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 24 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 363939616664343833363731326335653737; asc 699afd4836712c5e77;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c003f3; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 536368393137376330313761663466356563323062363833; asc Sch9177c017af4f5ec20b683;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 25 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 373139326166653435363765316266363464; asc 7192afe4567e1bf64d;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c00470; asc r p;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 527562636436373334636164356262643866383261386330; asc Rubcd6734cad5bbd8f82a8c0;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 26 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 373734346530393238646530373535333863; asc 7744e0928de075538c;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c004ed; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 507572366138393964376333303563333434353431376263; asc Pur6a899d7c305c3445417bc;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 27 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 443930643833306638313762393530643439; asc D90d830f817b950d49;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c0056a; asc r j;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 416d61656632653331356131633839653034626533643633; asc Amaef2e315a1c89e04be3d63;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 28 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 4a3437396531346430303239633630616262; asc J479e14d0029c60abb;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c005e7; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 477261303561643435633833323564333264656462636662; asc Gra05ad45c8325d32dedbcfb;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 29 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 4b4e48653762633439373764303939303530; asc KNHe7bc4977d099050;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c00664; asc r d;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 43656e343237353938303163373333626237636365306531; asc Cen42759801c733bb7cce0e1;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000024400; asc D ;; 12: len 9; hex 80000000000002b214; asc ;; 13: len 9; hex 80000000000002153c; asc <;; 14: len 9; hex 800000000000027a62; asc zb;; 15: len 9; hex 80000000000002153c; asc <;; 16: len 9; hex 800000000000027a62; asc zb;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; Record lock, heap no 30 PHYSICAL RECORD: n_fields 19; compact format; info bits 32 0: len 4; hex 80000005; asc ;; 1: len 4; hex 80000010; asc ;; 2: len 16; hex 4d415563616333376637383137313232; asc MAUcac37f7817122;; 3: len 18; hex 524e51636435313034303764616465353036; asc RNQcd510407dade506;; 4: len 6; hex 0000000371d3; asc q ;; 5: len 7; hex 72000001c006e1; asc r ;; 6: len 4; hex 800007c4; asc ;; 7: len 10; hex 4d415563383838313732; asc MAUc888172;; 8: len 12; hex 464754346638636534386466; asc FGT4f8ce48df;; 9: len 24; hex 417175373336613633303131663936633232336232323434; asc Aqu736a63011f96c223b2244;; 10: len 4; hex 80000001; asc ;; 11: len 9; hex 800000000000000000; asc ;; 12: len 9; hex 800000000000000000; asc ;; 13: len 9; hex 800000000000000000; asc ;; 14: len 9; hex 800000000000000000; asc ;; 15: len 9; hex 800000000000000000; asc ;; 16: len 9; hex 800000000000000000; asc ;; 17: len 3; hex 800000; asc ;; 18: len 3; hex 800000; asc ;; 2018-02-14 19:12:23 140510129694464 [Note] InnoDB: SQL1: DELETE FROM `CA9176ed2945`¦m¦Z 2018-02-14 19:12:23 140510129694464 [Note] InnoDB: SQL2: DELETE FROM `VA13db63946f`¦m¦Z 2018-02-14 19:12:23 140510129694464 [ERROR] mysqld: Can't find record in 'CA9176ed2945' 2018-02-14 19:12:23 140510129694464 [ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table foo.CA9176ed2945; Can't find record in 'CA9176ed2945', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 1460595, Internal MariaDB error code: 1032 2018-02-14 19:12:24 140510129694464 [Warning] WSREP: RBR event 183 Delete_rows_v1 apply warning: 120, 108533 2018-02-14 19:12:24 140510129694464 [ERROR] WSREP: Failed to apply trx: source: 84080c9c-119b-11e8-9faa-b387b82ca4e9 version: 3 local: 0 state: APPLYING flags: 1 conn_id: 12 trx_id: 223173 seqnos (l: 109382, g: 108533, s: 108532, d: 108532, ts: 98284779322128) 2018-02-14 19:12:24 140510129694464 [ERROR] WSREP: Failed to apply trx 108533 4 times 2018-02-14 19:12:24 140510129694464 [ERROR] WSREP: Node consistency compromised, aborting... 2018-02-14 19:12:24 140510129694464 [Note] WSREP: Closing send monitor... 2018-02-14 19:12:24 140510129694464 [Note] WSREP: Closed send monitor. 2018-02-14 19:12:24 140510129694464 [Note] WSREP: gcomm: terminating thread 2018-02-14 19:12:24 140510129694464 [Note] WSREP: gcomm: joining thread 2018-02-14 19:12:24 140510129694464 [Note] WSREP: gcomm: closing backend 2018-02-14 19:12:28 140510129694464 [Note] WSREP: (ef4f7905, 'tcp://0.0.0.0:4567') connection to peer 84080c9c with addr tcp://192.168.104.191:4567 timed out, no messages seen in PT3S