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

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: Vadim Mikheev <vadim(at)krs(dot)ru>
Cc: t-ishii(at)sra(dot)co(dot)jp, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction
Date: 1999-05-24 04:10:37
Message-ID: 199905240410.NAA29768@srapc451.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 1999-05-24 04:46:21 RE: [HACKERS] Current TODO list
Previous Message Vadim Mikheev 1999-05-24 03:56:43 Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction