jamesdow
asked on
IIS 6.0 Application Pools Hang at Random Intervals
I have a website that fails at random intervals. The development team thinks that issue is with the application pool hanging but everytime the site stops responding the app pool seems to be running and I get the following error in the event logs. The server is Windows 2003 SP2 running on VMWare ESX3.5 server attached to an EMC NS20 SAN. The server is up to date on patches. The SQL server is the same config running SQL 2000. Any insight would be greatly appreciated.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/7/2008 8:58:46 AM
Event time (UTC): 10/7/2008 12:58:46 PM
Event ID: 291e327915c34c58a96d4be300 2ddc09
Event sequence: 25
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1071726003/ROOT- 1-12867857 8159037282
Trust level: Full
Application Virtual Path: /
Application Path: D:\inetpub\wwwroot\www.corp.com\
Machine name: VP-WWW
Process information:
Process ID: 4768
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: InvalidOperationException
Exception message: There is already an open DataReader associated with this Command which must be closed first.
Request information:
Request URL: http://xxx.corp.com/showPage2Col.aspx?redir=sites
Request path: /showPage2Col.aspx
User host address: xxx.29.1.16
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 6
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlI nternalCon nectionTds .ValidateC onnectionF orExecute( SqlCommand command)
at System.Data.SqlClient.SqlC onnection. ValidateCo nnectionFo rExecute(S tring method, SqlCommand command)
at System.Data.SqlClient.SqlC ommand.Val idateComma nd(String method, Boolean async)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea der(Comman dBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea der(Comman dBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlC ommand.Exe cuteReader (CommandBe havior behavior, String method)
at System.Data.SqlClient.SqlC ommand.Exe cuteDbData Reader(Com mandBehavi or behavior)
at System.Data.Common.DbComma nd.System. Data.IDbCo mmand.Exec uteReader( CommandBeh avior behavior)
at System.Data.Common.DbDataA dapter.Fil lInternal( DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataA dapter.Fil l(DataTabl e[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataA dapter.Fil l(DataTabl e dataTable)
at clsModFunctions.ExecuteSQL (String sSQL, Boolean OptIsDev) in http://server//App_Code/clsModFunctions.vb:line 58
at userControls_uc2Col.Page_L oad(Object sender, EventArgs e) in http://server//userControls/uc2Col.ascx.vb:line 18
at System.Web.UI.Control.OnLo ad(EventAr gs e)
at System.Web.UI.Control.Load Recursive( )
at System.Web.UI.Control.Load Recursive( )
at System.Web.UI.Control.Load Recursive( )
at System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int, Boolean includeStagesAfterAsyncPoi nt)
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/7/2008 8:58:46 AM
Event time (UTC): 10/7/2008 12:58:46 PM
Event ID: 291e327915c34c58a96d4be300
Event sequence: 25
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1071726003/ROOT-
Trust level: Full
Application Virtual Path: /
Application Path: D:\inetpub\wwwroot\www.corp.com\
Machine name: VP-WWW
Process information:
Process ID: 4768
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: InvalidOperationException
Exception message: There is already an open DataReader associated with this Command which must be closed first.
Request information:
Request URL: http://xxx.corp.com/showPage2Col.aspx?redir=sites
Request path: /showPage2Col.aspx
User host address: xxx.29.1.16
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 6
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.Common.DbComma
at System.Data.Common.DbDataA
at System.Data.Common.DbDataA
at System.Data.Common.DbDataA
at clsModFunctions.ExecuteSQL
at userControls_uc2Col.Page_L
at System.Web.UI.Control.OnLo
at System.Web.UI.Control.Load
at System.Web.UI.Control.Load
at System.Web.UI.Control.Load
at System.Web.UI.Page.Process
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We were able to determine by the logs that there was an error with IIS and how it was installed that were causing the problems. Thanks for your help
https://www.experts-exchange.com/questions/20145612/Timeout.html
https://www.experts-exchange.com/questions/21053532/SQL-Timeout.html