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

Slave SQL: Could not execute Delete_rows event on table

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.5.40-galera
    • Fix Version/s: None
    • Labels:
    • Environment:

      Description

      Galera node crashed with data inconsistency from DELETE FROM:

      141116 11:19:37 [ERROR] Slave SQL: Could not execute Delete_rows event on table db.tbl; Can't find record in 'tbl', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 12342, Error_code: 1032
      141116 11:19:37 [Warning] WSREP: RBR event 2 Delete_rows apply warning: 120, 11183
      141116 11:19:37 [Warning] WSREP: Failed to apply app buffer: seqno: 11183, status: 1
      141116 11:19:37 [ERROR] Slave SQL: Could not execute Delete_rows event on table db.tbl; Can't find record in 'tbl', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 12342, Error_code: 1032
      141116 11:19:37 [Warning] WSREP: RBR event 2 Delete_rows apply warning: 120, 11183
      141116 11:19:37 [Warning] WSREP: Failed to apply app buffer: seqno: 11183, status: 1
      141116 11:19:37 [ERROR] Slave SQL: Could not execute Delete_rows event on table db.tbl; Can't find record in 'tbl', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 12342, Error_code: 1032
      141116 11:19:37 [Warning] WSREP: RBR event 2 Delete_rows apply warning: 120, 11183
      141116 11:19:37 [Warning] WSREP: Failed to apply app buffer: seqno: 11183, status: 1
      141116 11:19:37 [ERROR] Slave SQL: Could not execute Delete_rows event on table db.tbl; Can't find record in 'tbl', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 12342, Error_code: 1032
      141116 11:19:37 [Warning] WSREP: RBR event 2 Delete_rows apply warning: 120, 11183
      141116 11:19:37 [ERROR] WSREP: Failed to apply trx: source: adff90d6-6c2b-11e4-9b59-16bcb63464a5 version: 3 local: 0 state: APPLYING flags: 1 conn_id: 2256 trx_id: 400584 seqnos (l: 2116, g: 11183, s: 11181, d: 11182, ts: 4794085928072857)
      141116 11:19:37 [ERROR] WSREP: Failed to apply trx 11183 4 times
      141116 11:19:37 [ERROR] WSREP: Node consistency compromized, aborting...
      141116 11:19:37 [Note] WSREP: Closing send monitor...
      141116 11:19:37 [Note] WSREP: Closed send monitor.
      141116 11:19:37 [Note] WSREP: gcomm: terminating thread
      141116 11:19:37 [Note] WSREP: gcomm: joining thread
      141116 11:19:37 [Note] WSREP: gcomm: closing backend
      141116 11:19:37 [Note] WSREP: view(view_id(NON_PRIM,18f5b9e2-6c2c-11e4-8201-dbc615e79ec5,101) memb {
      141116 11:19:37 [Note] WSREP: view((empty))
      141116 11:19:37 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
      141116 11:19:37 [Note] WSREP: gcomm: closed
      141116 11:19:37 [Note] WSREP: Flow-control interval: [16, 16]
      141116 11:19:37 [Note] WSREP: Received NON-PRIMARY.
      141116 11:19:37 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 11183)
      141116 11:19:37 [Note] WSREP: Received self-leave message.
      141116 11:19:37 [Note] WSREP: Flow-control interval: [0, 0]
      141116 11:19:37 [Note] WSREP: Received SELF-LEAVE. Closing connection.
      141116 11:19:37 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 11183)
      141116 11:19:37 [Note] WSREP: RECV thread exiting 0: Success
      141116 11:19:37 [Note] WSREP: recv_thread() joined.
      141116 11:19:37 [Note] WSREP: Closing replication queue.
      141116 11:19:37 [Note] WSREP: Closing slave action queue.
      141116 11:19:37 [Note] WSREP: /usr/sbin/mysqld: Terminated.
      141116 11:19:37 mysqld_safe Number of processes running now: 0
      141116 11:19:37 mysqld_safe WSREP: not restarting wsrep node automatically
      141116 11:19:37 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended1032
      

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            nirbhay_c Nirbhay Choubey added a comment -

            Could you share the table structure (SHOW CREATE TABLE tbl) and server configurations (my.cnf)?

            Show
            nirbhay_c Nirbhay Choubey added a comment - Could you share the table structure (SHOW CREATE TABLE tbl) and server configurations (my.cnf)?
            Hide
            j j added a comment -

            Seems to have been fixed in 10.0.6 in this bug: https://mariadb.atlassian.net/browse/MDEV-5217

            Show
            j j added a comment - Seems to have been fixed in 10.0.6 in this bug: https://mariadb.atlassian.net/browse/MDEV-5217
            Show
            nirbhay_c Nirbhay Choubey added a comment - https://github.com/codership/mysql-wsrep/issues/40

              People

              • Assignee:
                nirbhay_c Nirbhay Choubey
                Reporter:
                j j
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: