BUG: Table Creation Deadlocks in Tempdb Leave Stray Tables |
Q151304
When a client repeatedly runs a stored procedure that creates tables in
tempdb, and deadlocks are encountered on the tempdb system tables, the temp
tables will not always be cleaned up when the stored procedure terminates
(nor when the client disconnects).
This happens only on multiprocessor computers, but was replicated with SQL
Server version 4.21a SP4 as well as 6.0 on Alpha, MIPS, and Intel
computers. The problem also happens with both Windows NT 3.5 and 3.51, but
was not replicated on any uniprocessor computer.
To avoid deadlock, trace flag 1204 should be used to detect and analyze the
cause of deadlock condition.
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Microsoft SQL Server version 6.5.
Additional query words: deadlock
Keywords : kbprogramming kbSQLServ650fix
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: February 17, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |