problem with postgres 7.3.2 + PHP 4.2.3
| From: | JEANARTHUR at EUROVOX dot FR | 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