PRB: Extra Insert_page Locks Held on a Page Split with IRL (158327)
The information in this article 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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix kbnetwork kbusage KB158327 |
|---|
|