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

The following bug has been logged on the website:

Bug reference:      15318
Logged by:          Nanda Kumar
Email address:      nanda.kumar@smartstream-stp.com
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

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

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
nanda.kumar@smartstream-stp.com | www.smartstream-stp.com
Mob
+91 99720 44779
Tel
+91 80617 64107



-----Original Message-----
From: Sergei Kornilov [mailto:sk@zsrv.org]
Sent: 08 August 2018 14:24
To: Nanda Kumar; pgsql-bugs@lists.postgresql.org
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.
Accessto this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying,
distributionor any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 

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