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

current transaction is aborted. queries ignored until end of the transaction block

P: 13
hi,

This is the error that we are getting on postgresql. The error is as follows:

current transaction is aborted. queries ignored until end of the transaction block.

What might be the real cause of the problem and how do we rectify it?

Any suggestions will be appreciable.

Thanks,
Sagar.
Oct 2 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
hi,

This is the error that we are getting on postgresql. The error is as follows:

current transaction is aborted. queries ignored until end of the transaction block.

What might be the real cause of the problem and how do we rectify it?

Any suggestions will be appreciable.

Thanks,
Sagar.
You have started transaction (BEGIN command I guess) and into it some queries have failed. Now you should write rollback or commit (doesn't matter here) to end transaction blok. Read about transactions at http://postgresql.org
Oct 2 '07 #2

P: 5
hi,

This is the error that we are getting on postgresql. The error is as follows:

current transaction is aborted. queries ignored until end of the transaction block.

What might be the real cause of the problem and how do we rectify it?

Any suggestions will be appreciable.

Thanks,
Sagar.
Sagar,

This error msg may come due to some problem in Database CONNECTION OPENING AND CLOSING
Dec 14 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.