[ADMIN] Sometime Update is not modifying data inside database.

2012-07-30 Thread Amit Kumar
All, I am facing a weired issue in PG 9.0.3. Sometime via application UPDATES are not changing data in the database but in postgres logs its also not raising any error. It is happening 2-3 times in a week. I have tried but not able to reproduce this error. fsync is ON. We are not using hibernate

Re: [ADMIN] Sometime Update is not modifying data inside database.

2012-07-30 Thread Tom Lane
Amit Kumar writes: > > Jul 30 12:40:36 dell16 postgres[11088]: [11-1] 2012-07-30 12:40:36 IST > [11088]: [10-1] user=postgres,db=dbpush xx(43225)LOG: > statement: START TRANSACTION > Jul 30 12:40:36 dell16 postgres[11088]: [12-1] 2012-07-30 12:40:36 IST > [11088]: [11-1] user=post

Re: [ADMIN] Sometime Update is not modifying data inside database.

2012-07-30 Thread Craig James
On Mon, Jul 30, 2012 at 4:06 AM, Amit Kumar wrote: > All, > > I am facing a weired issue in PG 9.0.3. Sometime via application UPDATES > are not changing data in the database but in postgres logs its also not > raising any error. It is happening 2-3 times in a week. I have tried but > not able t