techie_andy

Registered
Jan 9, 2014
1
0
1
cPanel Access Level
Root Administrator
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:

Code:
[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

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
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

Active Member
Sep 9, 2013
41
4
8
cPanel Access Level
Root Administrator
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;