problem with postgres 7.3.2 + PHP 4.2.3

From: Date: Fri, 02 May 2003 08:40:10 +0000
Subject: problem with postgres 7.3.2 + PHP 4.2.3
Groups: php.general 
Request: Send a blank email to php-general+get-146076@lists.php.net to get a copy of this message
Hello, It seems there is a little bug in PHP or postgres (or may be is this a feature ?): We use persistant connections and it seems that : if you use transaction (BEGIN / COMMIT) AND in this transaction there is an incorrect query AND before the COMMIT statement your script reaches the execution limit time, THEN all the scripts that will be executed and will use THIS connection the the DB will not be able to execute any DB query : there will be always : pg_exec() query failed: ERROR: current transaction is aborted, queries ignored until end of transaction block in xxx on line xx although it was not this script that made an error. It is like if there was no auto commit when a script ends when it reaches its execution time limit, then the DB "thinks" that all other queries (even from another scripts) are in the same transaction... Jean-Arthur Silve EuroVox 4, Place Félix Eboué 75583 Paris Cedex 12 T : +33 1 44670505 F : +33 1 44670519

« previous php.general (#146076) next »