| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-13 : 07:38:12
|
| Tommy writes "We have SQL Server 2000 SP4 (8.00.2040) running on Windows 2003 64 bit edition, and we are getting an error almost every other day in the SQL Server logs. This is causing the job that runs during this time to run 35-50 minutes instead of the 5-8 minutes it runs when the error does not happen.Here is the error message:Process 139:0 (17ec) UMS Context 0x0D2E5BE8 appears to be non-yielding on Scheduler 4.Error: 17883, Severity: 1, State: 0The error repeats several times, usually about 1 minute apart.I looked in the Microsoft Knowledgebase, and it appears this error was fixed in SP4, but obviously, it's still happening. Anyone still getting 17883 on SP4?" |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-12-15 : 09:49:34
|
| There are still some of these in SP4. Look at your MSSQL\LOG directory. You will likely see a .DMP or a .MDMP file. This is a mini-dump or full dump of the memory stack. You will want to send this off to Microsoft Support. In my experience, they will tell you that your query is the issue, and suggest that you tune your query, but after spending a lot of time on the phone, they agreed that it was a bug in the product. The scheduler, while it is co-operative, it should relinquish resources eventually, which it didn't do here.HTHJon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-12-15 : 19:47:58
|
| Do you know the name/email of the person that argued with you? 17883s are nearly always scheduling/yielding bugs in SQL Server, regardless of what you're doing.ThanksPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
gcarlier
Starting Member
1 Post |
Posted - 2006-01-11 : 04:47:47
|
| Hi Paul,We are also running MSSQL 2000 with sp4 and getting the 17883s with the scheduler errors. I have checked the following article http://support.microsoft.com/kb/894905/ but there is no mention of 17883s in it. Could you please let us know what we should do to fix the problem(s)?Regards,Gael |
|
|
|
mherfkens
Starting Member
8 Posts |
Posted - 2006-02-01 : 11:00:21
|
| I am experiencing the same problem. I am getting 17883 errors and unyielding sheduler processes. This is on a SQL2K DB with SP4 installed. It sits on a Win2003 server with 8 CPUs and 8GB RAM. The error is somewhat sporadic but appears that it might be related to the load the server is under. The database data files reside on a high-end HP SAN that is fiber connected. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-02-01 : 11:15:57
|
| There's a few of these fixed in hotfix 2162, are you running that?-------Moo. :) |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2006-02-01 : 12:47:36
|
| Please note that build 2162 has been pulled from the web due to some issues with itThis download has been removed temporarily due to two problems discovered in this build:1. The SQL Server 2000 hotfix installer does not work correctly on a cluster installation. 2. When you use the BULK INSERT command, you may experience a 1203 error or an exception error. This download will be replaced when this problem is resolved. If you are already using build 2162 and you are experiencing these problems, contact Microsoft Product Support.HTHJasper Smith |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-02-02 : 04:05:15
|
quote:
Originally posted by jasper_smith
Please note that build 2162 has been pulled from the web due to some issues with it
Oh dear. SP4 is turning into a bit of a beast.-------Moo. :) |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-07-18 : 03:42:44
|
How about if the system is sql2k5 on win2k3 cluster?we've recently encountered this error and it was chaoticI had a not-so-good experience with PS (still waiting for our 3 month ticket to get a solution) so I'm very very hesitant to contact them at this point.TIAquote:
Originally posted by franco
There is a new FIX for event ID 17883,please refer to:http://support.microsoft.com/kb/909734/en-usFranco
--------------------keeping it simple... |
|
|
|
|
Getting Error 17883 on SQL Server 2000 SP4 (8.00.2040)