From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
---|---|
To: | Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> |
Cc: | "pgsql-general\(at)postgresql(dot)org \>\> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Error in PostgreSQL Log |
Date: | 2017-04-28 19:01:36 |
Message-ID: | 87h918l5kf.fsf@jsievers.enova.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> writes:
> 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//
I dont have such an ancient version of Pg to test with but if indeed
your application is not using bogus or already committed prepared xact
IDs, then did perhaps someone/thing mangle files in pg_twophase?
HTH
> 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
>
>
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Vitek | 2017-04-28 19:59:17 | query planner placement of sort/limit w.r.t. joins |
Previous Message | David G. Johnston | 2017-04-28 18:58:45 | Re: Error in PostgreSQL Log |