Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
-
None
Description
10.4 30da40bb8c |
2019-01-10 18:02:57 0 [Note] mysqld: Aria engine: starting recovery
|
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (13.3 seconds); transactions to roll back: 1
|
Got error 126 when executing undo undo_key_insert
|
2019-01-10 18:03:11 0 [ERROR] mysqld: Aria engine: Undo phase failed
|
tables to flush: 9 8 7 6 5 4 3 2 1 0
|
2019-01-10 18:03:11 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
|
2019-01-10 18:03:11 0 [ERROR] Plugin 'Aria' init function returned error.
|
2019-01-10 18:03:11 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
|
The backup dirs are here:
ftp://ftp.askmonty.org/public/mdev18203/
backup_before_prepare_0 is the initial full backup
backup_before_prepare_1 is the 1st incremental backup
backup_before_prepare_2 is the 1st incremental backup
backup_0 is the prepared backup after all prepare were executed on it.
To reproduce the failure, restore backup_0 to the datadir and run the server on it. All server default options are sufficient.
If you have doubts about the correctness of prepare, you can run it on non-prepared backups.
mariabackup logs from all stages are attached with hopefully self-explanatory names (mbackup*.log).
I have no information yet whether it affects previous versions.
Attachments
Issue Links
- duplicates
-
MDEV-18310 Aria engine: Undo phase failed with "Got error 121 when executing undo undo_key_delete" upon startup on datadir restored from incremental backup
- Closed
- relates to
-
MDEV-20578 Got error 126 when executing undo undo_key_delete upon Aria crash recovery
- Closed