Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction

> Tatsuo Ishii wrote:
> > 
> > > > I get above message from the backend while trying to update same raw
> > > > from different transactions (I guess). Is this normal?
> > 
> > My sessions look like:
> > 
> > begin;
> > update t set a = 1 where c = 1;
> > select * from t where c = 1;
> > end;
> 
> Ops. Do you have indices over table t?
> Btree-s are still using page-level locking and don't release
> locks when leave index page to fetch row from relation.
> Seems that this causes deadlocks more often than I thought -:(
> 
> Marc? I can fix this today and I'll be very careful...
> Ok?


If you don't, seems like our MVCC isn't going to be much good.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026