API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 20th, 2019
118
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.40 KB | None | 0 0
raw download clone embed print report
  1. dType='Text', CommandTimeout='30']
  2. SELECT `x.AfterImage`.`Id`, `x.AfterImage`.`Data`, `x.BeforeImage`.`Id`, `x.BeforeImage`.`Data`, `x.DifferenceImage`.`Id`, `x.DifferenceImage`.`Data`, @__differ_3, @__before_4
  3. FROM `MapDiffs` AS `x`
  4. LEFT JOIN `Images` AS `x.AfterImage` ON `x`.`AfterImageId` = `x.AfterImage`.`Id`
  5. LEFT JOIN `Images` AS `x.BeforeImage` ON `x`.`BeforeImageId` = `x.BeforeImage`.`Id`
  6. LEFT JOIN `Images` AS `x.DifferenceImage` ON `x`.`DifferenceImageId` = `x.DifferenceImage`.`Id`
  7. WHERE ((`x`.`InstallationRepositoryId` = @__repositoryId_0) AND (`x`.`CheckRunId` = @__checkRunId_1)) AND (`x`.`FileId` = @__fileId_2)
  8. LIMIT 1
  9. info: Microsoft.EntityFrameworkCore.Database.Command[20101]
  10. Executed DbCommand (1ms) [Parameters=[@__differ_3='?' (DbType = Boolean), @__before_4='?' (DbType = Boolean), @__repositoryId_0='?' (DbType = Int64), @__checkRunId_1='?' (DbType = Int64), @__fileId_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
  11. SELECT `x.AfterImage`.`Id`, `x.AfterImage`.`Data`, `x.BeforeImage`.`Id`, `x.BeforeImage`.`Data`, `x.DifferenceImage`.`Id`, `x.DifferenceImage`.`Data`, @__differ_3, @__before_4
  12. FROM `MapDiffs` AS `x`
  13. LEFT JOIN `Images` AS `x.AfterImage` ON `x`.`AfterImageId` = `x.AfterImage`.`Id`
  14. LEFT JOIN `Images` AS `x.BeforeImage` ON `x`.`BeforeImageId` = `x.BeforeImage`.`Id`
  15. LEFT JOIN `Images` AS `x.DifferenceImage` ON `x`.`DifferenceImageId` = `x.DifferenceImage`.`Id`
  16. WHERE ((`x`.`InstallationRepositoryId` = @__repositoryId_0) AND (`x`.`CheckRunId` = @__checkRunId_1)) AND (`x`.`FileId` = @__fileId_2)
  17. LIMIT 1
  18. dbug: Microsoft.EntityFrameworkCore.Database.Command[20300]
  19. A data reader was disposed.
  20. dbug: Microsoft.EntityFrameworkCore.Database.Connection[20002]
  21. Closing connection to database 'ss13_map_diff_bot' on server 'localhost'.
  22. dbug: Microsoft.EntityFrameworkCore.Database.Connection[20003]
  23. Closed connection to database 'ss13_map_diff_bot' on server 'localhost'.
  24. fail: Microsoft.EntityFrameworkCore.Query[10100]
  25. An exception occurred while iterating over the results of a query for context type 'MapDiffBot.Models.DatabaseContext'.
  26. System.NullReferenceException: Object reference not set to an instance of an object.
  27. at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
  28. at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
  29. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
  30. at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  31. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
  32. at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable`1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
  33. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.MoveNext(CancellationToken cancellationToken)
  34. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
  35. System.NullReferenceException: Object reference not set to an instance of an object.
  36. at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
  37. at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
  38. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
  39. at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  40. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
  41. at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable`1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
  42. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.MoveNext(CancellationToken cancellationToken)
  43. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
  44. fail: Microsoft.EntityFrameworkCore.Query[10100]
  45. An exception occurred while iterating over the results of a query for context type 'MapDiffBot.Models.DatabaseContext'.
  46. System.NullReferenceException: Object reference not set to an instance of an object.
  47. at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
  48. at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
  49. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
  50. at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  51. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
  52. at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable`1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
  53. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.MoveNext(CancellationToken cancellationToken)
  54. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
  55. at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteSingletonAsyncQuery[TResult](QueryContext queryContext, Func`2 compiledQuery, IDiagnosticsLogger`1 logger, Type contextType)
  56. System.NullReferenceException: Object reference not set to an instance of an object.
  57. at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
  58. at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
  59. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
  60. at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  61. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
  62. at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable`1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
  63. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.MoveNext(CancellationToken cancellationToken)
  64. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
  65. at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteSingletonAsyncQuery[TResult](QueryContext queryContext, Func`2 compiledQuery, IDiagnosticsLogger`1 logger, Type contextType)
  66. trce: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
  67. Action Filter: Before executing OnActionExecuted on filter Microsoft.AspNetCore.Mvc.Internal.ResponseCacheFilter.
  68. trce: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[3]
  69. Action Filter: After executing OnActionExecuted on filter Microsoft.AspNetCore.Mvc.Internal.ResponseCacheFilter.
  70. trce: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
  71. Action Filter: Before executing OnActionExecuted on filter Microsoft.AspNetCore.Mvc.ModelBinding.UnsupportedContentTypeFilter.
  72. trce: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[3]
  73. Action Filter: After executing OnActionExecuted on filter Microsoft.AspNetCore.Mvc.ModelBinding.UnsupportedContentTypeFilter.
  74. trce: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[3]
  75. Action Filter: After executing OnActionExecutionAsync on filter Microsoft.AspNetCore.Mvc.Internal.ControllerActionFilter.
  76. trce: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
  77. Resource Filter: Before executing OnResourceExecuted on filter Microsoft.AspNetCore.Mvc.ViewFeatures.Internal.SaveTempDataFilter.
  78. trce: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[3]
  79. Resource Filter: After executing OnResourceExecuted on filter Microsoft.AspNetCore.Mvc.ViewFeatures.Internal.SaveTempDataFilter.
  80. info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
  81. Executed action MapDiffBot.Controllers.FilesController.HandleMapGet (MapDiffBot) in 14.6326ms
  82. fail: Microsoft.AspNetCore.Server.Kestrel[13]
  83. Connection id "0HLPTV6CQFT7T", Request id "0HLPTV6CQFT7T:00000001": An unhandled exception was thrown by the application.
  84. System.NullReferenceException: Object reference not set to an instance of an object.
  85. at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
  86. at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
  87. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
  88. at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  89. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
  90. at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable`1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
  91. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.MoveNext(CancellationToken cancellationToken)
  92. at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
  93. at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteSingletonAsyncQuery[TResult](QueryContext queryContext, Func`2 compiledQuery, IDiagnosticsLogger`1 logger, Type contextType)
  94. at MapDiffBot.Controllers.FilesController.HandleMapGet(Int64 repositoryId, Int64 checkRunId, Int32 fileId, String beforeOrAfter, CancellationToken cancellationToken) in D:\GitHub\MapDiffBot\MapDiffBot\Controllers\FilesController.cs:line 94
  95. at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
  96. at System.Threading.Tasks.ValueTask`1.get_Result()
  97. at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
  98. at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
  99. at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
  100. at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
  101. at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
  102. at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
  103. at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
  104. at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
  105. at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
  106. at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
  107. at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
  108. at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
  109. at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
  110. at Cyberboss.AspNetCore.AsyncInitializer.ApplicationBuilderExtensions.<>c__DisplayClass1_0.<<UseAsyncInitialization>b__2>d.MoveNext()
  111. --- End of stack trace from previous location where exception was thrown ---
  112. at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application)
  113. info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
  114. Entity Framework Core 2.2.6-servicing-10079 initialized 'DatabaseContext' using provider 'Pomelo.EntityFrameworkCore.MySql' with options: None
  115. dbug: Microsoft.EntityFrameworkCore.ChangeTracking[10808]
  116. 'DatabaseContext' generated a temporary value for the 'Id' property of new 'Log' entity. Consider using 'DbContextOptionsBuilder.EnableSensitiveDataLogging' to see key values.
  117. dbug: Microsoft.EntityFrameworkCore.ChangeTracking[10806]
  118. Context 'DatabaseContext' started tracking 'Log' entity. Consider using 'DbContextOptionsBuilder.EnableSensitiveDataLogging' to see key values.
  119. dbug: Microsoft.EntityFrameworkCore.Update[10004]
  120. SaveChanges starting for 'DatabaseContext'.
  121. dbug: Microsoft.EntityFrameworkCore.ChangeTracking[10800]
  122. DetectChanges starting for 'DatabaseContext'.
  123. dbug: Microsoft.EntityFrameworkCore.ChangeTracking[10801]
  124. DetectChanges completed for 'DatabaseContext'.
  125. dbug: Microsoft.EntityFrameworkCore.Database.Connection[20000]
  126. Opening connection to database 'ss13_map_diff_bot' on server 'localhost'.
  127. dbug: Microsoft.EntityFrameworkCore.Database.Connection[20001]
  128. Opened connection to database 'ss13_map_diff_bot' on server 'localhost'.
  129. dbug: Microsoft.EntityFrameworkCore.Database.Transaction[20200]
  130. Beginning transaction with isolation level 'Unspecified'.
  131. dbug: Microsoft.EntityFrameworkCore.Database.Command[20100]
  132. Executing DbCommand [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (Size = 4000), @p3='?' (Size = 255), @p4='?' (DbType = DateTimeOffset)], CommandType='Text', CommandTimeout='30']
  133. INSERT INTO `Log` (`EventId`, `Level`, `Message`, `Name`, `TimeStamp`)
  134. VALUES (@p0, @p1, @p2, @p3, @p4);
  135. SELECT `Id`
  136. FROM `Log`
  137. WHERE ROW_COUNT() = 1 AND `Id` = LAST_INSERT_ID();
  138. info: Microsoft.EntityFrameworkCore.Database.Command[20101]
  139. Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (Size = 4000), @p3='?' (Size = 255), @p4='?' (DbType = DateTimeOffset)], CommandType='Text', CommandTimeout='30']
  140. INSERT INTO `Log` (`EventId`, `Level`, `Message`, `Name`, `TimeStamp`)
  141. VALUES (@p0, @p1, @p2, @p3, @p4);
  142. SELECT `Id`
  143. FROM `Log`
  144. WHERE ROW_COUNT() = 1 AND `Id` = LAST_INSERT_ID();
  145. dbug: Microsoft.EntityFrameworkCore.ChangeTracking[10803]
  146. Foreign key property 'Log.Id' detected as changed. Consider using 'DbContextOptionsBuilder.EnableSensitiveDataLogging' to see property values.
  147. dbug: Microsoft.EntityFrameworkCore.Database.Command[20300]
  148. A data reader was disposed.
  149. dbug: Microsoft.EntityFrameworkCore.Database.Transaction[20202]
  150. Committing transaction.
  151. dbug: Microsoft.EntityFrameworkCore.Database.Connection[20002]
  152. Closing connection to database 'ss13_map_diff_bot' on server 'localhost'.
  153. dbug: Microsoft.EntityFrameworkCore.Database.Connection[20003]
  154. Closed connection to database 'ss13_map_diff_bot' on server 'localhost'.
  155. dbug: Microsoft.EntityFrameworkCore.Database.Transaction[20204]
  156. Disposing transaction.
  157. dbug: Microsoft.EntityFrameworkCore.ChangeTracking[10807]
  158. An 'Log' entity tracked by 'DatabaseContext' changed from 'Added' to 'Unchanged'. Consider using 'DbContextOptionsBuilder.EnableSensitiveDataLogging' to see key values.
  159. dbug: Microsoft.EntityFrameworkCore.Update[10005]
  160. SaveChanges completed for 'DatabaseContext' with 1 entities written to the database.
  161. dbug: Microsoft.EntityFrameworkCore.Infrastructure[10407]
  162. 'DatabaseContext' disposed.
  163. dbug: Microsoft.AspNetCore.Server.Kestrel[9]
  164. Connection id "0HLPTV6CQFT7T" completed keep alive response.
  165. dbug: Microsoft.EntityFrameworkCore.Infrastructure[10407]
  166. 'DatabaseContext' disposed.
  167. info: Microsoft.AspNetCore.Hosting.Internal.WebHost[2]
  168. Request finished in 28.5243ms 500
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!