Microsoft KB Archive/154047

= FIX: SQL Terminates on Delete Table with 15 Self-References =

Article ID: 154047

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q154047





SYMPTOMS
Trying to delete a table that contains 15 self-references can cause the system to return the following errors and warnings:

Error : 1202, Severity: 20, State: 2

Table_lock was called with illegal mode 0.

WARNING: Process being freed while holding Dataserver semaphore

udwritem: Operating system error 6(The handle is invalid.) on device

'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00002739).

udread: Operating system error 6(The handle is invalid.) on device

'C:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00000394).

Error: 5157, Severity: 20, State: 0

Recursive error 1202 in ex_print

This action also results in an unhandled exception, essentially terminating the server.



WORKAROUND
The workaround for this problem is to avoid having more than 14 self- references on a table. Establish another table that can contain the additional required references.



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 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.



MORE INFORMATION
This problem is specific to 15 self-references and hence is extremely uncommon.

NOTE: If a default debugger is set up, it will generate a debug log (like Dr. Watson log).

Additional query words: server dies foreign key dri

Keywords: kbbug kbfix KB154047

-

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

© Microsoft Corporation. All rights reserved.