We lost power over the weekend and our database is now failing to start up. I have searched with no success to help recover from this failulre and would greatly appreciate any assistance. Below are the results from my systemctl status mariadb.service and journalctl -xe.
Zabbix 4.0 on Centos 7.7.1908
systemctl status mariadb.service result
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2020-06-22 10:36:44 EDT; 3h 59min ago
Process: 5314 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
Process: 5313 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Process: 5276 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 5313 (code=exited, status=0/SUCCESS)
Jun 22 10:36:43 hostname systemd[1]: Starting MariaDB database server...
Jun 22 10:36:43 hostname mariadb-prepare-db-dir[5276]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jun 22 10:36:43 hostname mariadb-prepare-db-dir[5276]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jun 22 10:36:43 hostname mysqld_safe[5313]: 200622 10:36:43 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jun 22 10:36:43 hostname mysqld_safe[5313]: 200622 10:36:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jun 22 10:36:44 hostname systemd[1]: mariadb.service: control process exited, code=exited status=1
Jun 22 10:36:44 hostname systemd[1]: Failed to start MariaDB database server.
Jun 22 10:36:44 hostname systemd[1]: Unit mariadb.service entered failed state.
Jun 22 10:36:44 hostname systemd[1]: mariadb.service failed.
journalctl -xe result
-- Unit mariadb.service has begun starting up.
Jun 22 09:15:04 mariadb-prepare-db-dir[4066]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jun 22 09:15:04 mariadb-prepare-db-dir[4066]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jun 22 09:15:04 mysqld_safe[4103]: 200622 09:15:04 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jun 22 09:15:04 mysqld_safe[4103]: 200622 09:15:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jun 22 09:15:05 systemd[1]: mariadb.service: control process exited, code=exited status=1
Jun 22 09:15:05 systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Jun 22 09:15:05 systemd[1]: Unit mariadb.service entered failed state.
Jun 22 09:15:05 systemd[1]: mariadb.service failed.
Jun 22 09:15:05 polkitd[1912]: Unregistered Authentication Agent for unix-process:4060:203374 (system bus name :1.72, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected fr
Jun 22 09:15:05 sudo[4059]: pam_unix(sudo:session): session closed for user root
[root@root ~]# tail -f /var/log/messages
Jun 22 09:10:01 hostname systemd: Started Session 5 of user root.
Jun 22 09:15:04 hostname systemd: Starting MariaDB database server...
Jun 22 09:15:04 hostname mariadb-prepare-db-dir: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jun 22 09:15:04 hostname mariadb-prepare-db-dir: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jun 22 09:15:04 hostname mysqld_safe: 200622 09:15:04 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jun 22 09:15:04 hostname mysqld_safe: 200622 09:15:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jun 22 09:15:05 hostname systemd: mariadb.service: control process exited, code=exited status=1
Jun 22 09:15:05 hostname systemd: Failed to start MariaDB database server.
Jun 22 09:15:05 hostname systemd: Unit mariadb.service entered failed state.
Jun 22 09:15:05 hostname systemd: mariadb.service failed.
Zabbix 4.0 on Centos 7.7.1908
systemctl status mariadb.service result
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2020-06-22 10:36:44 EDT; 3h 59min ago
Process: 5314 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
Process: 5313 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Process: 5276 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 5313 (code=exited, status=0/SUCCESS)
Jun 22 10:36:43 hostname systemd[1]: Starting MariaDB database server...
Jun 22 10:36:43 hostname mariadb-prepare-db-dir[5276]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jun 22 10:36:43 hostname mariadb-prepare-db-dir[5276]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jun 22 10:36:43 hostname mysqld_safe[5313]: 200622 10:36:43 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jun 22 10:36:43 hostname mysqld_safe[5313]: 200622 10:36:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jun 22 10:36:44 hostname systemd[1]: mariadb.service: control process exited, code=exited status=1
Jun 22 10:36:44 hostname systemd[1]: Failed to start MariaDB database server.
Jun 22 10:36:44 hostname systemd[1]: Unit mariadb.service entered failed state.
Jun 22 10:36:44 hostname systemd[1]: mariadb.service failed.
journalctl -xe result
-- Unit mariadb.service has begun starting up.
Jun 22 09:15:04 mariadb-prepare-db-dir[4066]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jun 22 09:15:04 mariadb-prepare-db-dir[4066]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jun 22 09:15:04 mysqld_safe[4103]: 200622 09:15:04 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jun 22 09:15:04 mysqld_safe[4103]: 200622 09:15:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jun 22 09:15:05 systemd[1]: mariadb.service: control process exited, code=exited status=1
Jun 22 09:15:05 systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Jun 22 09:15:05 systemd[1]: Unit mariadb.service entered failed state.
Jun 22 09:15:05 systemd[1]: mariadb.service failed.
Jun 22 09:15:05 polkitd[1912]: Unregistered Authentication Agent for unix-process:4060:203374 (system bus name :1.72, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected fr
Jun 22 09:15:05 sudo[4059]: pam_unix(sudo:session): session closed for user root
[root@root ~]# tail -f /var/log/messages
Jun 22 09:10:01 hostname systemd: Started Session 5 of user root.
Jun 22 09:15:04 hostname systemd: Starting MariaDB database server...
Jun 22 09:15:04 hostname mariadb-prepare-db-dir: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jun 22 09:15:04 hostname mariadb-prepare-db-dir: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jun 22 09:15:04 hostname mysqld_safe: 200622 09:15:04 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jun 22 09:15:04 hostname mysqld_safe: 200622 09:15:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jun 22 09:15:05 hostname systemd: mariadb.service: control process exited, code=exited status=1
Jun 22 09:15:05 hostname systemd: Failed to start MariaDB database server.
Jun 22 09:15:05 hostname systemd: Unit mariadb.service entered failed state.
Jun 22 09:15:05 hostname systemd: mariadb.service failed.
Comment