mysql constantly restarting

cirrusrex

Registered
Aug 12, 2001
3
0
301
I've been getting a lot of messages from the service monitor manager to the tune of:

mysql failed @ Tue Jun 17 22:30:30 2003. A restart was attempted automagicly.


this happens every ten minutes or so, however there are not any messages in the mysql error log other than:

030617 22:39:12 InnoDB: Starting shutdown...
030617 22:39:12 InnoDB: Shutdown completed
030617 22:39:12 /usr/sbin/mysqld: Shutdown Complete

030617 22:39:12 mysqld ended
030617 22:39:12 mysqld ended


030617 22:39:13 mysqld started
030617 22:39:13 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.13' socket: '/var/lib/mysql/mysql.sock' port: 3306


Could this possibly be a problem with the service monitor? Or can anyone suggest some ways for me to track down the problem? When mysql isn't being restarted, i.e. its running, it doesn't seem to have any problems.

Thanks,
-matt

cPanel.net Support Ticket Number:

cPanel.net Support Ticket Number:
 

ciphervendor

Well-Known Member
Aug 26, 2002
1,050
0
166
Try restarting chksrv.

cPanel.net Support Ticket Number:
 

cirrusrex

Registered
Aug 12, 2001
3
0
301
I restarted chksrvd but that didn't seem to change anything. I really don't know where to go at this point.

-matt

cPanel.net Support Ticket Number:

cPanel.net Support Ticket Number:
 

isputra

Well-Known Member
May 3, 2003
574
0
166
Mbelitar
same with me here ... I've been getting a lot of messages from the service monitor about mysql failed information.

how to fix that ????:confused:

cPanel.net Support Ticket Number:
 

sierra_k

Member
Jul 29, 2003
6
0
151
I dont know if this will help you guys or not. I had this problem after I updated WHM and it drove me crazy but heres how I fixed it.

In MySQL 4 it changes the mysql start command from
'mysqld_safe' to 'safe_mysqld' , so chkservd is looking for the old mysqld_safe, doesnt see it and restarts. my problem is because of a software conflict from my hosting company (something about swsoft) it wont update chkservd when i run sysup. I get the following error.

file /etc/chkserv.d/mysql from install of chkservd-6.1-0 conflicts with file from package cpanel5-rh73-1.0-1.swsoft

So I had to manually change the file.

I pico'd

/etc/checksrv.d/mysql

and replaced the

service[mysql]=x,x,x,/scripts/restartsrv mysql,safe_mysqld,mysql

with the reverse .... mysqld_safe

service[mysql]=x,x,x,/scripts/restartsrv mysql,mysqld_safe,mysql

This worked! Its not showing failed anymore. It is just a
temporary fix until I can update chkservd. But atleast it wont restart on you constantly.

sierra_k

cPanel.net Support Ticket Number:
 

VexT

Active Member
Nov 15, 2003
34
0
156
Thank you thank you

This was quite the pain. Thnx for posting this, sierra_k
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
41
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
The path for those files has not changed (/etc/chkserv.d/ contains the chkservd.conf file and the mysql file), but this thread is from 2003 and not overly applicable for most folks. What is your exact issue?