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:

                Git Integration

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