X-Original-To: pgsql-php@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EF126475458 for ; Wed, 16 Apr 2003 11:12:23 -0400 (EDT) Received: from tomts16-srv.bellnexxia.net (tomts16.bellnexxia.net [209.226.175.4]) by postgresql.org (Postfix) with ESMTP id 7C7FA475C3D for ; Wed, 16 Apr 2003 11:11:51 -0400 (EDT) Received: from acer.sympatico.ca ([67.69.229.22]) by tomts16-srv.bellnexxia.net (InterMail vM.5.01.04.19 201-253-122-122-119-20020516) with ESMTP id <20030416151155.GFUX17011.tomts16-srv.bellnexxia.net@acer.sympatico.ca> for ; Wed, 16 Apr 2003 11:11:55 -0400 Message-Id: <5.2.0.9.0.20030416105915.00a0a900@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Wed, 16 Apr 2003 11:03:29 -0400 To: From: Frank Bax Subject: Re: Exceeding 300 second timeout? In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Spam-Status: No, hits=-25.2 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REPLY_WITH_QUOTES 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/9 X-Sequence-Number: 1979 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