"current transaction is aborted, commands ignored until end of transaction block" Error

Started by Ying Lualmost 21 years ago2 messagesgeneral
Jump to latest
#1Ying Lu
ying_lu@cs.concordia.ca

Greetings,

Through java - JDBC, trying to do "select * from Table" using "lock
table IN SHARE MODE"; Always got this error:

"current transaction is aborted, commands ignored until end of
transaction block"

Some clues about it?

Thanks a lot!
Emi

#2Richard Huxton
dev@archonet.com
In reply to: Ying Lu (#1)
Re: "current transaction is aborted, commands ignored until

Ying Lu wrote:

Greetings,

Through java - JDBC, trying to do "select * from Table" using "lock
table IN SHARE MODE"; Always got this error:

"current transaction is aborted, commands ignored until end of
transaction block"

One of your commands has an error, and the transaction has been aborted
because of that. PostgreSQL will have returned an error message telling
you what the problem was.

--
Richard Huxton
Archonet Ltd