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

LP:534626 - MyISAM table created in MariaDB not readable by MySQL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      I created a simple table in MariaDB and then when I tried to access it in MySQL, the table is reported as damaged and can't be repaired.

      Versions used were 5.1.42 of each on Linux x86.

      Script:

      In MariaDB:

      use test;
      CREATE TABLE t1 (a char(100), b int) ENGINE=myisam;
      INSERT INTO t1 values ('aaaa', 10);
      SELECT * FROM t1;

      Shutdown MariaDB and point MySQL at the same datadir.

      In MySQL:

      use test;
      SELECT * FROM t1;
      REPAIR TABLE t1;

      Errors from MySQL:

      mysql> select * from t1;
      ERROR 1035 (HY000): Old key file for table 't1'; repair it!
      mysql> repair table t1;
      --------------------------------------------------------------+

      Table Op Msg_type Msg_text

      --------------------------------------------------------------+

      test.t1 repair Error Old key file for table 't1'; repair it!
      test.t1 repair error Corrupt

      --------------------------------------------------------------+
      2 rows in set (0.00 sec)

      Attachments

        Activity

          People

            Unassigned Unassigned
            harrisonfisk Harrison Fisk (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.