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

Failed to read from the .par file upon concurrent DDL/SELECT with partition pruning

    XMLWordPrintable

    Details

      Description

      The test case is non-deterministic, run with --repeat=N. It fails for me (without rr) within a few attempts on various build types, but it can vary on different machines. The test is rr-able with --rr=-h, although it takes much longer, set repeat=N to a high value for rr.

      --source include/have_innodb.inc
      --source include/have_partition.inc
       
      --connect (con1,localhost,root,,test)
      CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB PARTITION BY HASH (pk) PARTITIONS 4;
      CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=InnoDB;
      SET SESSION INNODB_LOCK_WAIT_TIMEOUT= 0;
      --send
        DROP TABLE t1;
      --connection default
      DROP TABLE t2;
      --error 0,ER_NO_SUCH_TABLE
      SELECT * FROM t1 PARTITION (p3);
       
      # Cleanup
      --connection con1
      --reap
      --disconnect con1
      

      10.6 5e270ca2

      mysqltest: At line 13: query 'SELECT * FROM t1 PARTITION (p3)' failed with wrong errno ER_FAILED_READ_FROM_PAR_FILE (1696): 'Failed to read from the .par file', instead of  (0)...
      

      The failure started happening (or, if it existed before, its probability hugely increased) after this commit in 10.6.8:

      commit 8840583a92243f6ac543689148ca79c85fa0a09d
      Author: Marko Mäkelä
      Date:   Fri Mar 18 10:52:08 2022 +0200
       
          MDEV-27909 InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED ... on DDL
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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