Failed to start MariaDB database server (MariaDB server is down / timeout )

alemmsm

Verified User
Joined
Nov 9, 2017
Messages
43
mysqld has no problem above, only MariaDB gives an error And will not restart. I installed mysqld + mariadb from the beginning, but it still gives an error. All versions of the latest versions are on CentOS8

Mysqld does not STOP in Direct Admin either

restarts again after pressing the STOP button

This problem occurred after executing the commands (attached photo)

90.jpg

[root@server ~]# service mysqld status

Redirecting to /bin/systemctl status mysqld.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: timeout) since Tue 2020-12-29 20:03:28 CET; 24min ago
Process: 19000 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 18971 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemc>
Process: 18969 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 19000 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Dec 29 20:03:27 server.xx.xx mysqld[19000]: 2020-12-29 20:03:27 0 [Note] InnoDB: Starting shutdown...
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Plugin 'InnoDB' init function returned error.
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not >
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Failed to initialize plugins.
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Aborting
Dec 29 20:03:28 server.xx.xx systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 29 20:03:28 server.xx.xx systemd[1]: mariadb.service: Failed with result 'timeout'.
Dec 29 20:03:28 server.xx.xx systemd[1]: Failed to start MariaDB database server.
lines 1-21/21 (END)...skipping...
● 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: timeout) since Tue 2020-12-29 20:03:28 CET; 24min ago
Process: 19000 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 18971 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-envi>
Process: 18969 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 19000 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Dec 29 20:03:27 server.xx.xx mysqld[19000]: 2020-12-29 20:03:27 0 [Note] InnoDB: Starting shutdown...
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Plugin 'InnoDB' init function returned error.
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Failed to initialize plugins.
Dec 29 20:03:28 server.xx.xx mysqld[19000]: 2020-12-29 20:03:28 0 [ERROR] Aborting
Dec 29 20:03:28 server.xx.xx systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 29 20:03:28 server.xx.xx systemd[1]: mariadb.service: Failed with result 'timeout'.
Dec 29 20:03:28 server.xx.xx systemd[1]: Failed to start MariaDB database server.


sudo systemctl restart mariadb Job for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for details.

my.cnf :

[mysqld]
max_allowed_packet=64M
local-infile=0
innodb_file_per_table=1
query_cache_type=1
query_cache_size =32M
query_cache_limit=1M
 
Back
Top