From: Rich Garabedian <richg@mav-mail.com>
To: pgsql-php@postgresql.org
Subject: Exceeding 300 second timeout?
Date: Wed, 16 Apr 2003 09:57:21 -0400
Message-ID: <HNEKIGDMMIODOHIMFPGJIEIMCGAA.richg@mav-mail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: richg@mav-mail.com
Subject: Re: Exceeding 300 second timeout?
In-Reply-To: <HNEKIGDMMIODOHIMFPGJIEIMCGAA.richg@mav-mail.com>
References: <HNEKIGDMMIODOHIMFPGJIEIMCGAA.richg@mav-mail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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