Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.1.33
Description
As somebody deleted database table and our mariadb galera cluster crashed see below error.
etrying 2th time
2018-08-16 16:28:44 140459134327552 [ERROR] mysqld: Can't find record in 'users_last_login'
2018-08-16 16:28:44 140459134327552 [ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table DB_TOTAL4DEV_P.users_last_login; Can't find record in 'users_last_login', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 1058, Internal MariaDB error code: 1032
2018-08-16 16:28:44 140459134327552 [Warning] WSREP: RBR event 2 Delete_rows_v1 apply warning: 120, 309051933
2018-08-16 16:28:44 140459134327552 [Warning] WSREP: Failed to apply app buffer: seqno: 309051933, status: 1
at galera/src/trx_handle.cpp:apply():351
Retrying 3th time
2018-08-16 16:28:44 140459134327552 [ERROR] mysqld: Can't find record in 'users_last_login'
2018-08-16 16:28:44 140459134327552 [ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table DB_TOTAL4DEV_P.users_last_login; Can't find record in 'users_last_login', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 1058, Internal MariaDB error code: 1032
2018-08-16 16:28:44 140459134327552 [Warning] WSREP: RBR event 2 Delete_rows_v1 apply warning: 120, 309051933
2018-08-16 16:28:44 140459134327552 [Warning] WSREP: Failed to apply app buffer: seqno: 309051933, status: 1
at galera/src/trx_handle.cpp:apply():351
Retrying 4th time
2018-08-16 16:28:44 140459134327552 [ERROR] mysqld: Can't find record in 'users_last_login'
2018-08-16 16:28:44 140459134327552 [ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table DB_TOTAL4DEV_P.users_last_login; Can't find record in 'users_last_login', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 1058, Internal MariaDB error code: 1032
2018-08-16 16:28:44 140459134327552 [Warning] WSREP: RBR event 2 Delete_rows_v1 apply warning: 120, 309051933
2018-08-16 16:28:44 140459134327552 [ERROR] WSREP: Failed to apply trx: source: 808e3422-9dcd-11e8-bbc0-3ab028afd1b7 version: 3 local: 0 state: APPLYING flags: 1 conn_id: 893106 trx_id: 15068161908 seqnos (l: 1334948, g: 309051933, s: 309051932, d: 309051868, ts: 393116532516870)
2018-08-16 16:28:44 140459134327552 [ERROR] WSREP: Failed to apply trx 309051933 4 times
2018-08-16 16:28:44 140459134327552 [ERROR] WSREP: Node consistency compromised, aborting...
2018-08-16 16:28:44 140459134327552 [Note] WSREP: Closing send monitor...
2018-08-16 16:28:44 140459134327552 [Note] WSREP: Closed send monitor.
2018-08-16 16:28:44 140459134327552 [Note] WSREP: gcomm: terminating thread