Skip to content

Instantly share code, notes, and snippets.

@nickspiers

nickspiers/gist:3620840145d0a88e3966643613a5d442

Created August 13, 2018 13:11
Show Gist options
  • Save nickspiers/3620840145d0a88e3966643613a5d442 to your computer and use it in GitHub Desktop.
Save nickspiers/3620840145d0a88e3966643613a5d442 to your computer and use it in GitHub Desktop.
Download ZIP
efcore-issue output
Raw
gistfile1.txt
WebApplication2> info: Microsoft.AspNetCore.Hosting.Internal.WebHost[1]
WebApplication2> Request starting HTTP/1.1 GET http://localhost:54955/api/Foos?$expand=man%28$expand=chu%29
WebApplication2> info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[1]
WebApplication2> Route matched with {action = "Get", controller = "Foos"}. Executing action WebApplication2.Controllers.FoosController.Get (WebApplication2)
WebApplication2> info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[1]
WebApplication2> Executing action method WebApplication2.Controllers.FoosController.Get (WebApplication2) - Validation state: Valid
WebApplication2> info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
WebApplication2> Entity Framework Core 2.1.1-rtm-30846 initialized 'AppContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
WebApplication2> info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
WebApplication2> Executed action method WebApplication2.Controllers.FoosController.Get (WebApplication2), returned result Microsoft.AspNetCore.Mvc.ObjectResult in 10.6137ms.
WebApplication2> info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
WebApplication2> Executing ObjectResult, writing value of type 'Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[[Microsoft.AspNet.OData.Query.Expressions.SelectExpandBinder+SelectAllAndExpand`1[[WebApplication2.Models.Foo, WebApplication2, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], Microsoft.AspNetCore.OData, Version=7.0.1.20718, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]'.
WebApplication2> info: Microsoft.EntityFrameworkCore.Database.Command[20101]
WebApplication2> Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
WebApplication2> SELECT [dtoFoo].[Id], CASE
WebApplication2> WHEN [dtoFoo].[ManId] IS NULL
WebApplication2> THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT)
WebApplication2> END, CASE
WebApplication2> WHEN [dtoFoo.Man].[ChuId] IS NULL
WebApplication2> THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT)
WebApplication2> END, [dtoFoo.Man.Chu].[A], [dtoFoo.Man.Chu].[B], [dtoFoo.Man.Chu].[C], [dtoFoo.Man.Chu].[D], [dtoFoo.Man.Chu].[Id] AS [Id0], [dtoFoo.Man].[ChuId], [dtoFoo].[ManId] AS [Id1], [dtoFoo.Man].[Type], [dtoFoo].[ManId], [dtoFoo].[Name], [dtoFoo.Man.Chu].[A] AS [A0], [dtoFoo.Man.Chu].[B] AS [B0], [dtoFoo.Man.Chu].[C] AS [C0], [dtoFoo.Man.Chu].[D] AS [D0], [dtoFoo.Man.Chu].[Id] AS [Id2], [dtoFoo.Man.Chu].[A] AS [A1], [dtoFoo.Man.Chu].[B] AS [B1], [dtoFoo.Man.Chu].[C] AS [C1], [dtoFoo.Man.Chu].[D] AS [D1], [dtoFoo.Man.Chu].[Id] AS [Id3], [dtoFoo.Man.Chu].[A] AS [A2], [dtoFoo.Man.Chu].[B] AS [B2], [dtoFoo.Man.Chu].[C] AS [C2], [dtoFoo.Man.Chu].[D] AS [D2], [dtoFoo.Man.Chu].[Id] AS [Id4], [dtoFoo.Man.Chu].[A] AS [A3], [dtoFoo.Man.Chu].[B] AS [B3], [dtoFoo.Man.Chu].[C] AS [C3], [dtoFoo.Man.Chu].[D] AS [D3], [dtoFoo.Man.Chu].[Id] AS [Id5]
WebApplication2> FROM [Foos] AS [dtoFoo]
WebApplication2> LEFT JOIN [Mans] AS [dtoFoo.Man] ON [dtoFoo].[ManId] = [dtoFoo.Man].[Id]
WebApplication2> LEFT JOIN [Chus] AS [dtoFoo.Man.Chu] ON [dtoFoo.Man].[ChuId] = [dtoFoo.Man.Chu].[Id]
WebApplication2> fail: Microsoft.EntityFrameworkCore.Query[10100]
WebApplication2> An exception occurred in the database while iterating the results of a query for context type 'WebApplication2.AppContext'.
WebApplication2> System.NullReferenceException: Object reference not set to an instance of an object.
WebApplication2> at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
WebApplication2> at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
WebApplication2> at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
WebApplication2> System.NullReferenceException: Object reference not set to an instance of an object.
WebApplication2> at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
WebApplication2> at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
WebApplication2> at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
WebApplication2> info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
WebApplication2> Executed action WebApplication2.Controllers.FoosController.Get (WebApplication2) in 196.0661ms
WebApplication2> fail: Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware[1]
WebApplication2> An unhandled exception has occurred while executing the request.
WebApplication2> System.NullReferenceException: Object reference not set to an instance of an object.
WebApplication2> at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
WebApplication2> at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
WebApplication2> at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
WebApplication2> at Microsoft.AspNet.OData.Formatter.Serialization.ODataResourceSetSerializer.WriteResourceSet(IEnumerable enumerable, IEdmTypeReference resourceSetType, ODataWriter writer, ODataSerializerContext writeContext)
WebApplication2> at Microsoft.AspNet.OData.Formatter.ODataOutputFormatterHelper.WriteToStream(Type type, Object value, IEdmModel model, ODataVersion version, Uri baseAddress, MediaTypeHeaderValue contentType, IWebApiUrlHelper internaUrlHelper, IWebApiRequestMessage internalRequest, IWebApiHeaders internalRequestHeaders, Func`2 getODataMessageWrapper, Func`2 getEdmTypeSerializer, Func`2 getODataPayloadSerializer, Func`1 getODataSerializerContext)
WebApplication2> at Microsoft.AspNet.OData.Formatter.ODataOutputFormatter.WriteResponseBodyAsync(OutputFormatterWriteContext context, Encoding selectedEncoding)
WebApplication2> --- End of stack trace from previous location where exception was thrown ---
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeResultAsync(IActionResult result)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResultFilterAsync[TFilter,TFilterAsync]()
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResultExecutedContext context)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.ResultNext[TFilter,TFilterAsync](State& next, Scope& scope, Object& state, Boolean& isCompleted)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeResultFilters()
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
WebApplication2> at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
WebApplication2> at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)
WebApplication2> warn: Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware[2]
WebApplication2> The response has already started, the error page middleware will not be executed.
WebApplication2> fail: Microsoft.AspNetCore.Server.Kestrel[13]
WebApplication2> Connection id "0HLFV644CI38A", Request id "0HLFV644CI38A:00000001": An unhandled exception was thrown by the application.
WebApplication2> System.NullReferenceException: Object reference not set to an instance of an object.
WebApplication2> at lambda_method(Closure , QueryContext , TransparentIdentifier`2 )
WebApplication2> at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.Internal.ProjectionShaper.TypedProjectionShaper`3.Shape(QueryContext queryContext, ValueBuffer& valueBuffer)
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
WebApplication2> at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
WebApplication2> at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
WebApplication2> at Microsoft.AspNet.OData.Formatter.Serialization.ODataResourceSetSerializer.WriteResourceSet(IEnumerable enumerable, IEdmTypeReference resourceSetType, ODataWriter writer, ODataSerializerContext writeContext)
WebApplication2> at Microsoft.AspNet.OData.Formatter.ODataOutputFormatterHelper.WriteToStream(Type type, Object value, IEdmModel model, ODataVersion version, Uri baseAddress, MediaTypeHeaderValue contentType, IWebApiUrlHelper internaUrlHelper, IWebApiRequestMessage internalRequest, IWebApiHeaders internalRequestHeaders, Func`2 getODataMessageWrapper, Func`2 getEdmTypeSerializer, Func`2 getODataPayloadSerializer, Func`1 getODataSerializerContext)
WebApplication2> at Microsoft.AspNet.OData.Formatter.ODataOutputFormatter.WriteResponseBodyAsync(OutputFormatterWriteContext context, Encoding selectedEncoding)
WebApplication2> --- End of stack trace from previous location where exception was thrown ---
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeResultAsync(IActionResult result)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResultFilterAsync[TFilter,TFilterAsync]()
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResultExecutedContext context)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.ResultNext[TFilter,TFilterAsync](State& next, Scope& scope, Object& state, Boolean& isCompleted)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeResultFilters()
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
WebApplication2> at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
WebApplication2> at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
WebApplication2> at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)
WebApplication2> at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)
WebApplication2> at Microsoft.AspNetCore.Server.IISIntegration.IISMiddleware.Invoke(HttpContext httpContext)
WebApplication2> at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application)
WebApplication2> info: Microsoft.AspNetCore.Hosting.Internal.WebHost[2]
WebApplication2> Request finished in 214.7089ms 200 application/json; odata.metadata=minimal; odata.streaming=true; charset=utf-8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment