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

InnoDB: Table ... contains <n> indexes inside InnoDB, which is different from the number of indexes <n> defined in the MariaDB

    XMLWordPrintable

Details

    Description

      Customer reported the following error when running alter table <x> add index.

      [10.3.18]
      		 
      2020-03-15 1:00:03 1573540 [ERROR] InnoDB: Table status/currenteustatus20200315 contains 5 indexes inside InnoDB, which is different from the number of indexes 4 defined in the MariaDB Have you mixed up .frm files from different installations? See https://mariadb.com/kb/en/innodb-troubleshooting/

      this is exactly like MDEV-21669, but it wasn't fixed in 10.3.18. When I ran repro with 10.4.12, it returned the warning instead of error. In order to reproduce this, I've set data directory to read-only mode in windows and then it returned the following warning.

      [10.4.12]
      		 
      INNODB: TABLE test/currenteustatus20200315 CONTAINS 7 INDEXES inside INNODB, which IS different FROM the NUMBER OF INDEXES 6 defined IN the MariaDB

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-17567 Atomic DDL

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

          Web Link dba stack exhange question of the same form

          Activity

            People

              wlad Vladislav Vaintroub
              allen.lee@mariadb.com Allen Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.