Solved MariaDB update went wrong

[Davey]

Performed a custombuild update from 10.3 to 10.6, and now MariaDB won't start.

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

Can any body help?

[root@e90 admin]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Sat 2024-12-21 22:49:31 CET; 47s ago
Process: 31762 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 31742 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && syste mctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 31740 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 31762 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Dec 21 22:49:31 e90.weduwe.com mysqld[31762]: 2024-12-21 22:49:31 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Dec 21 22:49:31 e90.weduwe.com mysqld[31762]: 2024-12-21 22:49:31 0 [Note] InnoDB: Starting shutdown...
Dec 21 22:49:31 e90.weduwe.com mysqld[31762]: 2024-12-21 22:49:31 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Dec 21 22:49:31 e90.weduwe.com mysqld[31762]: 2024-12-21 22:49:31 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 21 22:49:31 e90.weduwe.com mysqld[31762]: 2024-12-21 22:49:31 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Dec 21 22:49:31 e90.weduwe.com mysqld[31762]: 2024-12-21 22:49:31 0 [ERROR] Aborting
Dec 21 22:49:31 e90.weduwe.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Dec 21 22:49:31 e90.weduwe.com systemd[1]: Failed to start MariaDB database server.
Dec 21 22:49:31 e90.weduwe.com systemd[1]: Unit mariadb.service entered failed state.
Dec 21 22:49:31 e90.weduwe.com systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
[root@e90 admin]#

 

[Davey]

Did a Install/update MariaDB again. No luck

 

[Richard G]

You might want to try this.
Login as root via SSH, then navigat to the /var/lib/mysql directory.

There you will see (if all is fine) a ib_logfile0 maybe also a ib_logfile1.
Rename or backup these files (copy or move to another directory).

Then stop mariadb and start it again:
systemctl stop mysqld systemctl start mysqld

Does mariadb start then or still the same error?

If the same error, post the contents of your /etc/my.cnf file.

 

[Davey]

So happy with this forum. You are my hero !!!
This did the trick.