FIX: ROLLBACK Causes Errs 6902, 602, OS Error 6, or Handled AV (158463)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix kbnetwork KB158463 |
|---|
|