SYSTEM INFORMATION | |
---|---|
OS type and version | Rocky Linux 9.4 |
Virtualmin version | 7.10.0 Pro |
I have 8 sites on my server that back up overnight on Thursday night / Friday morning, running either WordPress or Joomla. This morning when I checked my messages, I had notifications that the first 6 backed up without issue, then a mySQL server down message from Virtualmin itself. That I know of, nothing changed overnight, and there are no package updates or other notices that would indicate a change.
I tried restarting the service, and got an error (full details below). I rebooted the VM that is running virtualmin, no change. I rebooted the host for the VM (as noted in a Stack Exchange post), still nothing.
What can I do to get MariaDB back up and running? Full error messages are below.
(I am leaving for the weekend in a few hours, so I may not get back to this until Monday, possibly Sunday night.)
Error from Dashboard / MariaDB Module:
Error! MariaDB is not running on your system - database list could not be retrieved.
MariaDB error message
The full MariaDB error message was : DBI connect failed : Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (111) ?
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
Results from running systemctl status mariadb.service:
root@www:~# systemctl status mariadb.service
Γ mariadb.service - MariaDB 10.5 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
Active: failed (Result: exit-code) since Fri 2024-07-05 11:51:08 EDT; 9s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 8859 ExecStartPre=/usr/libexec/mariadb-check-socket (code=exited, status=0/SUCCESS)
Process: 8885 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
Process: 8920 ExecStart=/usr/libexec/mariadbd --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
Main PID: 8920 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 8.452s
Jul 05 11:51:06 www.aiskon.net systemd[1]: Starting MariaDB 10.5 database server...
Jul 05 11:51:06 www.aiskon.net mariadb-check-socket[8859]: Socket file /var/lib/mysql/mysql.sock exists.
Jul 05 11:51:06 www.aiskon.net mariadb-check-socket[8859]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed autom>
Jul 05 11:51:06 www.aiskon.net mariadb-prepare-db-dir[8885]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jul 05 11:51:06 www.aiskon.net mariadb-prepare-db-dir[8885]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jul 05 11:51:08 www.aiskon.net systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 05 11:51:08 www.aiskon.net systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jul 05 11:51:08 www.aiskon.net systemd[1]: Failed to start MariaDB 10.5 database server.
Jul 05 11:51:08 www.aiskon.net systemd[1]: mariadb.service: Consumed 8.452s CPU time.
lines 1-21/21 (END)
root@www:/var/lib/mysql#
Results from running journalctl -xeu mariadb.service:
root@www:/var/lib/mysql# journalctl -xeu mariadb.service
ββ
ββ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Jul 05 11:51:08 www.aiskon.net systemd[1]: Failed to start MariaDB 10.5 database server.
ββ Subject: A start job for unit mariadb.service has failed
ββ Defined-By: systemd
ββ Support: https://wiki.rockylinux.org/rocky/support
ββ
ββ A start job for unit mariadb.service has finished with a failure.
ββ
ββ The job identifier is 8469 and the job result is failed.
Jul 05 11:51:08 www.aiskon.net systemd[1]: mariadb.service: Consumed 8.452s CPU time.
ββ Subject: Resources consumed by unit runtime
ββ Defined-By: systemd
ββ Support: https://wiki.rockylinux.org/rocky/support
ββ
ββ The unit mariadb.service completed and consumed the indicated resources.
Jul 05 11:53:24 www.aiskon.net systemd[1]: Starting MariaDB 10.5 database server...
ββ Subject: A start job for unit mariadb.service has begun execution
ββ Defined-By: systemd
ββ Support: https://wiki.rockylinux.org/rocky/support
ββ
ββ A start job for unit mariadb.service has begun execution.
ββ
ββ The job identifier is 9057.
Jul 05 11:53:24 www.aiskon.net mariadb-prepare-db-dir[10269]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Jul 05 11:53:24 www.aiskon.net mariadb-prepare-db-dir[10269]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Jul 05 11:53:25 www.aiskon.net systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
ββ Subject: Unit process exited
ββ Defined-By: systemd
ββ Support: https://wiki.rockylinux.org/rocky/support
ββ
ββ An ExecStart= process belonging to unit mariadb.service has exited.
ββ
ββ The process' exit code is 'exited' and its exit status is 1.
Jul 05 11:53:25 www.aiskon.net systemd[1]: mariadb.service: Failed with result 'exit-code'.
ββ Subject: Unit failed
ββ Defined-By: systemd
ββ Support: https://wiki.rockylinux.org/rocky/support
ββ
ββ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Jul 05 11:53:25 www.aiskon.net systemd[1]: Failed to start MariaDB 10.5 database server.
ββ Subject: A start job for unit mariadb.service has failed
ββ Defined-By: systemd
ββ Support: https://wiki.rockylinux.org/rocky/support
ββ
ββ A start job for unit mariadb.service has finished with a failure.
ββ
ββ The job identifier is 9057 and the job result is failed.
root@www:/var/lib/mysql#