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

• Microsoft SQL Server version 6.5

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          : kbnetwork SSrvTran_SQL kbbug6.50 kbfix6.50.sp2 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 4, 1999