Re: Error in PostgreSQL Log

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(dot)teleatlas(at)gmail(dot)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
>
>