We are running SQL 7 with SP2. Recently, we encountered couples of deadlock situation that a process holding an exclusive lock on an unknown resource was blocked by the process which was trying to perform a checkpoint.
Spid 27 5
Status Sleeping Running
Command Insert Backup Log
Blocked 5 0
Waittype 0x000E 0x0000
WaitResource UNK:2:2:0:d
Lastwaittype LCK_M_X MISCELLANEOUS
The deadlock didn't resolve itself and we have to shut down the server using SHUTDOWN WITH NOWAIT.
Can anyone explain what is happening here?
Does the waitresource UNK:2:2:0:d mean TempDB?
Is this a bug with SQL 7?
Spid 27 5
Status Sleeping Running
Command Insert Backup Log
Blocked 5 0
Waittype 0x000E 0x0000
WaitResource UNK:2:2:0:d
Lastwaittype LCK_M_X MISCELLANEOUS
The deadlock didn't resolve itself and we have to shut down the server using SHUTDOWN WITH NOWAIT.
Can anyone explain what is happening here?
Does the waitresource UNK:2:2:0:d mean TempDB?
Is this a bug with SQL 7?