Re: [GENERAL] Error in PostgreSQL Log - Mailing list pgsql-general
| From | Sachin Srivastava |
|---|---|
| Subject | Re: [GENERAL] Error in PostgreSQL Log |
| Date | |
| Msg-id | CAFzqEh+mvJbOagKfQBvvx-H-_QbgEe61CPR0wG4Vy92r9bvLiw@mail.gmail.com Whole thread Raw |
| In response to | [GENERAL] Error in PostgreSQL Log (Sachin Srivastava <ssr.teleatlas@gmail.com>) |
| List | pgsql-general |
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.2ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIcgjE=_ AAAAAAAAAAAAAP// CqqfIep65ipZAmdpAAIciwAAAAAAAA AA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAIcgjE=_ AAAAAAAAAAAAAP// CqqfIep65ipZAmdpAAIciwAAAAAAAA AA'
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// Cqq6UmqUdDpZAmc2AAJPGgAAAAAAAA AA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6UmqUdDpZAmc2AAJPFDE=_ AAAAAAAAAAAAAP// Cqq6UmqUdDpZAmc2AAJPGgAAAAAAAA AA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef2TE=_ AAAAAAAAAAAAAP// Cqq6QiDZF3BZAjkeABef4QAAAAAAAA AA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABef2TE=_ AAAAAAAAAAAAAP// Cqq6QiDZF3BZAjkeABef4QAAAAAAAA AA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen1DE=_ AAAAAAAAAAAAAP// Cqq6QiDZF3BZAjkeABen2AAAAAAAAA AA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6QiDZF3BZAjkeABen1DE=_ AAAAAAAAAAAAAP// Cqq6QiDZF3BZAjkeABen2AAAAAAAAA AA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAN/7DE=_ AAAAAAAAAAAAAP// Cqq6abHV5e9ZAmJCAAOAHwAAAAAAAA AA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//Cqq6abHV5e9ZAmJCAAN/7DE=_ AAAAAAAAAAAAAP// Cqq6abHV5e9ZAmJCAAOAHwAAAAAAAA AA'
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// CqqfIep65ipZAmdpAAKVFQAAAAAAAA AA" does not exist
STATEMENT: ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAKVDjE=_ AAAAAAAAAAAAAP// CqqfIep65ipZAmdpAAKVFQAAAAAAAA AA'
ERROR: prepared transaction with identifier "131077_AAAAAAAAAAAAAP//CqqfIep65ipZAmdpAAK4bDE=_ AAAAAAAAAAAAAP// CqqfIep65ipZAmdpAAK4cAAAAAAAAA AA" does not exist
"postgresql-Fri.log" 313L, 30355CRegards,SSR
pgsql-general by date: