pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedExceeding 300 second timeout?
2+ messages / 2 participants
[nested] [flat]
* Exceeding 300 second timeout?
@ 2003-04-16 13:57 Rich Garabedian <richg@mav-mail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Rich Garabedian @ 2003-04-16 13:57 UTC (permalink / raw)
To: pgsql-php
Hi,
Running into an interesting problem where a time-intensive, php command line
script times-out occasionally. This particular script can sometimes take
over and hour to complete and it does a ton of interaction with our
postgreSQL database. The exact error message is the following:
Fatal error: Maximum execution time of 300 seconds exceeded in dbbind.php
on line 17
Line 17 of dbbind.php looks like this:
$t=pg_fieldtype($rs,$col);
I was under the impression that cli php has no timeout, so I'm assuming this
is something with postgreSQL. However, I've been unable to locate any
references to default 300 second time limits with postgreSQL, or php. Is
there any way I can extend this timeout? Or any hints on figuring out why
it's happening in the first place? I would think pg_fieldtype() would return
fairly quickly?
PostgreSQL version:
version
-------------------------------------------------------------
PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
Many thanks in advance,
Rich
For further data, if I look at php config (as shown by running php -i) I see
the following(edited out a lot of lines for clarity)
phpinfo()
PHP Version => 4.3.1
System => Linux linux01.ourdomain.com 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34
EDT 2001 i686
Build Date => Apr 8 2003 14:50:57
Configure Command => './configure' '--disable-cgi'
'--with-pgsql=/usr/pgsql/' '--prefix=/mm/php-cmdline-431'
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /mm/php-cmdline-431/lib
PHP API => 20020918
PHP Extension => 20020429
Zend Extension => 20021010
Debug Build => no
Thread Safety => disabled
Registered PHP Streams => php, http, ftp
This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2002 Zend Technologies
_______________________________________________________________________
Configuration
PHP Core
max_execution_time => 0 => 30
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Exceeding 300 second timeout?
@ 2003-04-16 15:03 Frank Bax <fbax@sympatico.ca>
parent: Rich Garabedian <richg@mav-mail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Frank Bax @ 2003-04-16 15:03 UTC (permalink / raw)
To: pgsql-php
At 09:57 AM 4/16/03, Rich Garabedian wrote:
>Running into an interesting problem where a time-intensive, php command line
>script times-out occasionally. This particular script can sometimes take
>over and hour to complete and it does a ton of interaction with our
>postgreSQL database. The exact error message is the following:
>
> Fatal error: Maximum execution time of 300 seconds exceeded in
> dbbind.php
>on line 17
>
>Line 17 of dbbind.php looks like this:
>
> $t=pg_fieldtype($rs,$col);
>
>I was under the impression that cli php has no timeout, so I'm assuming this
>is something with postgreSQL.
It is a php limit (although docs indicate it is 30, not 300), but can be
changed within your script:
http://www.php.net/manual/en/function.set-time-limit.php
FYI: If you were running a long php script under apache, there is also an
apache limit.
Frank
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-04-16 15:03 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-16 13:57 Exceeding 300 second timeout? Rich Garabedian <richg@mav-mail.com>
2003-04-16 15:03 ` Frank Bax <fbax@sympatico.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox