PleskFatalException: Unable to connect to database: mysql_connect(): No such file or directory (auth

[maniot]

Hello,
After an attempt to upgrade plesk from 11.5 to 12.5 which failed with an error that there wasn't enough diskspace i ended up with the error: PleskFatalException: Unable to connect to database: mysql_connect(): No such file or directory (auth.php:149). I looked into /var/lib/mysql for the file mysql.sock which i can't find.
I tried to restore a back-up from a day earlier via virtuozzo but that doesn't work.
I also tried to restart mysqld, i have to do this several times to stop it.
i attached my Mysqld.log with the errors.
How would i go about to get it running again?
Thanks in advance for your answers

 

[IgorG]

It looks like that mysql tables are corrupted. Try to repair it with help of this KB article - https://kb.plesk.com/en/119650
I hope it will help.

 

[maniot]

Hello Igor,
Thanks for your fast response.
Unfortunately, it doesn't work.
I'm getting the error: ERROR 2002 (HY000): Can't connect to local Mysql.......
I noticed that Mysql.sock isn't created.
I tried to restart the service mysqld, that doesn't change anything. If i stop the service and ask the status it tells me that it is running, even after stopping the service several times, the status is still: running But everytime i ask the status with other pid's.
I've attached a printscreen of my ssh terminal.

regards,
Nicolas

 

[IgorG]

The issue might be caused by hung tasks. Check if hung tasks, run

# ps -auf

and check mysql related tasks. Kill hung task (run kill <PID>) and restart psa service

# /etc/init.d/psa restart

 

[maniot]

Nope, doesn't work neither. killing tasks doesn't work (no such process)

I also noticed that there a lot of lines in the secure logs recently, could it be that the problems are caused by a hack? and if so what could i do about it?