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

Galera: Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;

Details

    Description

      Release build.
      Only DML Load is running on all 3 nodes and 3 threads per node. 

      023-12-14  8:08:47 11 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table pstress.tt_1; Can't find record in 'tt_1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 896130, Internal MariaDB error code: 1032
      		 
      2023-12-14  8:08:47 0 [Note] WSREP: Member 2(node3) initiates vote on 57a05d6e-9a51-11ee-801d-d61d36b2781b:4915021,f78a87a20ae77a6c:  Can't find record in 'tt_1', Error_code: 1032;
      		 
      2023-12-14  8:08:47 0 [Note] WSREP: Votes over 57a05d6e-9a51-11ee-801d-d61d36b2781b:4915021:
      		 
         f78a87a20ae77a6c:   1/3
      		 
      Waiting for more votes.
      		 
      2023-12-14  8:08:47 0 [Note] WSREP: Member 0(node1) responds to vote on 57a05d6e-9a51-11ee-801d-d61d36b2781b:4915021,0000000000000000: Success
      		 
      2023-12-14  8:08:47 0 [Note] WSREP: Votes over 57a05d6e-9a51-11ee-801d-d61d36b2781b:4915021:
      		 
         0000000000000000:   1/3
      		 
         f78a87a20ae77a6c:   1/3
      		 
      Waiting for more votes.
      		 
      2023-12-14  8:08:47 11 [Warning] WSREP: Event 115 Update_rows_v1 apply failed: 120, seqno 4915021
      		 
      2023-12-14  8:08:47 0 [Note] WSREP: Member 1(node2) initiates vote on 57a05d6e-9a51-11ee-801d-d61d36b2781b:4915021,f78a87a20ae77a6c:  Can't find record in 'tt_1', Error_code: 1032;
      		 
      2023-12-14  8:08:47 0 [Note] WSREP: Votes over 57a05d6e-9a51-11ee-801d-d61d36b2781b:4915021:
      		 
         0000000000000000:   1/3
      		 
         f78a87a20ae77a6c:   2/3
      		 
      Winner: f78a87a20ae77a6c

      using pstress

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33291 Slave SQL: Could not execute Delete_rows_v1/Update_rows_v1 event; Can't find record, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND or HA_ERR_NO_PARTITION_FOUND

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            janlindstrom Jan Lindström added a comment -

            rahulmalik I would need node configs, error log from all nodes (use wsrep-debug=1) and binlogs from all nodes.

            janlindstrom Jan Lindström added a comment - rahulmalik I would need node configs, error log from all nodes (use wsrep-debug=1) and binlogs from all nodes.

            People

              janlindstrom Jan Lindström
              rahulmalik Rahul (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.