Re: Windows 2003 hangs with Jet Engine

From: Kristofer Gafvert (kgafvert_at_NEWSilopia.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 10:03:59 +0200

Send it to microsoft.public.inetserver.iis instead. The people analyzing
this is in that newsgroup. 

-- 
Regards,
Kristofer Gafvert
"David" <david_eastes@yahoo.com> wrote in message
news:DB836D0B-FA02-44B8-9FCC-78F46BCA2FC7@microsoft.com...
> Hi...My bank website on a newly setup Windows 2003 server are hanging.  It
uses a Microsoft Access database.  In my research, I noticed that the Jet
Engine bug might be the problem.  So I verified I was updated on my hotfixes
and installed IISState to catch information on the next hang.  I'm there.
>
> Here is the history.  I recently migrated my ASP-based website from
Windows 2000 server to Windows 2003 server.  My website uses an Access
database to generate the menus and then log a timestamp when the user
authenticates.  I have noticed since the upgrade the website will hang and
not serve any more pages.  Recycling worker processes doesn't help. The only
thing that does help is rebooting.  I reduced the value for cycling worker
processes so that it cycles more frequently.  Now it only hangs once every
two weeks.
>
> I installed IISState on the server and captured three dump files and one
log file during one incident.  There is a lot of information in the log.
Below are the values from two of the threads.  I can send others upon
request.  I read that this might be a known bug with Windows 2003 server and
Jet Engine.  The server is running Windows 2003 Server Standard Edition and
Hotix for KB829558 (Jet Engine 4 SP8).  There are other Hotfixes installed.
>
> Any help would be appreciated.  Thank you.
>
> Dave
>
>
> Thread ID: 14
> System Thread ID: b10
> Kernel Time: 0:0:1.281
> User Time: 0:0:0.828
> Other information: Thread is waiting for a lock to be released.  Looking
for lock owner.
> Owning thread System ID: b84
> Thread Type: Jet DB Query. Possible ASP Page
>
>  # ChildEBP RetAddr
> 00 025cc934 77f43741 SharedUserData!SystemCallStub+0x4
> 01 025cc938 77f5d64e ntdll!ZwWaitForSingleObject+0xc
> 02 025cc974 77f42044 ntdll!RtlpWaitForCriticalSection+0x126
> 03 025cc97c 1b005744 ntdll!RtlEnterCriticalSection+0x46
> 04 025cc984 1b00a109 msjet40!UtilEnterCriticalSection+0xb
> 05 025cc99c 02d3693a msjet40!JetSetSystemParameter+0x2f
> 06 025cce74 02d375ec odbcjt32!TellJetAboutRegistry+0xf7
> 07 025cdfd8 02d38da4 odbcjt32!SQLConnectCover+0x395
> 08 025ce00c 02ad1c0f odbcjt32!SQLDriverConnectW+0x3d
> 09 025ce050 02ad18cb ODBC32!SQLInternalDriverConnectW+0x142
> 0a 025ce794 02a82049 ODBC32!SQLDriverConnectW+0x6ba
> 0b 025ce7fc 02a821d0 msdasql!CODBCHandle::OHDriverConnect+0x80
> 0c 025ce81c 02a82313 msdasql!CHdbcNode::DriverConnect+0x20
> 0d 025ce860 029e4602 msdasql!CImpIDBInitialize::Initialize+0x161
> 0e 025ce88c 029e46a3 oledb32!CDBInitialize::DoInitialize+0x32
> 0f 025ce8bc 029e2d75 oledb32!CDBInitialize::Initialize+0x58
> 10 025ce968 755f5681 oledb32!CDCMPool::CreateResource+0x1fa
> 11 025ce9a4 755f67cf
comsvcs!CHolder::SafeDispenserDriver::CreateResource+0x25
> 12 025cea00 029e3319 comsvcs!CHolder::AllocResource+0x325
> 13 025cea50 029e4748 oledb32!CDCMPool::DrawResource+0x9d
> 14 025ceaa8 029e320e oledb32!CDCMPoolManager::DrawResource+0x185
> 15 025ceb08 026a6a9b oledb32!CDPO::Initialize+0x136
> 16 025cec08 026a6c37 msado15!_ConnectAsync+0x1da
> 17 025cec18 026a694e msado15!ConnectAsync+0x1f
> 18 025ced88 026f2b71 msado15!CConnection::Open+0xa26
> 19 025cede0 026d102e msado15!CRecordset::SetActiveConnection+0x191
> 1a 025cee18 026d0c94 msado15!CRecordset::put_ActiveConnection+0x5f
> 1b 025cef90 026c0bd9 msado15!CRecordset::Open+0x2af
> 1c 025cf3dc 7348b427 msado15!CRecordset::Invoke+0x12ff
> 1d 025cf430 7347f39c vbscript!CatchIDispatchInvoke+0x46
> 1e 025cf47c 7346368c vbscript!IDispatchInvoke+0x95
> 1f 025cf590 73462f95 vbscript!InvokeDispatch+0x138
> 20 025cf5b4 734635ef vbscript!InvokeByName+0x40
> 21 025cf890 73463c33 vbscript!CScriptRuntime::Run+0x2625
> 22 025cf994 73463d42 vbscript!CScriptEntryPoint::Call+0x65
> 23 025cf9f8 73464081 vbscript!CSession::Execute+0xb6
> 24 025cfa48 734640ee vbscript!COleScript::ExecutePendingScripts+0x14a
> 25 025cfa64 709e5e87 vbscript!COleScript::SetScriptState+0x14e
> 26 025cfa90 709e5ee1 asp!CActiveScriptEngine::TryCall+0x17
> 27 025cfacc 709e5f21 asp!CActiveScriptEngine::Call+0x31
> 28 025cfae0 709e6227 asp!CallScriptFunctionOfEngine+0x21
> 29 025cfb18 709e6393 asp!ExecuteRequest+0x138
> 2a 025cfb60 709e5573 asp!Execute+0x16a
> 2b 025cfbb0 709e5726 asp!CHitObj::ViperAsyncCallback+0x3ec
> 2c 025cfbd0 75613d0c asp!CViperAsyncRequest::OnCall+0x8c
> 2d 025cfbec 77204123 comsvcs!CSTAActivityWork::STAActivityWorkHelper+0x30
> 2e 025cfc38 77204873 ole32!EnterForCallback+0xc0
> 2f 025cfd98 771e024b ole32!SwitchForCallback+0x1a2
> 30 025cfdc4 771d3a0c ole32!PerformCallback+0x52
> 31 025cfe48 77206e70 ole32!CObjectContext::InternalContextCallback+0x140
>
> Thread ID: 15
> System Thread ID: b84
> Kernel Time: 0:0:1.640
> User Time: 0:0:1.93
> Thread Type: Jet DB Query. Possible ASP Page
>
>  # ChildEBP RetAddr
> 00 0260ddd4 77f43741 SharedUserData!SystemCallStub+0x4
> 01 0260ddd8 77e41817 ntdll!ZwWaitForSingleObject+0xc
> 02 0260de48 77e4168f kernel32!WaitForSingleObjectEx+0xac
> 03 0260de58 1b10fb3c kernel32!WaitForSingleObject+0xf
> 04 0260dfa0 1b03a62e msjet40!PostCOMCallThreadRequest+0xd8
> 05 0260dfec 1b039e5e msjet40!InitES+0x79
> 06 0260e000 1b039bf0 msjet40!GetNewESInstance+0x15
> 07 0260e00c 1b0399f3 msjet40!GetESInstanceFromItib+0x42
> 08 0260e018 1b031d52 msjet40!HtteParseExprI+0x13
> 09 0260e4a4 1b03186f msjet40!ErrQodefCheckRow+0x571
> 0a 0260e4bc 1b03135f msjet40!ErrQodefInsertEither+0x13
> 0b 0260e4dc 1b02202a msjet40!ErrQodefUpdate+0x3a
> 0c 0260e4f8 1b03072f msjet40!ErrDispUpdate+0x4b
> 0d 0260e72c 1b039def msjet40!InsertQoa+0x2e8
> 0e 0260e74c 1b035a20 msjet40!TknParseWhereHaving+0x6f
> 0f 0260e770 1b0351f8 msjet40!TknParseFrom+0x32
> 10 0260e7a0 1b034158 msjet40!TknParseSelect+0x485
> 11 0260e82c 1b02a177 msjet40!ErrParseQuery+0x262
> 12 0260e8a8 1b04ca75 msjet40!ErrSQLSetQoSql+0x46f
> 13 0260e8e0 02d4a598 msjet40!JetSetQoSql+0xa2
> 14 0260e910 02d4982e odbcjt32!SQLPrepareCover+0x27c
> 15 0260e928 02d497d7 odbcjt32!SQLExecDirectCover+0x54
> 16 0260e938 02ad694e odbcjt32!SQLExecDirectW+0x11
> 17 0260e958 02ad6a46 ODBC32!SQLExecute+0x2a4
> 18 0260e978 02a8bfac ODBC32!SQLExecDirectW+0x5b
> 19 0260e9a0 02a87537 msdasql!CImpICommandText::ExecuteHelper+0xf8
> 1a 0260ea60 026b7455 msdasql!CImpICommandText::Execute+0x635
> 1b 0260eaa0 026a9da8 msado15!CConnection::Execute+0x1a3
> 1c 0260ec60 026a9c47 msado15!_ExecuteAsync+0x17e
> 1d 0260ec70 026a99ee msado15!ExecuteAsync+0x1f
> 1e 0260ed3c 026a9bee msado15!CQuery::Execute+0xa25
> 1f 0260ed9c 026a4854 msado15!CCommand::_Execute+0x147
> 20 0260ee24 026a4b39 msado15!CRecordset::_Open+0x2fb
> 21 0260ef90 026c0bd9 msado15!CRecordset::Open+0x5c3
> 22 0260f3dc 7348b427 msado15!CRecordset::Invoke+0x12ff
> 23 0260f430 7347f39c vbscript!CatchIDispatchInvoke+0x46
> 24 0260f47c 7346368c vbscript!IDispatchInvoke+0x95
> 25 0260f590 73462f95 vbscript!InvokeDispatch+0x138
> 26 0260f5b4 734635ef vbscript!InvokeByName+0x40
> 27 0260f890 73463c33 vbscript!CScriptRuntime::Run+0x2625
> 28 0260f994 73463d42 vbscript!CScriptEntryPoint::Call+0x65
> 29 0260f9f8 73464081 vbscript!CSession::Execute+0xb6
> 2a 0260fa48 734640ee vbscript!COleScript::ExecutePendingScripts+0x14a
> 2b 0260fa64 709e5e87 vbscript!COleScript::SetScriptState+0x14e
> 2c 0260fa90 709e5ee1 asp!CActiveScriptEngine::TryCall+0x17
> 2d 0260facc 709e5f21 asp!CActiveScriptEngine::Call+0x31
> 2e 0260fae0 709e6227 asp!CallScriptFunctionOfEngine+0x21
> 2f 0260fb18 709e6393 asp!ExecuteRequest+0x138
> 30 0260fb60 709e5573 asp!Execute+0x16a
> 31 0260fbb0 709e5726 asp!CHitObj::ViperAsyncCallback+0x3ec
>

Relevant Pages

  • Re: A VERY Strange Question.
    ... in windows you have a generic application that handles various pluggable configuration GUIs. ... > Dell offers many of thier server with "MS Server 2003" pre loaded. ... IIS for web serving ... Sharepoint services is more like a collaboration website where a team of people can oganize their work ...
    (freebsd-questions)
  • Re: setting up DNS DC AD on windows 2008
    ... You want to avoid setting up a dns domain name for AD the same as your ... Have an external website hosting your website and all users who need to be ... I have been trying hard to set up my own DNS on windows 2008 server. ...
    (microsoft.public.windows.server.active_directory)
  • Asyncronous operation
    ... I've developed a ASP.NET website which is running on a Windows 2003 Server ... I need to be able to run an asynchronous task that checks a POP3 ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Should I disable port 137?
    ... evil-minded loser defaced your website. ... Windows NT Server. ... >came with XP Professional which once again provides poor ...
    (microsoft.public.security)
  • SecurityFocus Microsoft Newsletter #154
    ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
    (Focus-Microsoft)