Microsoft KB Archive/141539

{|
 * width="100%"|

FIX: Inserts on SMP Computer Can Cause Error Message 1203

 * }

Q141539

-

The information in this article applies to:


 * Microsoft SQL Server versions 4.2x, 6.0

-

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