PHP script stops randomly!

[s17]

Hi all,

I run a PHP script which adds products to a MySQL db. The script finds new products to add in batches, and adds them in batches. However, since transferring the script to hostgator, the script stops running randomly, usually at the beginning of one of the batches being injected to the db. Since this never happened before when I hosted the scripts from WAMP/LAMP, I am guessing there is some kind of memory or timeout issue occurring. Can anyone help or offer ideas?

Thanks!

[s17]

I just deduced that the "interruption" is occuring exactly between these two lines:

include_once('mysql.php');
$mysql = new MYSQL();

I am still baffled as to why this line is stopping the script...

[virtvir5]

First of all, there should be no problem whatever with a properly coded PHP script adding any reasonable number of records to a MySQL table. I run such a script on my shared server that adds 108,731 geoIP records in just a few seconds.

Scripting logic suggests that the failure is occuring with attempted execution of the include_once instruction. And that, in turn, suggests that either it isn't finding what it's trying to include or else some aspect of the include file itself is corrupting the process.

[s17]

Turns out hostgator kills any connections that take longer than 30 seconds.. The default timeout is 8 hours. I am filing a ticket right now to increase the limit to something reasonable (I need at least 5minutes for some scripts). I will keep you all posted.

[virtvir5]

Huh?! If its timing out following an "include_once" instruction as per your original post, that must be one heck of an include file.

Not sure where you think you're gonna get a PHP max_execution_time setting of 8 hours or anything like that, but I'm willing to bet that HG won't even consider 5 minutes.

[striddy]

Originally Posted by s17

Turns out hostgator kills any connections that take longer than 30 seconds.. The default timeout is 8 hours. I am filing a ticket right now to increase the limit to something reasonable (I need at least 5minutes for some scripts).

8 hours max_execution_time for a script on a $10 p/month shared server..... not likely.

8 hours for a script on any server ..... still not likely.

30 seconds is the default, not 8 hours.

My bet is that HG will tell you to fix your script or move to a dedicated server.

From the ToS:

7. Resource Usage
User may not:
a) Use 25% or more of system resources for longer then 90 seconds. There are numerous activities that could cause such problems; these include: CGI scripts, FTP, PHP, HTTP, etc.