Knowledge Base

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

Article ID: 158327

Article Last Modified on 10/3/2003

APPLIES TO

This article was previously published under Q158327

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: kbbug kbfix kbnetwork kbusage KB158327


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.