Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17012

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

    XMLWordPrintable

Details

    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

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            jeetupatil Jeetendra Patil
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.