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

Index for versioned table gets corrupt after partitioning and DELETE

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

            Transition Time In Source Status Execution Times
            Eugene Kosov (Inactive) made transition -
            Open In Progress
            		53d 23h 50m 1
            Eugene Kosov (Inactive) made transition -
            In Progress In Review
            		30s 1
            Sergei Golubchik made transition -
            In Review Stalled
            		26d 23h 39m 1
            Sergei Golubchik made transition -
            Stalled Closed
            		9d 17h 2m 1

            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.