The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql constantly restarting

Discussion in 'General Discussion' started by cirrusrex, Jun 17, 2003.

  1. cirrusrex

    cirrusrex Registered

    Joined:
    Aug 12, 2001
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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:
     
  2. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    Try restarting chksrv.

    cPanel.net Support Ticket Number:
     
  3. cirrusrex

    cirrusrex Registered

    Joined:
    Aug 12, 2001
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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:
     
  4. isputra

    isputra Well-Known Member

    Joined:
    May 3, 2003
    Messages:
    576
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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:
     
  5. sierra_k

    sierra_k Member

    Joined:
    Jul 29, 2003
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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:
     
  6. VexT

    VexT Active Member

    Joined:
    Nov 15, 2003
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Thank you thank you

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

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
    WHat is the equivalent of "/etc/checksrv.d/" in recent versions of cpanel?
     
  8. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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?
     
Loading...

Share This Page