Arch Linux

cparsons111

Member

Registered: 2020-07-29

Posts: 2

MariaDB fails to start after update; InnoDB

Greetings,

I created a new (Linode) server last week with current Arch install and ported my application. The app uses FCGI and MySQL. I installed MariaDB and had it all working fine yesterday. I then did a pacman -Syu which updated a few things and finished without error. However, after that, my MariaDB(MySQL) will no longer start. See output of "systemctl status mariadb.service" below.

I can't run mysql_upgrade as the service is not running.

If I try another pacman -Syu, it reports that there is nothing to do.

Any idea what I did wrong here?

Thank you
Chris

[root@videux-arch system]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.4.13 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Wed 2020-07-29 20:51:49 UTC; 6s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 452 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 453 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environm>
    Process: 462 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 462 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"

Jul 29 20:51:43 videux-arch mysqld[462]: 2020-07-29 20:51:43 0 [Note] InnoDB: FTS optimize thread exiting.
Jul 29 20:51:48 videux-arch mysqld[462]: 2020-07-29 20:51:48 0 [Note] InnoDB: Starting shutdown...
Jul 29 20:51:49 videux-arch mysqld[462]: 2020-07-29 20:51:49 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Jul 29 20:51:49 videux-arch mysqld[462]: 2020-07-29 20:51:49 0 [ERROR] Plugin 'InnoDB' init function returned error.
Jul 29 20:51:49 videux-arch mysqld[462]: 2020-07-29 20:51:49 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jul 29 20:51:49 videux-arch mysqld[462]: 2020-07-29 20:51:49 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jul 29 20:51:49 videux-arch mysqld[462]: 2020-07-29 20:51:49 0 [ERROR] Aborting
Jul 29 20:51:49 videux-arch systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 29 20:51:49 videux-arch systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jul 29 20:51:49 videux-arch systemd[1]: Failed to start MariaDB 10.4.13 database server.
[root@videux-arch system]# 

cparsons111

Member

Registered: 2020-07-29

Posts: 2

Re: MariaDB fails to start after update; InnoDB

Greetings again,

I found the issue... out of disk space on /dev/sda. Freed up some space and MariaDB started right up. Seems odd that was the only failure but that was definitely the problem.

Sorry for the newbie question.

Cheers
Cp