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

CHECK command wrongly reports table corruption

    XMLWordPrintable

Details

    Description

      Table corruption reported for versioned partitioned table after DELETE: "Found a misplaced row"

      --source include/have_partition.inc
      		 
       
      		 
      CREATE TABLE t1 (a INT) WITH SYSTEM VERSIONING PARTITION BY system_time LIMIT 3 (PARTITION p1 HISTORY, PARTITION p2 HISTORY, PARTITION pn CURRENT);
      		 
      INSERT INTO t1 VALUES (1),(2),(3),(4);
      		 
      DELETE FROM t1;
      		 
      DELETE FROM t1;
      		 
      CHECK TABLE t1;
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t1;

      10.3 352e7667

      		 
      CHECK TABLE t1;
      		 
      Table	Op	Msg_type	Msg_text
      		 
      test.t1	check	error	Found a misplaced row
      		 
      test.t1	check	error	Partition p1 returned error
      		 
      test.t1	check	error	Upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it!

      All of debug, ASAN, release builds produce the same result.
      Reproducible on 10.3-10.5 with at least InnoDB, MyISAM, Aria.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25552 system versioned partitioned by LIMIT tables break CHECK TABLE

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-21358 Implement CHECK for history partitions rotated by LIMIT

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21641 CHECK reports a misplaced row on partitioned table after dropping versioning

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22413 Server hangs upon UPDATE/DELETE on a view reading from versioned partitioned table

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33125 CHECK TABLE does not recognize corruption after EXCHANGE WITHOUT VALIDATION on system-time partitioning

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

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.