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

DELETE with FKs crashes Galera nodes if wsrep_slave_threads>1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.2.12, 10.2.13, 10.3.5
    • 10.2.15
    • Galera
    • None

    Description

      It just takes a two(with more is the same) nodes Galera cluster with wsrep_slave_threads>1 on the Slave node(s).
      On the Master node import the sql files in sequence and you'll get the crash with error log full of messages of the type:

      2018-02-08 11:41:04 140048415356672 [Note] InnoDB: SQL1: DELETE FROM `CA9176ed2945`/)|Z�'
      2018-02-08 11:41:04 140048415356672 [Note] InnoDB: SQL2:
      2018-02-08 11:41:04 140048415356672 [ERROR] mysqld: Can't find record in 'CA9176ed2945'
      2018-02-08 11:41:04 140048415356672 [ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table c17580.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 799009, Internal MariaDB error code: 1032

      Attachments

        1. c17580.tar.gz
          2.07 MB
          Claudio Nanni
        2. error_log.txt
          33 kB
          Zdravelina Sokolovska
        3. server1.cnf
          1 kB
          Claudio Nanni
        4. server2.cnf
          1 kB
          Claudio Nanni

        Issue Links

          Activity

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              claudio.nanni Claudio Nanni
              Votes:
              1 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.