Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Tue Apr 10, 2018 8:57 pm 
Offline
Senior Newbie

Joined: Mon Apr 02, 2018 8:46 pm
Posts: 6
Location: Boston, MA, USA
About every 10 days I'll go to visit my website and it will be down. I then log into Linode and on the dashboard see that Apache needs to be restarted, after which everything is fine. What's the best way to figure out why this is happening?

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.


Top
   
PostPosted: Tue Apr 10, 2018 9:50 pm 
Offline
Junior Member

Joined: Fri Sep 15, 2017 5:04 pm
Posts: 29
Instead of screenshots, just grab relevant error messages, etc and wrap them in code blocks like this:

[code] code here [/code]

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.


Top
   
PostPosted: Tue Apr 10, 2018 10:08 pm 
Offline
Senior Newbie

Joined: Mon Apr 02, 2018 8:46 pm
Posts: 6
Location: Boston, MA, USA
Thanks. I noticed the site was down today around 2:30 pm (NY time). The apache error log shows this, which only seems to reference the Revive ad server and one particular artist page: (Even adjusting for time zone this seems to have happened much later than the site being down.)
Code:
[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] mod_fcgid: stderr: #1 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(722): OA_Dal_Delivery_query('\\n SELECT...'), referer: https://www.prinstantly.com/artist/kevin-wickersham
[Tue Apr 10 23:21:43.361186 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: #2 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(2964): OA_Dal_Delivery_getZoneInfo(1), referer: https://www.prinstantly.com/artist/kevin-wickersham
[Tue Apr 10 23:21:43.361190 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: #3 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(3807): MAX_cacheGetZoneInfo(1), referer: https://www.prinstantly.com/artist/kevin-wickersham
[Tue Apr 10 23:21:43.361193 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: #4 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(3653): _adSelectZone(1, Array, '', true), referer: https://www.prinstantly.com/artist/kevin-wickersham
[Tue Apr 10 23:21:43.361197 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: #5 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(4318): MAX_adSelect('zone:1', '', '', '', 0, 'UTF-8', Array, true, '', 'https://www.pri...', NULL), referer: https://www.prinstantly.com/artist/kevin-wickersham
[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: https://www.prinstantly.com/artist/kevin-wickersham
[Tue Apr 10 23:21:43.361204 2018] [fcgid:warn] [pid 7968:tid 140333803357952] [client 66.249.69.143:57557] mod_fcgid: stderr: thrown in /home/prinstantly/public_html/public/revive/lib/OA/Dal/Delivery/mysql.php on line 53, referer: https://www.prinstantly.com/artist/kevin-wickersham
[Wed Apr 11 00:02:19.319197 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] 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/
[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: https://www.prinstantly.com/
[Wed Apr 11 00:02:19.319275 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] 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/
[Wed Apr 11 00:02:19.319277 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] mod_fcgid: stderr: #1 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(722): OA_Dal_Delivery_query('\\n SELECT...'), referer: https://www.prinstantly.com/
[Wed Apr 11 00:02:19.319292 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] mod_fcgid: stderr: #2 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(2964): OA_Dal_Delivery_getZoneInfo(1), referer: https://www.prinstantly.com/
[Wed Apr 11 00:02:19.319295 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] mod_fcgid: stderr: #3 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(3807): MAX_cacheGetZoneInfo(1), referer: https://www.prinstantly.com/
[Wed Apr 11 00:02:19.319297 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] mod_fcgid: stderr: #4 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(3653): _adSelectZone(1, Array, '', true), referer: https://www.prinstantly.com/
[Wed Apr 11 00:02:19.319299 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] mod_fcgid: stderr: #5 /home/prinstantly/public_html/public/revive/www/delivery/asyncspc.php(4318): MAX_adSelect('zone:1', '', '', '', 0, 'UTF-8', Array, true, '', 'https://www.pri...', NULL), referer: https://www.prinstantly.com/
[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: https://www.prinstantly.com/
[Wed Apr 11 00:02:19.319303 2018] [fcgid:warn] [pid 7968:tid 140333769787136] [client 66.249.69.143:51376] mod_fcgid: stderr: thrown in /home/prinstantly/public_html/public/revive/lib/OA/Dal/Delivery/mysql.php on line 53, referer: https://www.prinstantly.com/


Top
   
PostPosted: Wed Apr 11, 2018 10:07 am 
Offline
Senior Newbie

Joined: Mon Apr 02, 2018 8:46 pm
Posts: 6
Location: Boston, MA, USA
Here are the graphs and the plan details:

https://ibb.co/fuAxmc

https://ibb.co/hnuJsH

16:30 is about the time I restarted Apache.


Top
   
PostPosted: Sun Apr 22, 2018 9:07 am 
Offline
Senior Newbie

Joined: Mon Apr 02, 2018 8:46 pm
Posts: 6
Location: Boston, MA, USA
It happened again. Here's the last line of the error log:

[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


Top
   
PostPosted: Wed May 02, 2018 3:57 am 
Offline
Senior Member

Joined: Thu Nov 16, 2017 6:59 am
Posts: 137
None of this is indicating anything that would tell us what the problem is that's causing Apache to fail (beside you obviously missing the legacy PHP extension in your setup).

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.

_________________
- emestee,
Lord System Administrator


Top
   
PostPosted: Wed May 02, 2018 8:32 am 
Offline
Senior Newbie

Joined: Mon Apr 02, 2018 8:46 pm
Posts: 6
Location: Boston, MA, USA
I'll hire someone to look into those things. Thanks


Top
   
PostPosted: Mon May 14, 2018 3:08 am 
Offline
Senior Newbie

Joined: Mon Apr 02, 2018 8:46 pm
Posts: 6
Location: Boston, MA, USA
Apache stopped again. Pasting the last 2 lines of the error log in case this narrows anything down:
Code:
[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.)


Top
   
PostPosted: Thu May 17, 2018 9:22 am 
Offline
Senior Member

Joined: Thu Nov 16, 2017 6:59 am
Posts: 137
It crashes.

_________________
- emestee,
Lord System Administrator


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
RSS

Powered by phpBB® Forum Software © phpBB Group