Service mysqld down. Cannot be restarted

dorucrisan

dorucrisan

Verified User
Joined
Oct 23, 2021
Messages
136
Location
Bucharest / Romania
Out of the sudden server died with the message "service mysqld down" It does not restart. Outpu as below. Any advice please?

login as: root
[email protected]'s password:
Last failed login: Tue Sep 6 10:08:54 EEST 2022 from 194.163.162.178 on ssh:not ty
There were 8 failed login attempts since the last successful login.
Last login: Mon Sep 5 13:32:31 2022 from 5.2.136.14
[root@host ~]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service
Job for mariadb.service failed because the control process exited with error cod e.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
[root@host ~]#
 
Can you share the output of `systemctl status mariadb.service`?

Or better yet, if you have mysql logging enabled (typically in the /var/log/ directory, sometimes /var/lib/mysql), can you share the last couple hundred lines from it?
 
login as: root
[email protected]'s password:
Last failed login: Tue Sep 6 11:15:36 EEST 2022 from 101.32.223.224 on ssh:nott y
There were 5 failed login attempts since the last successful login.
Last login: Tue Sep 6 10:25:11 2022 from 5.2.136.14
[root@host ~]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset:>
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Tue 2022-09-06 11:15:14 EEST; 46s a>
Process: 96645 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_>
Process: 96510 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exi>
Process: 96509 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_STA>
Main PID: 96645 (code=exited, status=7)
Status: "MariaDB server is down"

Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [ERRO>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [ERRO>
Sep 06 11:15:14 host.kingsecurity.ro systemd[1]: mariadb.service: Main process >
Sep 06 11:15:14 host.kingsecurity.ro systemd[1]: mariadb.service: Failed with r>
Sep 06 11:15:14 host.kingsecurity.ro systemd[1]: Failed to start MariaDB databa>
lines 1-21/21 (END)
● 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 Tue 2022-09-06 11:15:14 EEST; 46s ago
Process: 96645 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION>
Process: 96510 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/g>
Process: 96509 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=ex>
Main PID: 96645 (code=exited, status=7)
Status: "MariaDB server is down"

Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note] InnoDB: File '/www>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note] InnoDB: Waiting fo>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note] InnoDB: 10.4.26 st>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note] InnoDB: Loading bu>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [Note] Plugin 'FEEDBACK' >
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [ERROR] /usr/sbin/mysqld:>
Sep 06 11:15:11 host.kingsecurity.ro mysqld[96645]: 2022-09-06 11:15:11 0 [ERROR] Aborting
Sep 06 11:15:14 host.kingsecurity.ro systemd[1]: mariadb.service: Main process exited, code=exited,>
Sep 06 11:15:14 host.kingsecurity.ro systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 06 11:15:14 host.kingsecurity.ro systemd[1]: Failed to start MariaDB database server.
~
~
lines 1-21/21 (END)
 
The output is truncated. All I can see is that there is an ERROR, but not what the error is.
Can you provide the full output?
Might be worth uploading to pastebin
 
that was all, I pasted all. only if this form is truncated or limited somehow. what else to check and where exactly is the mysql error log?
 
log can be in /var/log/ or /var/lib/mysql/ or in /home/mysql/ depends on your configuration
 
You must log in or register to reply here.
Back
Top