db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: [Derby-359]Skipping over user inserted values into GENERATED BY DEFAULT identity columns....
Date Tue, 27 Dec 2005 17:32:55 GMT
Mamta Satoor wrote:

> To narrow down the locking issue, I have moved the create table outside
> the create unique index transaction as follows. Also, I have added sql
> to dump lock table for syscolumns to see what kind of locks exist on
> SYSCOLUMNS at various points.

> So, the create index is getting intent share lock on SYSCOLUMNS table
> and share locks on some of the rows. This prevents the nested
> transaction for generated keys logic from getting an intent exclusive on
> table and exclusive lock on the rows.

I don't think the intent share lock on SYSCOLUMNS will prevent the
nested transaction getting an intent exclusive locks. Such table level
locks just indicate that the transaction has the intent to get shared or
exclusive row locks, thus the intent table locks are compatible with
each other.

I think only the locks on the rows representing the columns of the table
are in conflict.


View raw message