FIX: ROLLBACK Causes Errs 6902, 602, OS Error 6, or Handled AV

 Last reviewed: April 9, 1997
Article ID: Q158463

The information in this article applies to:
  • Microsoft SQL Server, version 6.5
BUG #: 16131 (6.50)

SYMPTOMS

If Sp_tableoption is called and User Option has IMPLICIT_TRANSACTIONS set to ON, ROLLBACK may cause any of the following problems:

  • Error: 6902, Severity: 21, State: 0 Page timestamp value falls between the old and new timestamps from log. Page #=4, object id = 1, page timestamp=0001 08afcb7d. Log: old 
       timestamp=0001 0000fb4e,   new timestamp=0001 08b00958.
  • Error: 602, Severity: 21, State: 3 Could not find row in Sysindexes for dbid '2', object '16003088', index 

          '0'.
    Run DBCC CHECKTABLE on Sysindexes. WARNING: Process being freed while holding Dataserver semaphore.
  • Udread: Operating system error 6(The handle is invalid.) on device 
       'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x0000099c).
  • Udread: Operating system error 6(The handle is invalid.) on device 
       'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00000564).
  • The computer running SQL Server stops responding.

WORKAROUND

To work around this problem, do either of the following:

  • Disable Insert Row Locking (IRL).
  • Set User Options to 0 (zero).

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

MORE INFORMATION

This problem only occurs when ROLLBACK is issued from a database other than the master.

Additional query words:
Keywords : kbbug6.50 kbfix6.50.sp2 kbnetwork SSrvTran_SQL
Version : 6.5
Platform : WINDOWS

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 9, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.