MYSQL keeps breaking down after restore.

Hello all:

This is probably the strangest of all issues I have ever seen:

My MYSQL database on my node keeps breaking down for apparently no reason. It begun about a week ago. I went to check my site and got a:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

Now, I have an Aegir (Drupal) system that has been running for a year without issues and that requires for the bind setting in the my.cnf to be disabled.

Well, I restore it using reinstalling MYSQL using:

dpkg -l | awk '{print $2}' | grep mysql > installed_packages.txt

apt-get remove cat installed_packages.txt

apt-get install cat installed_packages.txt

and it was all fine. Aegir was back up and all looked fine.

24 hours later, the MYSQL server is down again.

I am at a lost as of why this is suddenly happening, specially why it all seems fine and then breaks down again.

Anyone with any tips or suggestions or hints as why this maybe happening?

Thanks.

7 Replies

JUst did it again. Site is down, MYSQL is down.

@waldo:

Check your logs.

exactly. what's in the mysql log

obs was right…..Hard drive space…I was accidentally looking at the wrong node.

Thanks for the help people.

@kannary100:

obs was right…..Hard drive space…I was accidentally looking at the wrong node.

Thanks for the help people.

Oh that's a sign I need to get out more. Either that or a lucky guess.

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