About every 10 days Apache needs to be restarted
A couple of months ago there were specific error messages, but lately there's no indication as to what happened, at least not where I'm looking…
Also, I took some screenshots-- can I upload images on this forum? I see the Img button but I guess I don't understand how that works.
8 Replies
code here
You should start by taking look at Apache's error log during the time it goes offline - typically it's under /var/log/apache2/error.log on Debian/Ubuntu, and /var/log/httpd/error.log on CentOS, though it depends on how you have things configured - it should be spelled out in the vhost config.
[Tue Apr 10 23:21:43.361104 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/prinstantly/public_html/public/revive/lib/OA/Dal/Delivery/mysql.php:53, referer: https://www.prinstantly.com/artist/kevin-wickersham
[Tue Apr 10 23:21:43.361174 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: Stack trace:, referer: https://www.prinstantly.com/artist/kevin-wickersham
[Tue Apr 10 23:21:43.361179 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: #0 /home/prinstantly/public_html/public/revive/lib/OA/Dal/Delivery/mysql.php(83): OA_Dal_Delivery_connect('database'), referer: https://www.prinstantly.com/artist/kevin-wickersham
[Tue Apr 10 23:21:43.361182 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] modfcgid: stderr: #1 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(722): OADalDelivery_query('\n SELECT…'), referer:
[Tue Apr 10 23:21:43.361186 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] modfcgid: stderr: #2 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(2964): OADalDelivery_getZoneInfo(1), referer:
[Tue Apr 10 23:21:43.361190 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] modfcgid: stderr: #3 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(3807): MAX_cacheGetZoneInfo(1), referer:
[Tue Apr 10 23:21:43.361193 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] modfcgid: stderr: #4 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(3653): _adSelectZone(1, Array, '', true), referer:
[Tue Apr 10 23:21:43.361197 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] modfcgid: stderr: #5 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(4318): MAX_adSelect('zone:1', '', '', '', 0, 'UTF-8', Array, true, '', '
[Tue Apr 10 23:21:43.361200 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: #6 {main}, referer:
[Tue Apr 10 23:21:43.361204 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] modfcgid: stderr: thrown in /home/prinstantly/publichtml/public/revive/lib/OA/Dal/Delivery/mysql.php on line 53, referer:
[Wed Apr 11 00:02:19.319197 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] modfcgid: stderr: PHP Fatal error: Uncaught Error: Call to undefined function mysqlconnect() in /home/prinstantly/public_html/public/revive/lib/OA/Dal/Delivery/mysql.php:53, referer:
[Wed Apr 11 00:02:19.319271 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] mod_fcgid: stderr: Stack trace:, referer:
[Wed Apr 11 00:02:19.319275 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] modfcgid: stderr: #0 /home/prinstantly/publichtml/public/revive/lib/OA/Dal/Delivery/mysql.php(83): OADalDelivery_connect('database'), referer:
[Wed Apr 11 00:02:19.319277 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] modfcgid: stderr: #1 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(722): OADalDelivery_query('\n SELECT…'), referer:
[Wed Apr 11 00:02:19.319292 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] modfcgid: stderr: #2 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(2964): OADalDelivery_getZoneInfo(1), referer:
[Wed Apr 11 00:02:19.319295 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] modfcgid: stderr: #3 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(3807): MAX_cacheGetZoneInfo(1), referer:
[Wed Apr 11 00:02:19.319297 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] modfcgid: stderr: #4 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(3653): _adSelectZone(1, Array, '', true), referer:
[Wed Apr 11 00:02:19.319299 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] modfcgid: stderr: #5 /home/prinstantly/publichtml/public/revive/www/delivery/asyncspc.php(4318): MAX_adSelect('zone:1', '', '', '', 0, 'UTF-8', Array, true, '', '
[Wed Apr 11 00:02:19.319301 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] mod_fcgid: stderr: #6 {main}, referer:
[Wed Apr 11 00:02:19.319303 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] modfcgid: stderr: thrown in /home/prinstantly/publichtml/public/revive/lib/OA/Dal/Delivery/mysql.php on line 53, referer:
16:30 is about the time I restarted Apache.
[Sat Apr 21 22:53:38.611513 2018] [cgi:error] [pid 31585:tid 140551613519616] [client 117.14.153.59:62079] AH02811: script not found or unable to stat: /home/prinstantly/cgi-bin/user
Please make sure that your Apache and PHP-FPM configuration is not set to allow the child processes to run infinitely. Memory leaks in PHP code that accumulate over time can and will cause Apache or FPM to fail.
[Mon May 14 06:25:10.285290 2018] [mpm_event:notice] [pid 3633:tid 140094204712832] AH00493: SIGUSR1 received. Doing graceful restart
[Mon May 14 06:25:11.132219 2018] [core:notice] [pid 3633] AH00060: seg fault or similar nasty error detected in the parent process
Any help appreciated.
(For some reason clicking on Apache Error Log in the left-hand column does not reveal the latest up-to-date log, even after refreshing. To see that, I have to go to System Logs then click View next to Apache error log.)