Re: [GENERAL] Error in PostgreSQL Log - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Error in PostgreSQL Log
Date
Msg-id CAKFQuway_+rPnf=eAVRBX5d6OMioux-CJEUAs33Rc7zUSZdFbQ@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Error in PostgreSQL Log  (Sachin Srivastava <ssr.teleatlas@gmail.com>)
List pgsql-general
On Friday, April 28, 2017, Sachin Srivastava <ssr.teleatlas@gmail.com> wrote:
Please suggest why we are getting the below error in our PostgreSQL DB log.

ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIcgjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIciwAAAAAAAAAA" does not exist
STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIcgjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIciwAAAAAAAAAA'

The error seems self-explanatory...

Without any context no one is going to be able to guess why you have an application trying to rollback a non-existent two-phase prepared transaction.  But likely the problem is not something under PostgreSQL control.

David J.

pgsql-general by date:

Previous
From: Sachin Srivastava
Date:
Subject: Re: [GENERAL] Error in PostgreSQL Log
Next
From: Jerry Sievers
Date:
Subject: Re: [GENERAL] Error in PostgreSQL Log