Re: Deadlock query - no rows waited on

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Fri, 8 Sep 2000 04:36:00 +0100
Message-ID: <$UYdHJAg6Fu5Ew62@ahardy.demon.co.uk>

In article <39b833d5.331963728_at_nsw.nnrp.telstra.net>, Steve Adams <steve.adams_at_ixora.com.au> writes
>Hi Andy,
>
>Note that the TM enqueue names are different. The other session (34) is the
>culprit. It has taken a shared lock on HANGER_CONTENTS and is waiting for a
>shared lock on object_id 1260.

Are you saying that -000004ec and -000004e7 are the tables with the locks on them? Wish that I'd noticed that!

Right, I understand the relationship between the two tables - 1260 is the 'parent' table of 1255... and they do often get updated at the same time and 1260 can also get updated separately by a real-time process. I've just put back a missing index on 1255 for the foreign key to 1260 - I wonder if this will help...

Thanks for your help,

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================

Received on Thu Sep 07 2000 - 22:36:00 CDT