Sachin Srivastava <ssr.teleatlas@xxxxxxxxx> 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.consulting@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
