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

Random innodb index corruption

    XMLWordPrintable

Details

    Description

      We are starting to experience random table index corruption on our more busy (read and write) databases. We've had these databases for over 8 years, and have gone through multiple upgrades over the years, however, nothing recently has changed, and these random corrupt indexes just started showing up.

      Currently, unable to find the proper method to troubleshoot what is causing this corruption, the log files look clean leading up to the corruption, and then just the random:
      2024-05-01 23:56:02 172 [ERROR] mariadbd: Index for table 'BusyTableHere' is corrupt; try to repair it

      Attachments

        Activity

          People

            Unassigned Unassigned
            dbray_sd Daniel Bray
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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