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

Index for versioned table gets corrupt after partitioning and DELETE

    XMLWordPrintable

Details

    Description

      Note: The test is non-deterministic, run with --repeat. It fails for me within 10 attempts, but it can vary on different machines. ASAN or Valgrind don't help.

      --source include/have_partition.inc
      		 
       
      		 
      CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=MyISAM WITH SYSTEM VERSIONING;
      		 
      INSERT INTO t1 VALUES (11),(12);
      		 
      ALTER TABLE t1 PARTITION BY KEY() PARTITIONS 3;
      		 
      DELETE FROM t1 WHERE pk >= 0;
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t1;

      10.3 9d97e6010eb

      		 
      mysqltest: At line 6: query 'DELETE FROM t1 WHERE pk >= 0' failed: 126: Index for table './test/t1#P#p1.MYI' is corrupt; try to repair it

      Also reproducible with Aria. Could not reproduce with InnoDB.

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-15923 option to control who can set session @@timestamp

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15458 Segfault in heap_scan() upon UPDATE after ADD SYSTEM VERSIONING

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16231 make DELETE use mysql_update() internally

          • Major - Major loss of function.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              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.