500 Internal Server Error

[szpaks]

Hello,

 

I set up store with large database which includes 200 000 items. From time to time my store stop working and it is appear following error

 

Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

I have written to techincal support of my hosting and they gave me the following answer:

 

Hello,

 

Our server installed with the monitoring tool which prevents users from over using server resources. And your account seems to be consuming more than the allowed limit.

 

---------

Thu Oct 25 09:56:23 2007: '/usr/bin/php product_reviews.php ' (Exe: php [/usr/bin/php], Script: '/home/zarekman/public_html/product_reviews.php', Domain: www.zarekmanuals.com, Request: '/core2-pr-86418.html?osCsid=cbfcfc58d5f04cd4a36ef6e3055d12db&language=de', Accessed from: 66.249.72.11) - of zarekman has used 40.4 %CPU

 

Could you please verify this from your end.

 

What should I do with this kind of problem, should I modify some scripts of oscommerce, or should I change server to another one.

 

Thank you for your advices.

Best regards,

Peter

[Gauravs]

Do you have vanilla install of OSC or have applied contributions.

Any page using 40% of CPU certainly will cause issue on all servers, but I am not convinced by one off occurence to be responsible for this issue.

 

At this moment, your site gives same error and home page DOES NOT take even 5% of CPU, provided of course that the code correct, and not having problems that could spike server usage.

 

To change host, you would have to first identify the root cause, else I am afraid, you would run into similar problems soon.

 

For the moment, I would advise first to have index.html page and let users know that your site is under maintenance, and see if you have the detailed statistics available to you, instead of just one occurence that your ISP has shown for Oct 25th.

 

HTH

[szpaks]

Your advices are precious for me. I used several contributions, it is Easy Populate & Products Attributes to import products to my databse and Ultimate SEO URLs as well as sid killer.

 

With regards to detailed statistics I entered into error log through cpanel and it is what I found there:

 

Error Log

Last 300 Error Log Messages in reverse order:

 

[Thu Nov 8 16:03:29 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 16:02:53 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 16:02:12 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/product_info.php

[Thu Nov 8 16:01:41 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 16:01:26 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 16:01:05 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 16:01:00 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:59:33 2007] [error] [client 24.163.57.208] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:59:17 2007] [error] [client 24.163.57.208] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:59:07 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:59:07 2007] [error] [client 24.163.57.208] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:58:52 2007] [error] [client 24.163.57.208] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:58:46 2007] [error] [client 24.163.57.208] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:58:36 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/product_reviews_write.php

[Thu Nov 8 15:58:26 2007] [error] [client 91.163.8.133] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:58:05 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:57:34 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:57:04 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/product_info.php

[Thu Nov 8 15:57:04 2007] [error] [client 74.6.29.16] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:56:33 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:56:22 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:55:57 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

[Thu Nov 8 15:55:36 2007] [error] [client 208.36.144.6] Premature end of script headers: /home/zarekman/public_html/index.php

 

I do not know how to fix this errors, my ISP write to me this answer:

 

Hello,

 

The website showing internal server error is due to error in the php script. This is the error logs while running the URL /home/zarekman/public_html/index.php

===============

[Wed Nov 7 14:23:15 2007] [error] [client 122.167.49.34] Premature end of script headers: /home/zarekman/public_html/index.php

===============

Please contact a php programmer and make necessary changes and check the same.

 

Unfortunatelly I am not sure what neccessary changes should I undergo.

[user99999999]

Check your .htaccess file for sytax errrors but really stock osc with 200k products will kill any budget hosting plan.