Skip to content

Instantly share code, notes, and snippets.

@kkurni
Created November 10, 2015 21:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kkurni/35f4309aba1fb55d41b3 to your computer and use it in GitHub Desktop.
Save kkurni/35f4309aba1fb55d41b3 to your computer and use it in GitHub Desktop.
01:01:19 - Execute Reader 1
01:01:19 - Execute Reader 2
01:01:49 - ERROR : System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 35 - An internal exception was caught) ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlConnection.cs:line 1848
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlInternalConnection.cs:line 786
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParser.cs:line 1436
at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParserStateObject.cs:line 1173
at System.Data.SqlClient.TdsParserStateObject.SNIWritePacket(SNIHandle handle, SNIPacket packet, UInt32& sniError, Boolean canAccumulate, Boolean callerHasConnectionLock) in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParserStateObject.cs:line 3805
at System.Data.SqlClient.TdsParserStateObject.SendAttention(Boolean mustTakeWriteLock) in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParserStateObject.cs:line 3870
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParserStateObject.cs:line 2918
at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParserStateObject.cs:line 2442
at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParserStateObject.cs:line 2337
at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParserStateObject.cs:line 1325
at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParserStateObject.cs:line 1576
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) in ...src\System.Data.SqlClient\System\Data\SqlClient\TdsParser.cs:line 2010
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlDataReader.cs:line 1334
at System.Data.SqlClient.SqlDataReader.get_MetaData() in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlDataReader.cs:line 279
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlCommand.cs:line 4075
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlCommand.cs:line 3861
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlCommand.cs:line 3562
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlCommand.cs:line 3496
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlCommand.cs:line 2266
at System.Data.SqlClient.SqlCommand.ExecuteReader() in ...src\System.Data.SqlClient\System\Data\SqlClient\SqlCommand.cs:line 2188
at OLEDB.Test.Adapter.XUnitRunner.RunSqlTestSync() in ...\SystemData\functional\Mars\Mars.cs:line 49
ClientConnectionId:38ae233b-6011-4f26-8a93-e7b089d896a1
Error Number:-2,State:0,Class:11
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment