Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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 fails and recovers every morning

Discussion in 'Database Discussions' started by CK2017, Jul 28, 2017.

  1. CK2017

    CK2017 Registered

    Joined:
    Jul 28, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Australia
    cPanel Access Level:
    Root Administrator
    Hi everyone,

    longtime listener, first time caller.

    • CLOUDLINUX 6.9 x86_64 xen pv
    • cPanel & WHM 64.0 (build 36)
    A few months back mySQL began failing and then recovering at approximately the same time every morning (3.50am - 4.00am).

    The alert email shows multiple lines of:
    /usr/sbin/mysqld: Out of memory (Needed 3789200 bytes)
    and then:
    /usr/sbin/mysqld: Normal shutdown
    /usr/sbin/mysqld: Shutdown complete

    Memory Information
    Used 5.84 GB
    Available 4.48 GB
    Installed 10.32 GB

    Load Information
    0.62 1.49 2.17


    After Googling I checked the Daily Cron jobs and there is a /usr/local/cpanel/scripts/upcp --cron
    which today for example started at 3.53am and completed at 4.19am.
    After a call to the server provider,

    Due to the time of day this has been occurring it hasn't been a huge problem. But of late some clients have begun using up-time monitoring services via their seo agents, who then hand out torches and pitchforks.
    I have searched the logs I can find but cannot see any correlation between events/errors at this time. (aside from the timing of the upcp --cron job)
    Suggestions would be greatly appreciated.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you open a support ticket using the link in my signature so we can take a closer look at an affected system?

    Thank you.
     
Loading...

Share This Page