MySQL stopped running, can't restart
My Linode has been running perfect for well over a year, then last night I noticed my MySQL server (on the same Linode) stopped running.
It's a Ubuntu 10.10 image with nginx & mysql.
I made no changes so have no idea why this happened.
using:
/etc/init.d/mysql restart
results in:
> Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the restart(8) utility, e.g. restart mysql
start: Job failed to start
so, I tried:
> mysql -u root -p *
and I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
any ideas what I need to do to get this fixed?
6 Replies
@hoopycat:
Is your disk full? "df -h" will check. MySQL seems to be the first thing that fails when that happens.
Thank you so much, that was indeed it.
Tried everything else, was pulling my hair out, never thought to check if disk was full.
Working again now.
New hotness: MySQL no-space-left-on-device handling
Going for the exacta here: is logrotate installed and working?
@hoopycat:
Going for the exacta here: is logrotate installed and working?
When it happened to me years ago, logrotate wouldn't help. It was a log growing up, indeed, but it did grow up these 10-or-so GB in about a hour.;)
Yay for a few E_NOTICEs per request * tens of thousands of requests…