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!

MySQL fails and recovers every morning

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

  1. CK2017

    CK2017 Registered

    Jul 28, 2017
    Likes Received:
    Trophy Points:
    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 Technical Support Community Manager Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator

    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.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice