Why this problem??
Can’t connect to MySQL localhost
ERROR 2002 (HY000): Can’t connect to local server through socket ‘/run/mysqld/mysqld.sock’ (2)
If it is only few times or constantly… If mysql upgrades it switches it self of during the preinstall command and start again after post install so it can taks up to 5 min…
Hi Eris, constantly in all my sities on this VPS… can you help me? Thanks
systemctl status mariadb
● mariadb.service - MariaDB 10.6.12 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Tue 2024-01-30 17:32:37 CET; 15min ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 1428783 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 1428789 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1428796 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] &>
Process: 1428906 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 1428906 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Jan 30 17:32:36 www.youtoonetwork.it systemd[1]: Starting MariaDB 10.6.12 database server...
Jan 30 17:32:37 www.youtoonetwork.it systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 30 17:32:37 www.youtoonetwork.it systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 30 17:32:37 www.youtoonetwork.it systemd[1]: Failed to start MariaDB 10.6.12 database server.
lines 1-18/18 (END)
Try restarting
systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code.
See “systemctl status mariadb.service” and “journalctl -xe” for details.
check the related logs, journalctl -xe is a good start.
● mariadb.service - MariaDB 10.6.12 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Tue 2024-01-30 17:32:37 CET; 15min ago
Docs: man:mariadbd(8)
systemd - MariaDB Knowledge Base
Process: 1428783 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 1428789 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1428796 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery; [ $? -eq 0 ] &>
Process: 1428906 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 1428906 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”
Jan 30 17:32:36 www.youtoonetwork.it systemd[1]: Starting MariaDB 10.6.12 database server…
Jan 30 17:32:37 www.youtoonetwork.it systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 30 17:32:37 www.youtoonetwork.it systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Jan 30 17:32:37 www.youtoonetwork.it systemd[1]: Failed to start MariaDB 10.6.12 database server.
lines 1-18/18 (END)
systemctl restart mariadb
grep -i mariadb /var/log/syslog | tail -n30
and if /var/log/mysql/error.log exists:
tail -n30 /var/log/mysql/error.log
grep -i mariadb /var/log/syslog | tail -n30
Jan 30 17:32:37 www systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 30 17:32:37 www systemd[1]: Failed to start MariaDB 10.6.12 database server.
Jan 30 17:55:30 www systemd[1]: Starting MariaDB 10.6.12 database server...
Jan 30 17:55:31 www systemd[1]: mariadb.service: Main process exited, code=exite d, status=1/FAILURE
Jan 30 17:55:31 www systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 30 17:55:31 www systemd[1]: Failed to start MariaDB 10.6.12 database server.
Jan 30 18:10:31 www systemd[1]: Starting MariaDB 10.6.12 database server...
Jan 30 18:10:32 www systemd[1]: mariadb.service: Main process exited, code=exite d, status=1/FAILURE
Jan 30 18:10:32 www systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 30 18:10:32 www systemd[1]: Failed to start MariaDB 10.6.12 database server.
Jan 30 18:12:05 www systemd[1]: Starting MariaDB 10.6.12 database server...
Jan 30 18:12:06 www systemd[1]: mariadb.service: Main process exited, code=exite d, status=1/FAILURE
Jan 30 18:12:06 www systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 30 18:12:06 www systemd[1]: Failed to start MariaDB 10.6.12 database server.
Jan 30 18:27:00 www systemd[1]: Starting MariaDB 10.6.12 database server...
Jan 30 18:27:01 www systemd[1]: mariadb.service: Main process exited, code=exite d, status=1/FAILURE
Jan 30 18:27:01 www systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 30 18:27:01 www systemd[1]: Failed to start MariaDB 10.6.12 database server.
Jan 30 18:31:32 www systemd[1]: Starting MariaDB 10.6.12 database server...
Jan 30 18:31:34 www systemd[1]: mariadb.service: Main process exited, code=exite d, status=1/FAILURE
Jan 30 18:31:34 www systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 30 18:31:34 www systemd[1]: Failed to start MariaDB 10.6.12 database server.
Jan 30 19:32:01 www systemd[1]: Starting MariaDB 10.6.12 database server...
Jan 30 19:32:03 www systemd[1]: mariadb.service: Main process exited, code=exite d, status=1/FAILURE
Jan 30 19:32:03 www systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 30 19:32:03 www systemd[1]: Failed to start MariaDB 10.6.12 database server.
Jan 30 20:09:54 www systemd[1]: Starting MariaDB 10.6.12 database server...
Jan 30 20:09:55 www systemd[1]: mariadb.service: Main process exited, code=exite
2024-01-30 20:09:55 0 [Note] InnoDB: Starting final batch to recover 1488 pages from redo log.
2024-01-30 20:09:55 0 [ERROR] InnoDB: Unable to apply log to corrupted page [pag e id: space=1372, page number=3]; set innodb_force_recovery to ignore
2024-01-30 20:09:55 0 [ERROR] InnoDB: Plugin initialization aborted with error D ata structure corruption
2024-01-30 20:09:55 0 [Note] InnoDB: Starting shutdown...
2024-01-30 20:09:55 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-01-30 20:09:55 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE f ailed.
2024-01-30 20:09:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-30 20:09:55 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-30 20:09:55 0 [ERROR] Aborting
That’s the real error and seems your db is corrupted. I’ve no experience regarding this error so I won’t guide you but seems you should backup all the db files, add directive innodb_force_recovery = 1 to section [mysqld] in /etc/mysql/my.cnf and start mariadb, it should start in read only mode and you could dump your databases, then you could stop mariadb, remove the directive added and start it again and maybe it would be fixed (in this mode you could also try mysqlcheck tool to see whether it helps)… , if it doesn’t work, you should stop mariadb, remove all data, start it and recover the dbs from the previous dump.
As I said, I’ve no idea so maybe others can guide you or you can use your favorite search engine to find the right steps to fix the issue.
Good luck.
waw really good luck! However, I want to thank you for your help. I will try to do as you say and I will let you know tomorrow. A thousand thanks
1 Like
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.