Error in PostgreSQL Log

From: Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Error in PostgreSQL Log
Date: 2017-04-28 18:45:57
Message-ID: CAFzqEhLLXtk7DwQFZqk85HL7Tqmn7_gm2apz_8fXsHUk3rpWog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Srivastava 2017-04-28 18:47:32 Re: Error in PostgreSQL Log
Previous Message Igor Neyman 2017-04-28 17:25:07 Re: PostgreSQL Required Monitoring