Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.32
Description
|
https://stackoverflow.com/questions/77484689/xampp-mysql-crashed-during-editing-elementor-page-and-now-wont-restart |
2023-11-14 16:18:28 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 24412
|
Cannot find checkpoint record at LSN (1,0x5c4d)
|
2023-11-14 16:18:28 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
|
2023-11-14 16:18:28 0 [ERROR] Plugin 'Aria' init function returned error.
|
2023-11-14 16:18:28 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
|
From below the summary of problems is:
- Fails to correctly recover all files by default.
- Recommendations are vague (confusing message about -f -o -q)
- Logical solution based on error message, increase sort buffer has no effect.
- Unobvious options (-f -f) needed to be used for it to process.
- deleting aria_log.* should be part of the tool rather than a server recommendation for the user to follow.
~/repos/build-mariadb-server-10.4/./storage/maria/aria_chk -r */*.MAI
|
- recovering (with sort) Aria-table 'mysql/columns_priv.MAI'
|
Data records: 0
|
- Fixing index 1
|
aria_chk: error: aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 16384 rows: 234 sort_length: 1006
|
aria_chk: error: Create index by sort failed
|
State updated
|
Aria table 'mysql/columns_priv.MAI' is not fixed because of errors
|
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
|
|
|
---------
|
...
|
- recovering (with sort) Aria-table 'mysql/help_topic.MAI'
|
Data records: 0
|
- Fixing index 1
|
aria_chk: error: aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 16384 rows: 152917 sort_length: 9
|
aria_chk: error: Create index by sort failed
|
State updated
|
Aria table 'mysql/help_topic.MAI' is not fixed because of errors
|
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
|
|
|
- recovering (with sort) Aria-table 'mysql/proxies_priv.MAI'
|
Data records: 3
|
- Fixing index 1
|
aria_chk: error: aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 16384 rows: 468 sort_length: 849
|
aria_chk: error: Create index by sort failed
|
State updated
|
Aria table 'mysql/proxies_priv.MAI' is not fixed because of errors
|
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
|
|
|
- recovering (with sort) Aria-table 'mysql/tables_priv.MAI'
|
Data records: 1
|
- Fixing index 1
|
aria_chk: error: aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 16384 rows: 468 sort_length: 813
|
aria_chk: error: Create index by sort failed
|
State updated
|
Aria table 'mysql/tables_priv.MAI' is not fixed because of errors
|
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
|
adding larger sort buffer not reflected in output.
$ ~/repos/build-mariadb-server-10.4/./storage/maria/aria_chk --no-defaults --sort-buffer-size=$(( 2 * 1024 * 1024 * 1024 )) -r */*.MAI
|
- recovering (with sort) Aria-table 'mysql/columns_priv.MAI'
|
Data records: 0
|
- Fixing index 1
|
aria_chk: error: aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 16384 rows: 234 sort_length: 1006
|