PHP Script Times out after 45 seconds

Question

I am running a huge import to my database(about 200k records) and I'm having a serious issue with my import script timing out. I used my cell phone as a stop watch and found that it times out at exactly 45 seconds every pass(internal server error)... it only does about 200 records at a time, sometimes less. I scanned my phpinfo() and nothing is set to 45 seconds; so, I am clueless as to why it would be doing this.

My max_execution_time is set to 5 minutes and my max_input_time is set to 60 seconds. I also tried setting set_time_limit(0); ignore_user_abort(1); at the top of my page but it did not work.

It may also be helpful to note that my error file reads: "Premature end of script headers" as the execution error.

Any assistance is greatly appreciated.

Answer 1

I tried all the solutions on this page and, of course, running from the command line:

php -f filename.php

as Brent says is the sensible way round it.

But if you really want to run a script from your browser that keeps timing out after 45 seconds with a 500 internal server error (as I found when rebuilding my phpBB search index) then there's a good chance it's caused by mod_fcgid.

I have a Plesk VPS and I fixed it by editing the file

/etc/httpd/conf.d/fcgid.conf

Specifically, I changed

FcgidIOTimeout 45

to

FcgidIOTimeout 3600

3600 seconds = 1 hour. Should be long enough for most but adjust upwards if required. I saw one example quoting 7200 seconds in there.

Finally, restart Apache to make the new setting active.

apachectl graceful

HTH someone. It's been bugging me for 6 months now!

Cheers,

Rich