Solaris Mysql Failure and Unable to Restart
- by Iscariot
Environment: Solaris 10
This mysql server has been up and running for 6 months now. Today all of a sudden it crashed. When typing 'mysql' as user it gives the error
MYSQL" Error 2002 (HY000): Can't Connect to Local MySQL server though socket '/tmp/mysql.sock'
when typing mysql as root it says mysql: not found.
The server try to open mysql, it stays open for 9-10 seconds and restarts the process. Below are the application logs.
Application-database-mysql_mysql-csk.log
[ May 30 22:37:52 Enabled. ]
[ May 30 22:37:58 Rereading configuration. ]
[ May 30 22:37:59 Executing start method ("/opt/coolstack/lib/svc/method/svc-cskmysql start") ] /opt/coolstack/mysql/bin/mysqld_safe --user=mysql --datadir=/dbpool1/data --pid-file=/dbpool1/data/database.soliaonline.com.pid
[ May 30 22:37:59 Method "start" exited with status 0 ]
[ May 30 22:38:13 Stopping because all processes in service exited. ]
[ May 30 22:38:13 Executing stop method ("/opt/coolstack/lib/svc/method/svc-cskmysql stop") ]
[ May 30 22:38:13 Method "stop" exited with status 0 ]
[ May 30 22:38:13 Executing start method ("/opt/coolstack/lib/svc/method/svc-cskmysql start") ]
/opt/coolstack/mysql/bin/mysqld_safe --user=mysql --datadir=/dbpool1/data --pid-file=/dbpool1/data/database.soliaonline.com.pid
[ May 30 22:38:13 Method "start" exited with status 0 ]
[ May 30 22:38:25 Stopping because all processes in service exited. ]
[ May 30 22:38:25 Executing stop method ("/opt/coolstack/lib/svc/method/svc-cskmysql stop") ]
[ May 30 22:38:25 Method "stop" exited with status 0 ]
I am hoping someone might have run into this before and might know how to fix it.