Re: Shared row locks?

Charles Jardine wrote:
>
> The session is question was blocked in foreign key processing
> while deleting a master row. The only reference to the row was
> from a detail row which had been inserted but not yet committed.
> The master row delete was apparently waiting for a shared row
> lock on the uncommitted detail record.

Almost sounds like a problem I had. Check to see if the detail row is holding a table lock on the table where the master row is located. I don't remember exactly the problem, but if the column that is referenced in a FK constraint is not indexed then a table lock is acquired until the update completes. This problem goes away in 7.3 according to Thomas Kyte. To solve this problem (and prepare for our upgrade to 7.3) I've created indexes on both the parent and child columns.

-- 

Ed Bruce
<Bruce_at_ha.hac.com>
<ebruce_at_iquest.com>