Re: Error in PostgreSQL Log

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Friday, April 28, 2017, Sachin Srivastava <ssr.teleatlas@xxxxxxxxx> 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.