Re: [GENERAL] Error in PostgreSQL Log

2017-04-28 Thread Jerry Sievers
Sachin Srivastava 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_AP// I dont have such an ancient version of Pg to test with bu

Re: [GENERAL] Error in PostgreSQL Log

2017-04-28 Thread David G. Johnston
On Friday, April 28, 2017, Sachin Srivastava wrote: > > Please suggest why we are getting the below error in our PostgreSQL DB log. > > ERROR: prepared transaction with identifier "131077_AP// > CqqfIep65ipZAmdpAAIcgjE=_AP//CqqfIep65ipZAmdpAAIciwAA" > does not exis

Re: [GENERAL] Error in PostgreSQL Log

2017-04-28 Thread Sachin Srivastava
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 wrote: > Dear Team, > > Please suggest why we are getting the below error in our PostgreSQL DB log. > > We are using postgresql v

[GENERAL] Error in PostgreSQL Log

2017-04-28 Thread Sachin Srivastava
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_AP//CqqfIep65ipZAmdpAAIcgjE=_AP//CqqfIep65ipZAmdpAAIciwAA" does not exist STATEMENT: