My SQL error with Plesk

[rornelas]

I have been getting this message on my server hosted at ServePath. It has been 1 full day and they can not find the answer, Can someone please assist?

ERROR: PleskFatalException
Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

0: /usr/local/psa/admin/plib/common_func.php3:153
psaerror(string 'Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)')
1: /usr/local/psa/admin/auto_prepend/auth.php3:90

 

[Dmitry Frantsev]

Make sure that Mysql is running on this server. From the error I can see that it's not. Did you get this error right after login page to Plesk or where?

 

[rornelas]

Here is what the tech discovered and after a simple reboot the server is now back online. Unfortunately it took them 2 days to figure that out.

-----------
We tried reinstalling mysql and also checked the InnoDB settings. Still mysql service went on crashing . The issue seems to arise due to soem problem with memory .

[root@host test]# free -m
total used free shared buffers cached
Mem: 2024 1998 26 0 3 37
-/+ buffers/cache: 1958 66
Swap: 980 980 0
[root@host test]#

The memory status always show free swap as zero. We checked the same by stopping all the services in the server, still there was no change for the value for
free swap from zero. Once we start all the services the server will run out of memory ,as a result all the running process will be stopped.

According to the current configuration the server have 2GB of RAM and 1 GB of swap. But the memory usage does not seem to be proper . So we would suggest to perform a reboot and see whether it brings about any changes.

If the issue persist even after the reboot we will have to perform a memory check. Please let us know if we can proceed as mentioned above

top - 01:04:41 up 12 days, 11:19, 3 users, load average: 0.10, 0.35, 1.60
Tasks: 557 total, 1 running, 556 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.3% us, 0.7% sy, 0.0% ni, 99.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 2073212k total, 2046784k used, 26428k free, 3100k buffers
Swap: 1004052k total, 1004052k used, 0k free, 37708k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1630 root 17 0 2844 1240 760 R 1.0 0.1 0:00.15 top
1 root 16 0 2324 260 180 S 0.0 0.0 9:17.49 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.34 ksoftirqd/0