Daily Crash

[techie_andy]

Hi all,

I have a cPanel instance that seems to randomly crash and not re-start when the stats collection is performed on the 2 hour schedule.
I've not been able to figure out the exact cause however when it crashes the apache error_log indicates:

[Tue Jan 07 09:05:23 2014] [notice] Graceful restart requested, doing restart
[Tue Jan 07 09:05:23 2014] [notice] Digest: generating secret for digest authentication ...
[Tue Jan 07 09:05:23 2014] [notice] Digest: done
[Tue Jan 07 09:05:23 2014] [notice] Apache/2.2.25 (Unix) mod_ssl/2.2.25 OpenSSL/1.0.0-fips mod_bwlimited/1.4 configured -- resuming normal operations
DBI connect('database=leechprotect:host=localhost','leechprotect',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/bin/leechprotect line 236
[Tue Jan 07 09:05:24 2014] [warn] long lost child came home! (pid 8856)
[Tue Jan 07 11:02:09 2014] [notice] Graceful restart requested, doing restart
[Tue Jan 07 11:02:09 2014] [notice] Digest: generating secret for digest authentication ...
[Tue Jan 07 11:02:09 2014] [notice] Digest: done
[Tue Jan 07 11:02:09 2014] [notice] Apache/2.2.25 (Unix) mod_ssl/2.2.25 OpenSSL/1.0.0-fips mod_bwlimited/1.4 configured -- resuming normal operations
DBI connect('database=leechprotect:host=localhost','leechprotect',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/bin/leechprotect line 236
[Tue Jan 07 11:02:10 2014] [warn] long lost child came home! (pid 10080)

As you can see exactly at the 2 hour interval the graceful restart happens then it crashes.
To work around the issue for now I've enabled piped logging so that the restarts don't happen but I was wondering if anyone could perhaps advise why this seems to be happening?

I've tried endless searching but still no solid answers.

 

[cPanelMichael]

Hello

Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[phillbooth]

I think your DB is corrupt try running these...

myisamchk --silent --force --fast --update-state /var/lib/mysql/*/*.MYI

myisamchk --sort-recover --update-state --extend-check /var/lib/mysql/*/*.MYI

myisamchk -ovf --silent /var/lib/mysql/*/*.MYI;