Microsoft KB Archive/158463

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

Article ID: 158463

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q158463



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.

Keywords: kbbug kbfix kbnetwork KB158463

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.