Troubleshooting
Problem
MariaDB does not start, error message is `Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded`
mariadb: 2024-08-07 20:37:26 *** DB Component Startup
mariadb: 2024-08-07 20:37:26 *** MariaDB restart
mariadb: 2024-08-07 20:37:26 *** Awaiting connection to perform any needed data upgrades
mariadb: 2024-08-07 20:37:26 0 [Note] Starting MariaDB 10.5.23-MariaDB source revision 6cfd2ba397b0ca689d8ff1bdb9fc4a4dc516a5eb as process 84
mariadb: Cannot find checkpoint record at LSN (1,0x34a948)
mariadb: 2024-08-07 20:37:26 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables (*.MAI) and delete all aria_log.######## files
mariadb: 2024-08-07 20:37:26 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Uses event mutexes
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Number of pools: 1
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Using Linux native AIO
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Completed initialization of buffer pool
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Opened 8 undo tablespaces
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: Opened 8 undo tablespaces
mariadb: 2024-08-07 20:37:26 0 [Note] InnoDB: 128 rollback segments in 8 undo tablespaces are active.
mariadb: 2024-08-07 20:37:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mariadb: 2024-08-07 20:37:27 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mariadb: 2024-08-07 20:37:31 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mariadb: 2024-08-07 20:37:31 0 [Note] InnoDB: 10.5.23 started; log sequence number 335248647594; transaction id 4124436
mariadb: 2024-08-07 20:37:31 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mariadb: 2024-08-07 20:37:31 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
mariadb: 2024-08-07 20:37:31 0 [ERROR] Failed to initialize plugins.
mariadb: 2024-08-07 20:37:31 0 [ERROR] Aborting
mariadb: 2024-08-07 20:37:55 --- MariaDB is slow starting up, perhaps performing recovery after a crash.
mariadb: 2024-08-07 20:37:55 --- This script will wait forever; if this is unexpected, please manually kill this script and investigate
```
Symptom
The pods that use mariadb won't start. Mariadb service or db pod won't be running.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFV9Z","label":"IBM Turbonomic Application Resource Management"},"ARM Category":[{"code":"a8m3p000000PCRRAA4","label":"System"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
12 August 2024
UID
ibm17165350