BUG #15318: ERROR: current transaction is aborted, commands ignored until end of transaction block

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15318: ERROR: current transaction is aborted, commands ignored until end of transaction block

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      15318
Logged by:          Nanda Kumar
Email address:      [hidden email]
PostgreSQL version: 9.6.9
Operating system:   Linux centos-test.sst.stp 3.10.0-327.el7.x86_64
Description:        

The below error occurred when I try to insert the record .

ERROR:  current transaction is aborted, commands ignored until end of
transaction block
SQL state: 25P02

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15318: ERROR: current transaction is aborted, commands ignored until end of transaction block

Sergei Kornilov
Hello
As say error message, your transaction is aborted. You can now only perform rollback.
Why transaction is aborted? You have some error before all "current transaction is aborted".

regards, Sergei

Reply | Threaded
Open this post in threaded view
|

RE: BUG #15318: ERROR: current transaction is aborted, commands ignored until end of transaction block

Nanda Kumar
Hi Sergei ,

I don't have any error message before this. Below is the complete error message .

ERROR:  current transaction is aborted, commands ignored until end of transaction block
SQL state: 25P02


Regards
Nanda Kumar.M
SmartStream Technologies
Eastland Citadel | 5th Floor | 102 Hosur Road | Banglore 560 095 | India
[hidden email] | www.smartstream-stp.com
Mob
+91 99720 44779
Tel
+91 80617 64107



-----Original Message-----
From: Sergei Kornilov [mailto:[hidden email]]
Sent: 08 August 2018 14:24
To: Nanda Kumar; [hidden email]
Subject: Re: BUG #15318: ERROR: current transaction is aborted, commands ignored until end of transaction block

Hello
As say error message, your transaction is aborted. You can now only perform rollback.
Why transaction is aborted? You have some error before all "current transaction is aborted".

regards, Sergei
________________________________
 The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15318: ERROR: current transaction is aborted, commands ignored until end of transaction block

Sergei Kornilov
Hello
Please check your application error handling. And server logs.
You have error during execution some previous command in this transaction, even if your application hide this.

Postgresql ignore all commands (except rollback) if transaction was aborted. This is not bug.

regards, Sergei