by Justi » Thu, 22 May 2003 23:17:46
Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 6, ECID 0, UMS
Context 0x03C82F98
http://support.microsoft.com/search/default.aspx?
Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%
3DON&Product=&KeywordType=any&Titles=false&numDays=&maxResu
lts=25&withinResults=&Queryl=Error+17883&Query=Error+17883&
QuerySource=gsfxSearch_Query
by Andrew J. Kell » Fri, 23 May 2003 02:58:53
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly
SQL Server MVP
Quote:> I need to get a HotFix for this error:
> Error: 17883, Severity: 1, State: 0
> The Scheduler 0 appears to be hung. SPID 6, ECID 0, UMS
> Context 0x03C82F98
> http://support.microsoft.com/search/default.aspx?
> Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%
> 3DON&Product=&KeywordType=any&Titles=false&numDays=&maxResu
> lts=25&withinResults=&Queryl=Error+17883&Query=Error+17883&
> QuerySource=gsfxSearch_Query
1. The Scheduler appears to be hung
We received the error messages listed below just before
the SQL Server process shutdown and it failed over to the
backup node. Then it happened again about one hour and a
half later. The system failed back to the original node.
Does anyone have any suggestions about how to determine
what may be hanging the scheduler? The condition appears
to have stopped all disk read/writes from the SQL Server
engine to the shared disk volumes. We have SQL7 with SP4
applied.
The Scheduler 2 appears to be hung. PSS 0x21E5F0E0, EC
0x21E5F290, UMS Context 0x0164AEB0
Error: 823, Severity: 24, State: 1
I/O error 21(The device is not ready.) detected during
read of BUF pointer = 0x29a4f00, page ptr = 0xc2e8000,
pageid = (0x6:0xb0766), dbid = 9, status = 0x801, file =
u:\mssql7\data\CCR_Index1.ndf..
Error: 823, Severity: 24, State: 10
I/O error 21(The device is not ready.) detected during
read of page buffer..
3. The Scheduler 0 appears to be hung
5. Scheduler 0 appears to be hung
7. SQL Event 17052 SP3 Scheduler 0/1 appears to be hung
9. Scheduler 0 appears to be hung
10. I am looking for an automation/scheduler for VFP 3.0
11. Hung Scheduler Error: 17883
12. It appears that I am not recieving the latest posts
13. job hangs when run from AT scheduler