ThreadAbortException
- From: Hans Reins <hans@xxxxxxxxx>
- Date: Mon, 30 May 2005 15:29:45 +0300
Hello,
recently I have encountered with the strange issue concerning ThreadAbortException that throws DbDataAdapter.Fill (see below the stacktrace [1]). At the first time I suppose that this problem due to Command.Timeout property that was set too small, but to tell the truth it has the maximum value - 65534 and this exception throws after 10-15 minutes of execution of Stored Procedure.
Also I've noticed that the problem completely relates to SQL server when it was really loaded (about 99% of processor usage). So my question is how can I detect what causes this exception (and how to prevent it) - if it is SQL server, is it possible to modify properties of SP execution timeout or something?
All kind of information would be really helpful.
Thanks!
[1] Stacktrace:
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
.
- Prev by Date: RE: How to continue request execution in a HttpHandler
- Next by Date: UserControl render html in server side
- Previous by thread: e.item.cells and paged datagrid
- Next by thread: UserControl render html in server side
- Index(es):
Relevant Pages
|
