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

Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (i INT) ENGINE=MYISAM 
      PARTITION BY LIST(i) (
        PARTITION p0 VALUES IN (1),
        PARTITION p1 VALUES IN (2)
      );
      ALTER TABLE t1 ROW_FORMAT=COMPRESSED;
      ALTER TABLE t1 DROP PARTITION p1;
      SELECT * FROM t1;
       
      # Cleanup
      DROP TABLE t1;
      

      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
      

      The error certainly started happening in 10.0 after this 5.5 merge:

      commit da4503e956ee067947e504c6e73052d9d906742c
      Merge: babbf8c b000e16
      Author: Sergei Golubchik <serg@mariadb.org>
      Date:   Wed Oct 18 15:14:39 2017 +0200
       
          Merge branch '5.5' into 10.0
      

      However, I am not getting the failure on 5.5.

      Also reproducible with 10.1, 10.2. Couldn't reproduce with MySQL 5.5, 5.6, 5.7.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.