Home > mailing lists

Thread: [GENERAL] Error in PostgreSQL Log

[GENERAL] Error in PostgreSQL Log

From

Sachin Srivastava

Date:

28 April 2017, 21:45:57

Dear Team,

Please suggest why we are getting the below error in our PostgreSQL DB log.

We are using postgresql version = 9.2

ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIcgjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIciwAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIcgjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIciwAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAIpmTE=_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAIpoAAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAIpmTE=_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAIpoAAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPFDE=_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPGgAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPFDE=_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPGgAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef2TE=_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef4QAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef2TE=_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef4QAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen1DE=_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen2AAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen1DE=_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen2AAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAN/7DE=_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAOAHwAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAN/7DE=_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAOAHwAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAJtczE=_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAJthQAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAJtczE=_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAJthQAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVDjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVFQAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVDjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVFQAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAK4bDE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAK4cAAAAAAAAAAA" does not exist
"postgresql-Fri.log" 313L, 30355C

Regards,

SSR

Re: [GENERAL] Error in PostgreSQL Log

From

Sachin Srivastava

Date:

28 April 2017, 21:47:32

I have already tuned below parameters as

max_prepared_transactions = 500

max_connection = 2000

Regards,

SSR

On Sat, Apr 29, 2017 at 12:15 AM, Sachin Srivastava <ssr.teleatlas@gmail.com> wrote:

Dear Team,

Please suggest why we are getting the below error in our PostgreSQL DB log.

We are using postgresql version = 9.2

ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIcgjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIciwAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIcgjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIciwAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAIpmTE=_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAIpoAAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAIpmTE=_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAIpoAAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPFDE=_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPGgAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPFDE=_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPGgAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef2TE=_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef4QAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef2TE=_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef4QAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen1DE=_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen2AAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen1DE=_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen2AAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAN/7DE=_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAOAHwAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAN/7DE=_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAOAHwAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAJtczE=_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAJthQAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAJtczE=_AAAAAAAAAAAAAP//Cqq6U+K0bPBZAmdRAAJthQAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVDjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVFQAAAAAAAAAA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVDjE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVFQAAAAAAAAAA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAK4bDE=_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAK4cAAAAAAAAAAA" does not exist
"postgresql-Fri.log" 313L, 30355C

Regards,
SSR

Re: [GENERAL] Error in PostgreSQL Log

From

"David G. Johnston"

Date:

28 April 2017, 21:58:45

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.

Re: [GENERAL] Error in PostgreSQL Log

From

Jerry Sievers

Date:

28 April 2017, 22:01:36

Sachin Srivastava <ssr.teleatlas@gmail.com> writes:

> Dear Team,
>
> Please suggest why we are getting the below error in our PostgreSQL
> DB log.
>
> We are using postgresql version = 9.2
>
>
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//

I dont have such an ancient version of Pg to test with but if indeed
your application is not using bogus or already committed  prepared xact
IDs, then did perhaps someone/thing mangle files in pg_twophase?

HTH

> CqqfIep65ipZAmdpAAIcgjE=_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAIciwAAAAAAAAAA" does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAIcgjE=_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAIciwAAAAAAAAAA'
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//
> Cqq6U+K0bPBZAmdRAAIpmTE=_AAAAAAAAAAAAAP//
> Cqq6U+K0bPBZAmdRAAIpoAAAAAAAAAAA" does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//
> Cqq6U+K0bPBZAmdRAAIpmTE=_AAAAAAAAAAAAAP//
> Cqq6U+K0bPBZAmdRAAIpoAAAAAAAAAAA'
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//
> Cqq6UmqUdDpZAmc2AAJPFDE=_AAAAAAAAAAAAAP//
> Cqq6UmqUdDpZAmc2AAJPGgAAAAAAAAAA" does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//
> Cqq6UmqUdDpZAmc2AAJPFDE=_AAAAAAAAAAAAAP//
> Cqq6UmqUdDpZAmc2AAJPGgAAAAAAAAAA'
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//
> Cqq6QiDZF3BZAjkeABef2TE=_AAAAAAAAAAAAAP//
> Cqq6QiDZF3BZAjkeABef4QAAAAAAAAAA" does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//
> Cqq6QiDZF3BZAjkeABef2TE=_AAAAAAAAAAAAAP//
> Cqq6QiDZF3BZAjkeABef4QAAAAAAAAAA'
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//
> Cqq6QiDZF3BZAjkeABen1DE=_AAAAAAAAAAAAAP//
> Cqq6QiDZF3BZAjkeABen2AAAAAAAAAAA" does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//
> Cqq6QiDZF3BZAjkeABen1DE=_AAAAAAAAAAAAAP//
> Cqq6QiDZF3BZAjkeABen2AAAAAAAAAAA'
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//
> Cqq6abHV5e9ZAmJCAAN/7DE=_AAAAAAAAAAAAAP//
> Cqq6abHV5e9ZAmJCAAOAHwAAAAAAAAAA" does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//
> Cqq6abHV5e9ZAmJCAAN/7DE=_AAAAAAAAAAAAAP//
> Cqq6abHV5e9ZAmJCAAOAHwAAAAAAAAAA'
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//
> Cqq6U+K0bPBZAmdRAAJtczE=_AAAAAAAAAAAAAP//
> Cqq6U+K0bPBZAmdRAAJthQAAAAAAAAAA" does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//
> Cqq6U+K0bPBZAmdRAAJtczE=_AAAAAAAAAAAAAP//
> Cqq6U+K0bPBZAmdRAAJthQAAAAAAAAAA'
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAKVDjE=_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAKVFQAAAAAAAAAA" does not exist
> STATEMENT:  ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAKVDjE=_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAKVFQAAAAAAAAAA'
> ERROR:  prepared transaction with identifier "131077_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAK4bDE=_AAAAAAAAAAAAAP//
> CqqfIep65ipZAmdpAAK4cAAAAAAAAAAA" does not exist
> "postgresql-Fri.log" 313L, 30355C
>
> Regards,
> SSR
>
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800