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

Table corruption upon altering partitions under debug_dbug= "+d,test_pseudo_invisible"

    XMLWordPrintable

Details

    Description

      Note: Most likely it's just a limitation of the debug injection, but it's worth checking, just in case.

      --source include/have_partition.inc
       
      CREATE TABLE t1 (i INT) PARTITION BY HASH (i) PARTITIONS 3;
      SET debug_dbug= "+d,test_pseudo_invisible";
      ALTER TABLE t1 COALESCE PARTITION 1;
      SET debug_dbug= "";
      SELECT * FROM t1;
       
      # Cleanup
      DROP TABLE t1;
      

      With InnoDB

      MariaDB [test]> SELECT * FROM t1;
      ERROR 1932 (42S02): Table 'test.t1' doesn't exist in engine
      

      With MyISAM

      MariaDB [test]> SELECT * FROM t1;
      ERROR 1030 (HY000): Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM
      

      Attachments

        Issue Links

          Activity

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1h 20m
                  1h 20m

                  Git Integration

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