X-Original-To: pgsql-php@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E605647612F for ; Wed, 16 Apr 2003 09:57:24 -0400 (EDT) Received: from mail.mav-mail.com (mail.mav-mail.com [208.178.167.103]) by postgresql.org (Postfix) with ESMTP id E07EF475C15 for ; Wed, 16 Apr 2003 09:57:19 -0400 (EDT) Received: from RICHLAPTOP [192.168.1.50] by mail.mav-mail.com with ESMTP (SMTPD32-7.06) id A3444A210128; Wed, 16 Apr 2003 10:05:56 -0400 From: "Rich Garabedian" To: Subject: Exceeding 300 second timeout? Date: Wed, 16 Apr 2003 09:57:21 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Spam-Status: No, hits=-11.1 required=5.0 tests=BAYES_10,MSGID_GOOD_EXCHANGE,SMTPD_IN_RCVD autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/8 X-Sequence-Number: 1978 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