The Scheduler 0 appears to be hung.

The Scheduler 0 appears to be hung.

Post by Justi » Thu, 22 May 2003 23:17:46



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

 
 
 

The Scheduler 0 appears to be hung.

Post by Andrew J. Kell » Fri, 23 May 2003 02:58:53


Call MS PSS:

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..

2. ShowData Property

3. The Scheduler 0 appears to be hung

4. Access 97 Tabs Bug

5. Scheduler 0 appears to be hung

6. Tablespace Full

7. SQL Event 17052 SP3 Scheduler 0/1 appears to be hung

8. Concurrency Issue

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