System restore fails Mariadb
I had to make a system restore from a backup because of a hard disk failure. I did that manually but the db is failing to start.
From the /var/lib/mysql/domain.err file i have the following
[CODE=bash]2020-12-05T23:50:19.661984Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL)
2020-12-05T23:50:19.735641Z 2 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:50:19.765721Z 3 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:50:19.768840Z 4 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:50:19.769488Z 5 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:50:19.835821Z 8 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:51:42.357682Z 12 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:51:44.932140Z 13 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:51:44.933143Z 14 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:52:44.445352Z 20 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:52:59.669083Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-12-05T23:52:59.669099Z 0 [Note] Shutting down slave threads
and from the systemctl start [CODE=bash][root@first 2020-12-04]# systemctl status mysqld.service ? mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mysqld.service.d ??limits.conf Active: failed (Result: start-limit) since Sun 2020-12-06 01:34:50 CET; 6s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 15080 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=203/EXEC) Process: 15058 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 6962 (code=exited, status=0/SUCCESS) Dec 06 01:34:50 first.overronet.com systemd[1]: Failed to start MySQL Server. Dec 06 01:34:50 first.overronet.com systemd[1]: Unit mysqld.service entered failed state. Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service failed. Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 06 01:34:50 first.overronet.com systemd[1]: Stopped MySQL Server. Dec 06 01:34:50 first.overronet.com systemd[1]: start request repeated too quickly for mysqld.service Dec 06 01:34:50 first.overronet.com systemd[1]: Failed to start MySQL Server. Dec 06 01:34:50 first.overronet.com systemd[1]: Unit mysqld.service entered failed state. Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service failed.
and from the systemctl start [CODE=bash][root@first 2020-12-04]# systemctl status mysqld.service ? mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mysqld.service.d ??limits.conf Active: failed (Result: start-limit) since Sun 2020-12-06 01:34:50 CET; 6s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 15080 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=203/EXEC) Process: 15058 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 6962 (code=exited, status=0/SUCCESS) Dec 06 01:34:50 first.overronet.com systemd[1]: Failed to start MySQL Server. Dec 06 01:34:50 first.overronet.com systemd[1]: Unit mysqld.service entered failed state. Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service failed. Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service holdoff time over, scheduling restart. Dec 06 01:34:50 first.overronet.com systemd[1]: Stopped MySQL Server. Dec 06 01:34:50 first.overronet.com systemd[1]: start request repeated too quickly for mysqld.service Dec 06 01:34:50 first.overronet.com systemd[1]: Failed to start MySQL Server. Dec 06 01:34:50 first.overronet.com systemd[1]: Unit mysqld.service entered failed state. Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service failed.
Please sign in to leave a comment.
Comments
0 comments