FIX: Inserts on SMP Computer Can Cause Error Message 1203

ID: Q141539

The information in this article applies to:
BUG# NT: 11223 (6.00)

SYMPTOMS

If a table has a non-unique clustered index and is running on a multiprocessor computer with SMP support on, INSERTs can cause the following 1203 error message to occur:

Msg 1203 Level 20 State 1
Caller of lock manager is incorrectly trying to unlock an unlocked
object. spid=%d locktype=%d dbid=%d lockid=%ld.


WORKAROUND

There are several options available to avoid this problem, including:

  1. Turn off dedicated multiprocessor support to allow the INSERT to complete.


  2. Replace the clustered index on the problem table with a nonclustered index.


  3. Make the non-unique clustered index into a unique clustered index.



STATUS

Microsoft has confirmed this to be a problem in SQL Server versions 4.21a and 6.0. This problem was corrected in Service Pack 2 for SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 smp winnt 


Keywords          : kbenv SSrvGen SSrvProg kbbug4.21a kbbug6.00 kbfix6.00.sp2 
Version           : 4.21a 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 23, 1999