Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Sep 2003
    Posts
    33

    Default Every day at 4.03am MySQL restarts

    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. #2
    Member
    Join Date
    Sep 2003
    Posts
    33

    Lightbulb

    Anyone ?

  3. #3
    cPanel Development cpanelkenneth's Avatar
    Join Date
    Apr 2006
    Posts
    3,788
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    What do your other system logs show happening at that time?

  4. #4
    Member
    Join Date
    Sep 2003
    Posts
    33

    Default

    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
    Last edited by BahBah; 02-21-2008 at 10:51 AM.

  5. #5
    Member
    Join Date
    Oct 2007
    Posts
    10

    Default

    cron.daily
    logrotate restart mysql for hup logfile?

Similar Threads & Tags
Similar threads

  1. mySQL restarts automatically, every 2sec. error db
    By Icode in forum Database Discussions
    Replies: 3
    Last Post: 02-15-2011, 06:12 PM
  2. MySQL restarting automagically more than 100 times a day
    By xisto in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 05-26-2009, 05:28 AM
  3. mysql shows fail, yet restarts ok?
    By Secret Agent in forum cPanel and WHM Discussions
    Replies: 16
    Last Post: 02-24-2008, 10:44 PM
  4. MySQL restarts every few seconds
    By 1EightT in forum cPanel and WHM Discussions
    Replies: 7
    Last Post: 01-28-2007, 03:18 PM
  5. Apache restarts every 5 minutes for the first hour each day
    By dkz in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 04-05-2005, 11:07 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube