Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2, 10.3, 10.4
-
None
Description
The failure looks somewhat similar to MDEV-18203, but this one is reproducible on all 10.2+ and does not require encryption (and it's undo_key_delete instead of undo_key_insert), so I'll file it separately.
|
10.2 5ec4efb7 |
2019-09-13 2:23:05 140564631615296 [Note] mysqld: Aria engine: starting recovery
|
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (18.4 seconds); transactions to roll back: 1
|
Got error 126 when executing undo undo_key_delete
|
2019-09-13 2:23:23 140564631615296 [ERROR] mysqld: Aria engine: Undo phase failed
|
tables to flush: 9 8 7 6 5 4 3 2 1 0
|
2019-09-13 2:23:23 140564631615296 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
|
2019-09-13 2:23:23 140564631615296 [ERROR] Plugin 'Aria' init function returned error.
|
2019-09-13 2:23:23 140564631615296 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
|
2019-09-13 2:23:23 140564631615296 [Note] Plugin 'FEEDBACK' is disabled.
|
2019-09-13 2:23:23 140564631615296 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
|
2019-09-13 2:23:23 140564631615296 [ERROR] Aborting
|
Attention: use the RQG branch as described below, it is tuned for reproducing the failure
Remember to use the correct basedir, and modify vardir if necessary.
The test fails almost every time for me, but sometimes it misses the mark, just re-run it if it didn't fail.
git clone https://github.com/MariaDB/randgen --branch mdev20578 rqg-mdev20578
|
cd rqg-mdev20578
|
perl runall-new.pl --basedir=<basedir> --grammar=./mdev20578.yy --skip-gendata --gendata-advanced --duration=60 --threads=1 --seed=1 --reporter=CrashRecovery --vardir=/dev/shm/mdev20578
|
Attachments
Issue Links
- is part of
-
-
- Open
-
- relates to
-
MDEV-18203
Aria engine: Undo phase failed with "Got error 126 when executing undo undo_key_insert" upon startup on datadir restored from incremental backup
-
- Closed
-
-
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
-