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

index Corruption occur

    XMLWordPrintable

Details

    Description

      We faced to index corruption in innodb table.

      2024-11-20  2:04:11 4299263 [ERROR] mariadbd: Index for table 'message' is corrupt; try to repair it
      		 
      2024-11-20  2:04:11 4299257 [ERROR] InnoDB: We detected index corruption in an InnoDB type table. You have to dump + drop + reimport the table or, in a case of widespread corruption, dump all InnoDB tables and recreate the whole tablespace. If the mariadbd server crashes after the startup or when you dump the tables. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

      We couldn't backup table with mysqldump, but we can drop table.
      So we drop table and recreate it using slave table.

      Is there any cases that index was corrupted?
      Do you know reason why table or index is corrupted?
      And How can we prevent corruption of index?

      Attachments

        1. my-2.cnf
          5 kB
        2. table.txt
          0.7 kB
        3. query.txt
          0.8 kB

        Activity

          People

            Unassigned Unassigned
            supbaek baek seung ho
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.