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.

Hard drive full?

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue

No, not even close.

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

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.

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

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue