Re: [GENERAL] Error in PostgreSQL Log

Поиск
Список
Период
Сортировка
От Sachin Srivastava
Тема Re: [GENERAL] Error in PostgreSQL Log
Дата
Msg-id CAFzqEh+mvJbOagKfQBvvx-H-_QbgEe61CPR0wG4Vy92r9bvLiw@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Error in PostgreSQL Log  (Sachin Srivastava <ssr.teleatlas@gmail.com>)
Список 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.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


В списке pgsql-general по дате отправления:

Предыдущее
От: Sachin Srivastava
Дата:
Сообщение: [GENERAL] Error in PostgreSQL Log
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] Error in PostgreSQL Log