MySQL failing
MySQL goes down once in a while. How can I determine the cause of this? I am unsure if there are logs, etc.
|
Look in /var/log/messages
What errors are you getting? |
/var/log/messages probably will tell you nothing. Check the mysql logs in /var/lib/mysql usually named after the hostname and ends with .err
|
The latest .err file is from March. I had at least 2 times MySQL went down this month.
|
Kindly paste the contents of the above mentioned logs.
|
Sure thing.
Dated 2008-03-09 Quote:
|
Do you happen to have a /var/log/mysql.log? Sometimes that's a common place for mysql logs as well. And how was MySQL installed on this machine, what distro?
|
Hi,
from the above log you have pasted....it seems that you have two instance of mysql installed on your machine. Please check the same. When you connect to mysql server if from your local machine you are connecting (machine where server is installed)then it creates a linux domain socket to connect to server. So, if one instance is already using the socket to connect to server then the other instance will fail to connect. The sample log entry proves that... ----------------- 071230 14:24:50 mysqld ended 080309 13:42:18 mysqld started 080309 13:42:20 [ERROR] Can't start server : Bind on unix socket: Permission denied 080309 13:42:20 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ? 080309 13:42:20 [ERROR] Aborting ---------------------- PLease provide the path where mysql is installed? Thanks, sir_com |
Actually its saying that he has one copy of the MySQL SERVER running and is trying to start another on the same machine. The client has nothing to do with it.
|
Also if you read his reply, those logs he posted are from two months ago. The OP has stated that the MySQL server has crashed twice since the last log he's posted.
|
Quote:
|
All times are GMT -5. The time now is 01:10 AM. |