Server ran out of disk, triggering a SQL crash. Made space, SQL didn’t recover.
/var/lib/mysql/mysql.sock doesn’t exist to mv or rm (historically, mv or rm with service stops and restarts fixed things).
Been experiencing this on a couple servers with updated modules now. Anyone else been experiencing this?
It’s been doing that for the past 25 years. Run the DB out of space, DB gods become angry.
There’s a “fwconsole database repairall” commnd that you can try, but if the DB isn’t restarting, it might not be enough. Remove the /var/lib/mysql/mysql.sock file from the system and try again. You may also need to make sure that the /var/lib/mysql directory is intact.
The downside with fwconsole commands is that it requires the very SQL connection that’s broken.
In this case, the removal of /var/lib/mysql/mysql.sock doesn’t resolve the issue. For older systems, that solution worked great.
I suppose not running out of disk is a solution haha
Install logwatch and stay informed as to disk space
add a crontab
20 16 * * * if [ $(df /|tail -1|awk '{print $5}'|tr -d '%') -ge 90 ];then df /;fi
will email your MAILTO if the disk getsabove 90% full
You’re going to have to deep-dive into the MySQL world to get back to where you need to be. A lot depends on what the error actually is, which you’re going to get from the /var/log/mysql/*err file. After looking at that, see if you can get it back from that error.