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.

Every day at 4.03am MySQL restarts

Discussion in 'General Discussion' started by BahBah, Feb 13, 2008.

  1. BahBah

    BahBah Active Member

    Joined:
    Sep 25, 2003
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    Everyday at 4:03am MySQL restarts. I have looked in the err log in /var/lib/mysql and this is what appears to be happening.

    I have no cron scripts that I have made that restart MySQL, so figured it must be cpanel.

    Any ideas what is causing this ? and how to stop it please.

    Thanks



    080212 5:04:31 [Note] /usr/sbin/mysqld: Normal shutdown

    080212 5:04:31 [Note] /usr/sbin/mysqld: Shutdown complete

    080212 05:04:31 mysqld ended

    080212 05:04:33 mysqld started
    080212 5:04:33 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.0.27-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
    080213 5:04:09 [Note] /usr/sbin/mysqld: Normal shutdown

    080213 5:04:09 [Note] /usr/sbin/mysqld: Shutdown complete

    080213 05:04:09 mysqld ended

    080213 05:04:11 mysqld started
    080213 5:04:11 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.0.27-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
     
  2. BahBah

    BahBah Active Member

    Joined:
    Sep 25, 2003
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6
    Anyone ? :confused:
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    What do your other system logs show happening at that time?
     
  4. BahBah

    BahBah Active Member

    Joined:
    Sep 25, 2003
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6
    Hi Kenneth,

    The following occurs around this time in cron:

    Feb 21 04:00:01 www1 crond[19372]: (root) CMD (/usr/local/sbin/lsm -c >> /dev/null 2>&1)
    Feb 21 04:00:01 www1 crond[19373]: (root) CMD (/usr/lib/sa/sa1 1 1)
    Feb 21 04:00:01 www1 crond[19382]: (root) CMD (/usr/local/cpanel/bin/dcpumon >/dev/null 2>&1)
    Feb 21 04:00:01 www1 crond[19383]: (root) CMD (/usr/local/cpanel/whostmgr/bin/dnsqueue > /dev/null 2>&1)
    Feb 21 04:00:01 www1 crond[19384]: (root) CMD (/usr/bin/rdate -s rdate.cpanel.net && /sbin/hwclock --systohc)
    Feb 21 04:00:01 www1 crond[19386]: (root) CMD (/usr/local/nobody_check/nobody_check >/dev/null 2>&1)
    Feb 21 04:01:01 www1 crond[20480]: (root) CMD (run-parts /etc/cron.hourly)
    Feb 21 04:02:01 www1 crond[20496]: (root) CMD (run-parts /etc/cron.daily)
    Feb 21 04:02:01 www1 crond[20497]: (root) CMD (/usr/local/bandmin/bandmin)
    Feb 21 04:02:05 www1 anacron[20936]: Updated timestamp for job `cron.daily' to 2008-02-21
    Feb 21 04:05:01 www1 crond[23274]: (root) CMD (/usr/local/cpanel/bin/dcpumon >/dev/null 2>&1)


    There is nothing showing in /var/log/messages is there any where else I should be looking ?

    Thanks
     
    #4 BahBah, Feb 21, 2008
    Last edited: Feb 21, 2008
  5. Nefedov

    Nefedov Member

    Joined:
    Oct 10, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    cron.daily
    logrotate restart mysql for hup logfile?
     
Loading...

Share This Page