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

InnoDB index corruption

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 11.4.2
    • N/A
    • None

    Description

      2024-07-16 7:32:15 7 [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 InnoD
      B 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-mod
      es/ for information about forcing recovery.
      2024-07-16 7:32:15 7 [ERROR] mariadbd: Index for table 'total_main_log' is corrupt; try to repair it
      2024-07-16 7:32:15 7 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table prol2.total_main_log; Index for table 'total_main_log' is corrupt; try to repair it, Error_
      code: 1034; handler error HA_ERR_CRASHED; the event's master log mysql-bin.000834, end_log_pos 0, Gtid 0-2-1062387710, Internal MariaDB error code: 1034
      2024-07-16 07:32:15 0x7f4682d08700 InnoDB: Assertion failure in file /home/buildbot/amd64-rhel-8-rpm-autobake/build/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/storage/innobase/page/page0
      zip.cc line 4291
      InnoDB: Failing assertion: slot_rec
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mariadbd startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      InnoDB: about forcing recovery.
      240716 7:32:15 [ERROR] mysqld got signal 6 ; Sorry, we probably made a mistake, and this is a bug.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Rylov Michael
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.