Thread: RE: [GENERAL] {OT} Maximum execution time exceeded

RE: [GENERAL] {OT} Maximum execution time exceeded

From
"Jackson, DeJuan"
Date:
Check directory permission for your Webserver user.  If you are using
apache the nobody.  It sounds as if you can't write the file on your
server.  You could also output some debug info at key points to find out
exactly where the script is dieing and correct the problem from there.
This is definitely not a PostgreSQL issue though, unless creating some
indexes on the tables you are access will decrease your execution time.

BTW you can use the set_time_limit() function to change you time limit
on a script by script basis.

Hope this helps,
    DEJ

> -----Original Message-----
> From: PostgreSQL [mailto:pgsql@brazilinfo.com]
> Sent: Wednesday, January 20, 1999 11:25 AM
> To: pgsql-general@postgreSQL.org
> Subject: [GENERAL] Maximum execution time exceeded
>
>
> Hi,
>
> I need to run a PHP3 script from the web after submitting a form. This
> script generates several 'html' files with data collected
> from a PostgreSQL
> database. It is a while loop wherein, for each record returned in my
> previous query, one file is generated. So for each 'while
> loop' iteration, a
> new file is opened for rewriting, all info written to it, and
> then closed at
> the end of the loop, where we proceed to the next record
> (another file to be
> generated).
>
> When running this with PHP2 & mSQL, files were generated
> progressively, so
> that I could see the files being written at a Telnet prompt
> while the script
> was running.
>
> Now, using PostgreSQL & PHP3 I faced the following problem:
>
> The time needed to generate all these files must be a couple
> of minutes. But
> I received at my browser the following message issued by PHP3:
>
> Fatal error: Maximum execution time of 30 seconds exceeded in
> /usr/local/etc/httpd/htdocs/myfile.php3 on line 62
>
> I added the following line to my 'httpd.conf' file, as I
> noted this should
> be a PHP3 time limit:
>
>   php3_max_execution_time 360
>
> But now my browser is kept in the submission form page (I am
> not taken to
> the second page, where I also output the contents written to
> the files to
> the screen) and after a while I receive a message from the
> browser stating
> that it could not complete the operation. And no updated
> files are generated
> during the time it takes to issue the error message.
>
> Any ideas of what is the problem?
>
>
> TIA,
>
> Paulo
>
>
>
>