pitster
asked on
Event 1309, ASP.NET 4.0.30319.0 - SQLException
I have a 2008 R2 Standard server running IIS. All of a sudden, one of our websites has intermittently stopped working. One moment, everything is working fine, another moment, you try to go to a page and you get:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/15/2014 10:56:43 AM
Event time (UTC): 1/15/2014 3:56:43 PM
Event ID: 7bb0e98b384342bfa73eb0d9a9 6a28fe
Event sequence: 1824
Event occurrence: 9
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/Tracker3- 1-13034266 7892637656
Trust level: Full
Application Virtual Path: /Tracker3
Application Path: C:\Program Files\Tracker.Net 3\Tracker3\
Machine name: INTRANET
Process information:
Process ID: 5896
Process name: w3wp.exe
Account name: IIS APPPOOL\Framework_4_Classi c_x86
Exception information:
Exception type: SqlException
Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsP arser.TryR un(RunBeha vior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlC ommand.Fin ishExecute Reader(Sql DataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea derTds(Com mandBehavi or cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea der(Comman dBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlC ommand.Int ernalExecu teNonQuery (TaskCompl etionSourc e`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlC ommand.Exe cuteNonQue ry()
at VBTrain.WebTracking.Tracke r3._defaul t.UpdateDa teRelatedL essonStatu ses() in C:\2010Projects\LMS\Tracke r.Net 3\LMSTracker3\default.aspx .vb:line 315
at VBTrain.WebTracking.Tracke r3._defaul t.Page_Loa d(Object sender, EventArgs e) in C:\2010Projects\LMS\Tracke r.Net 3\LMSTracker3\default.aspx .vb:line 109
at System.Web.UI.Control.OnLo ad(EventAr gs e)
at System.Web.UI.Control.Load Recursive( )
at System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int, Boolean includeStagesAfterAsyncPoi nt)
The wait operation timed out
Request information:
Request URL: http://intranet/Tracker3/default.aspx?ReturnUrl=/Tracker3/LMSCourseList.aspx
Request path: /Tracker3/default.aspx
User host address: 10.42.0.135
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOL\Framework_4_Classi c_x86
Thread information:
Thread ID: 21
Thread account name: IIS APPPOOL\Framework_4_Classi c_x86
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsP arser.TryR un(RunBeha vior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlC ommand.Fin ishExecute Reader(Sql DataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea derTds(Com mandBehavi or cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea der(Comman dBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlC ommand.Int ernalExecu teNonQuery (TaskCompl etionSourc e`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlC ommand.Exe cuteNonQue ry()
at VBTrain.WebTracking.Tracke r3._defaul t.UpdateDa teRelatedL essonStatu ses() in C:\2010Projects\LMS\Tracke r.Net 3\LMSTracker3\default.aspx .vb:line 315
at VBTrain.WebTracking.Tracke r3._defaul t.Page_Loa d(Object sender, EventArgs e) in C:\2010Projects\LMS\Tracke r.Net 3\LMSTracker3\default.aspx .vb:line 109
at System.Web.UI.Control.OnLo ad(EventAr gs e)
at System.Web.UI.Control.Load Recursive( )
at System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int, Boolean includeStagesAfterAsyncPoi nt)
Custom event details:
The solution is to simply recycle the Framework_4_Classic_x86 app pool, but my question is why does this keep happening. Recycling the app pool is a band-aid and I am looking for the fix so this doesn't happen. Any help is greatly appreciated.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/15/2014 10:56:43 AM
Event time (UTC): 1/15/2014 3:56:43 PM
Event ID: 7bb0e98b384342bfa73eb0d9a9
Event sequence: 1824
Event occurrence: 9
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/Tracker3-
Trust level: Full
Application Virtual Path: /Tracker3
Application Path: C:\Program Files\Tracker.Net 3\Tracker3\
Machine name: INTRANET
Process information:
Process ID: 5896
Process name: w3wp.exe
Account name: IIS APPPOOL\Framework_4_Classi
Exception information:
Exception type: SqlException
Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
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 VBTrain.WebTracking.Tracke
at VBTrain.WebTracking.Tracke
at System.Web.UI.Control.OnLo
at System.Web.UI.Control.Load
at System.Web.UI.Page.Process
The wait operation timed out
Request information:
Request URL: http://intranet/Tracker3/default.aspx?ReturnUrl=/Tracker3/LMSCourseList.aspx
Request path: /Tracker3/default.aspx
User host address: 10.42.0.135
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOL\Framework_4_Classi
Thread information:
Thread ID: 21
Thread account name: IIS APPPOOL\Framework_4_Classi
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
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 VBTrain.WebTracking.Tracke
at VBTrain.WebTracking.Tracke
at System.Web.UI.Control.OnLo
at System.Web.UI.Control.Load
at System.Web.UI.Page.Process
Custom event details:
The solution is to simply recycle the Framework_4_Classic_x86 app pool, but my question is why does this keep happening. Recycling the app pool is a band-aid and I am looking for the fix so this doesn't happen. Any help is greatly appreciated.
You will need to investigate on the SQL server box, run a trace on the SQL server, you will be able to tell if possibly there is locking, long running queries etc, missing indexes, other things like SQL environment - how busy is the site compared to number of CPUs and ram on the box etc has someone set the max memory to 100 mb etc
ASKER
Thanks everyone. I am forwarding these posts on to my SQL team. Hope to hear back soon with some relevant information for an update.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Issue ended up being a secondary system affecting this primary system
Check to see that the applcation is running in Release mode, not debug mode. In Debug mode the connection pooling doesn't work.
A thing you can do to monitor is running the following query to see the connections:
Open in new window
database Id you find by following query
Open in new window
Replace "youdatabaseName" with the databasename you have
What also could be is that you have queries that take too long to answer. Maybe looking into a large table?
These are not really concrete solutions to your issue but hope it will help.