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.teleat...@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 > >