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:
- Turn off dedicated multiprocessor support to allow the INSERT to complete.
- Replace the clustered index on the problem table with a nonclustered index.
- 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 |