I've been running mariadb
on a Pi zero for several weeks now with no problem. It's just for a couple pet projects. Small DBs and only couple relatively light queries per hour.
Server crashed few days ago and I've been seeing errors like the following below...
Cannot find checkpoint record at LSN (1,0x25b3)
2022-07-06 10:41:00 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-07-06 10:41:00 0 [ERROR] Plugin 'Aria' init function returned error.
2022-07-06 10:41:00 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-07-06 10:41:00 0 [Note] InnoDB: Using Linux native AIO
2022-07-06 10:41:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-07-06 10:41:00 0 [Note] InnoDB: Uses event mutexes
2022-07-06 10:41:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-07-06 10:41:00 0 [Note] InnoDB: Number of pools: 1
2022-07-06 10:41:00 0 [Note] InnoDB: Using generic crc32 instructions
2022-07-06 10:41:00 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-07-06 10:41:00 0 [Note] InnoDB: Completed initialization of buffer pool
2022-07-06 10:41:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-07-06 10:41:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-07-06 10:41:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-07-06 10:41:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-07-06 10:41:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-07-06 10:41:03 0 [Note] InnoDB: Waiting for purge to start
2022-07-06 10:41:03 0 [Note] InnoDB: 10.3.34 started; log sequence number 21723908; transaction id 2124
2022-07-06 10:41:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-07-06 10:41:03 0 [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
2022-07-06 10:41:03 0 [ERROR] Aborting
Warning: Memory not freed: 136569752
I fixed this error by deleting all ARIA_log files and restarting mysqld*
My question is about why this randomly occurred and how to prevent it from happening again. Thanks!