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

>> 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?

Yes. It has the primary key, so has an btree index.

>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?

Please let me know if you fix it. I will run the test again.
---
Tatsuo Ishii