mysql stopped working after no free space on file system [corruption]
2
votes
0
answers
383
views
I am experiencing the following error when launching MySQL.
>can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket '/var/run/mysql/mysql.sock' exists!`
Basically, I have noticed that there is no free space on the partition where MySQL is installed. I freed some space and rebooted, but same error.
I have also tried other solutions I've found on Google, such as: safe mode, restarting services, changing ip address. But none of these have worked.
By the way, the file
/var/run/mysql/mysql.sock
is not present.
P.S. I am using MariaDB
[EDIT]
From the logs it looks like the DB got corrupted:
[ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace .... you may have to recover from a backup
Asked by zerunio
(21 rep)
Mar 10, 2022, 03:38 PM
Last activity: Mar 10, 2022, 04:46 PM
Last activity: Mar 10, 2022, 04:46 PM