FIX: Inserts on SMP Computer Can Cause Error Message 1203

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
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600 kbSQLServ420OS2


Last Reviewed: March 25, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.