Postgres Pro
Downloads
Home   >   mailing lists

Re: current transaction is aborted, commands ignored until end of transaction block - Mailing list pgsql-general

From Michael Fuhr
Subject Re: current transaction is aborted, commands ignored until end of transaction block
Date
Msg-id 20041005072937.GA44658@winnie.fuhr.org
Whole thread Raw
In response to current transaction is aborted, commands ignored until end of transaction block  (ruben <ruben20@superguai.com>)
Responses Re: current transaction is aborted, commands ignored until  ("ruben20@superguai.com" <ruben20@superguai.com>)
List pgsql-general
Tree view 
On Tue, Oct 05, 2004 at 07:54:23AM +0200, ruben wrote:

> After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
> are having intermitent issues with certain online PHP transactions,
> returning this error:
>
> "Warning: pg_exec() query failed: ERROR: current transaction is aborted,
> commands ignored until end of transaction block"

Some previous query in this transaction has failed.  Are there other
error messages before this one?  What queries preceded the one that
gives this error?

> Half the times we run the query we get the error, the other half it works.

By "half" do you mean exactly 50% of the time, or are you approximating?
Can you identify anything common to the successful transactions that's
different from the failed transactions?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: ruben
Date:
Subject: current transaction is aborted, commands ignored until end of transaction block
Next
From: "Andre Maasikas"
Date:
Subject: Re: guaranteeing that a sequence never skips