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

Index Corruption on Database Restore

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.6.18
    • 10.6.21
    • Backup
    • Ubuntu 22.04.5
      mysql Ver 15.1 Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64)

    Description

      I have a logical database backup that causes a corrupted index error on restore. I've narrowed down the problem to one table and one index in that table.

      Here is a Google Drive link of a tgz containing a trimmed down version of the backup, which should allow you to recreate the issue on restoring to an empty database. This also includes the contents of the error log at the time of the error and the cnf files I'm using.

      The table name in the backup is AuditLog, and it seems that the index "uri_index" is causing the problem. If I manually remove the uri_index from the backup file, the restore works as expected.

      Let me know if any more information would be useful.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              coreyoss Corey Smith
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.