Skip to content

Instantly share code, notes, and snippets.

@warrenbuckley
Created March 14, 2015 20:02
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 warrenbuckley/7498daadb52f9e8c65c1 to your computer and use it in GitHub Desktop.
Save warrenbuckley/7498daadb52f9e8c65c1 to your computer and use it in GitHub Desktop.
SQL Azure - Y U SO FLAKY!!
[03/14/2015 20:00:25 > 73746b: INFO] Try and get 'videos' doctype
[03/14/2015 20:00:55 > 73746b: INFO] Exception Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
[03/14/2015 20:00:55 > 73746b: INFO] Exception Source: .Net SqlClient Data Provider
[03/14/2015 20:00:55 > 73746b: INFO] Exception StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlDataReader.get_MetaData()
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
[03/14/2015 20:00:55 > 73746b: INFO] at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 235
[03/14/2015 20:00:55 > 73746b: INFO] at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3()
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy retryPolicy)
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command)
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()
[03/14/2015 20:00:55 > 73746b: ERR ]
[03/14/2015 20:00:55 > 73746b: INFO] at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
[03/14/2015 20:00:55 > 73746b: INFO] at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
ired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.Database.Fetch[T1,T2,T3](Sql sql)
[03/14/2015 20:00:55 > 73746b: ERR ] --- End of inner exception stack trace ---
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.Repositories.ContentTypeRepository.PerformGetByQuery(IQuery`1 query)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Persistence.Repositories.RepositoryBase`2.GetByQuery(IQuery`1 query)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
[03/14/2015 20:00:55 > 73746b: INFO] at Umbraco.Core.Services.ContentTypeService.GetContentType(String alias)
[03/14/2015 20:00:55 > 73746b: INFO] at uHangout.WebJob.Program.ImportVideos(IList`1 videos)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlDataReader.get_MetaData()
[03/14/2015 20:00:55 > 73746b: INFO] Inner Exception Source:
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
[03/14/2015 20:00:55 > 73746b: INFO] Inner Exception StackTrace:
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
[03/14/2015 20:00:55 > 73746b: ERR ] at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 235
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3()
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy retryPolicy)
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command)
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
[03/14/2015 20:00:55 > 73746b: ERR ] at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.Database.Fetch[T1,T2,T3](Sql sql)
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.Repositories.ContentTypeRepository.PerformGetByQuery(IQuery`1 query)
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Persistence.Repositories.RepositoryBase`2.GetByQuery(IQuery`1 query)
[03/14/2015 20:00:55 > 73746b: ERR ] at Umbraco.Core.Services.ContentTypeService.GetContentType(String alias)
[03/14/2015 20:00:55 > 73746b: ERR ] at uHangout.WebJob.Program.ImportVideos(IList`1 videos)
[03/14/2015 20:00:55 > 73746b: ERR ] at uHangout.WebJob.Program.Main()
[03/14/2015 20:00:55 > 73746b: SYS INFO] Status changed to Failed
[03/14/2015 20:00:55 > 73746b: SYS ERR ] Job failed due to exit code -532462766
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment