|
Home > Archive > MS SQL Server > February 2006 > Error Message 17883 (Scheduler 5 appears to be hung)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error Message 17883 (Scheduler 5 appears to be hung)
|
|
| soonyu 2006-02-06, 3:23 am |
| we have this problem
1. whereby sql transaction is blocked by spid -2
2. check the error log it dump mini dump at 4.00am
3. error log repeat with
The Scheduler 5 appears to be hung. SPID 102, ECID 0, UMS Context 0x03ADD340.
Error: 17883, Severity: 1, State: 0
3. blocking happen at 10.00am
4. kill the spid id with -2, can't
5. restart sql server and sqlserver resume.
Any idea what happen?
| |
| Sreejith G 2006-02-06, 9:23 am |
| Its known bug...
http://support.microsoft.com/kb/835581
RESOLUTION:
Service pack information
To resolve this problem, obtain the latest service pack for SQL Server 2000.
Thanks,
Sree
"soonyu" wrote:
> we have this problem
> 1. whereby sql transaction is blocked by spid -2
> 2. check the error log it dump mini dump at 4.00am
> 3. error log repeat with
> The Scheduler 5 appears to be hung. SPID 102, ECID 0, UMS Context 0x03ADD340.
> Error: 17883, Severity: 1, State: 0
>
> 3. blocking happen at 10.00am
> 4. kill the spid id with -2, can't
> 5. restart sql server and sqlserver resume.
>
> Any idea what happen?
>
>
|
|
|
|
|