I tried updating my MariaDB server from 10.3 to 10.11.7 on my CentOS Stream virtual machine.
I used the following statements:
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-10.11"
sudo yum update mariadb-server
sudo systemctl restart mariadb
And this is giving me the following errors using systemctl status mariadb.service
:
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: No valid checkpoint was found; the log was created with MariaDB 10.3.28.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [Note] InnoDB: Starting shutdown...
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [Note] Plugin 'FEEDBACK' is disabled.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Unknown/unsupported storage engine: InnoDB
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Aborting
May 13 10:32:34 Dev-DB systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
May 13 10:32:34 Dev-DB systemd[1]: mariadb.service: Failed with result 'exit-code'.
May 13 10:32:34 Dev-DB systemd[1]: Failed to start MariaDB 10.11.7 database server.
Using journalctl -xe
i am getting the following output:
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Obtaining redo log encryption key version 1 failed (4294967295). Maybe the key or the required encryption key management plugin was not found.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Reading checkpoint encryption info failed.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Obtaining redo log encryption key version 1 failed (4294967295). Maybe the key or the required encryption key management plugin was not found.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Reading checkpoint encryption info failed.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: No valid checkpoint was found; the log was created with MariaDB 10.3.28.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [Note] InnoDB: Starting shutdown...
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [Note] Plugin 'FEEDBACK' is disabled.
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Unknown/unsupported storage engine: InnoDB
May 13 10:32:34 Dev-DB mariadbd[1158171]: 2024-05-13 10:32:34 0 [ERROR] Aborting
I’ve tried the solutions from this thread Getting error “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed” when starting MySQL:
So far i’ve tried:
- renaming/moving the ib_logfile0 and ib_logfile1 files
- innodb_force_recovery = 1
Both of these options didn’t solve my issue.
How do I solve this issue?