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

 Last reviewed: April 29, 1997
Article ID: Q158327
The information in this article applies to:
  • 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 : kbbug6.50 kbnetwork kbusage SSrvLock SSrvTran_SQL
Version : 6.5
Platform : WINDOWS
Issue type : kbbug
Resolution Type : kbfix

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.