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

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

          relates to

          Task - A task that needs to be done. MDEV-17567 Atomic DDL

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-27180 Fully atomic partitioning DDL operations

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27618 Atomic DDL is not very atomic on partitioned tables

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30583 DB_DUPLICATE_KEY on CREATE OR REPLACE after ALTER TABLE change engine

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35811 main.mysqldump-system fails with extra entries in innodb_index_stats

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36352 main.partition_explicit_prune sporadically crashes on loong64

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.