MySQL stopped running, can't restart

Hi all,

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

Is your disk full? "df -h" will check. MySQL seems to be the first thing that fails when that happens.

@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.

Old and busted: Apache MaxClients

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…

Partitions. Saving your server from logswell crash since 1991*.

*) or whatever

I was young and stupid back then.

Now I'm not so young. Still stupid, probably. ;)

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct