PRB: Extra Insert_page Locks Held on a Page Split with IRL

• Microsoft SQL Server version 6.5

SYMPTOMS

Under the following circumstances, insert_page locks may be held on pages that a client has not inserted on:

• The client has inserted to a table with Insert Row Locking (IRL) enabled in a transaction that has not been committed yet.
  
  -and-



• Another client performs an INSERT to the same table, causing a new page to be added to the table.

MORE INFORMATION

The extra insert_page locks held by the other clients are needed for transactional integrity. They do not cause any additional blocking because the other clients are already blocked from further inserts until the client with the link_page lock commits its transaction.

Additional query words: link_page

Keywords          : kbnetwork kbusage SSrvLock SSrvTran_SQL kbbug6.50 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 3, 1999