Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.6.18
-
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
- relates to
-
MDEV-32174 ROW_FORMAT=COMPRESSED table corruption due to ROLLBACK
-
- Closed
-