By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,104 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

current transaction is aborted, commands ignored until end of transactionblock

P: n/a
Hi:

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"

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

Any ideas? Thanks.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2

P: n/a
Hi Michael:

Michael Fuhr 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?


Yes, there is some incompatibility between 7.4.2 and 7.4.5 with INT type
comparisons, not allowing (7.4.5) something like "WHERE int_field = ''",
so the same transaction failed before the error reported with this one:

Warning: pg_exec() query failed: ERROR: invalid input syntax for integer: ""
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?


I was approximating. The transaction is exactly the same, I just click
on "UPDATE" button on the web browser and sometimes it worked and
sometimes not.

Thanks a lot.
Ruben.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.