1. Home
  2. Categories
  3. Support
  4. SET TRANSACTION ISOLATION LEVEL must be called before any query

Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

SET TRANSACTION ISOLATION LEVEL must be called before any query

  • J

    Getting a "not found" when VS trying to pull symbols from ProGet. I followed guide and double checked url (has symbol and not nuget) and all VS settings. Looked at the logs and seeing the below stack over and over again. Guessing it is happening every time I upload a package with symbols. It also happens if I click the re-index button on the feed:

    URL: http://build.nicode.ninja/0x44/ProGet.WebApplication/Inedo.ProGet.WebApplication.Pages.Executions.ExecutionInProgressPage/GetProgress
    Referrer: http://build.nicode.ninja:8081/executions/execution-in-progress?executionId=8
    User: DevAdmin
    User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0
    Stack trace: at Npgsql.NpgsqlConnector+<DoReadMessageAsync>d__6.MoveNext () [0x002d7] in <4985dea8374f4819bebb7847d95ad483>:0
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0 at Npgsql.NpgsqlConnector+<ReadMessageWithPrependedAsync>d__5.MoveNext () [0x001c3] in <4985dea8374f4819bebb7847d95ad483>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at Npgsql.NpgsqlDataReader+<NextResultInternalAsync>d__1.MoveNext () [0x007da] in <4985dea8374f4819bebb7847d95ad483>:0
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0 at Npgsql.NpgsqlDataReader+<NextResultAsync>d__48.MoveNext () [0x0014a] in <4985dea8374f4819bebb7847d95ad483>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at Npgsql.NpgsqlCommand+<ExecuteAsync>d__0.MoveNext () [0x003d8] in <4985dea8374f4819bebb7847d95ad483>:0
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0 at Npgsql.NpgsqlCommand+<ExecuteDbDataReaderInternalAsync>d__4.MoveNext () [0x000f1] in <4985dea8374f4819bebb7847d95ad483>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at Npgsql.NpgsqlCommand+<ExecuteDbDataReaderAsync>d__99.MoveNext () [0x000a7] in <4985dea8374f4819bebb7847d95ad483>:0
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0 at Inedo.Postgres.WrappedPgCommand+<ExecuteDbDataReaderAsync>d__41.MoveNext () [0x001db] in <dfd66ed5f8e7421fa137b49d30769655>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at Inedo.Data.DatabaseContext+DbResult+<CreateAsync>d__10.MoveNext () [0x00082] in <fca6185a2ae14ad39e3d38cfae3207f3>:0
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0 at Inedo.Data.DatabaseContext+<ExecuteInternalAsync>d__33.MoveNext () [0x001fc] in <fca6185a2ae14ad39e3d38cfae3207f3>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at Inedo.Data.DatabaseContext+<ExecuteTableAsync>d__321[TRow].MoveNext () [0x00082] in <fca6185a2ae14ad39e3d38cfae3207f3>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at Inedo.ProGet.WebApplication.Pages.Executions.ExecutionStatus+<GetLogsAsync>d__17.MoveNext () [0x000a5] in <cdb9f36899a64a91848b5bcdb31effa2>:0
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0 at Inedo.ProGet.WebApplication.Pages.Executions.ExecutionStatus+<GetStatusAsync>d__16.MoveNext () [0x000b8] in <cdb9f36899a64a91848b5bcdb31effa2>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0 at System.Runtime.CompilerServices.TaskAwaiter1[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at Inedo.ProGet.WebApplication.Pages.Executions.ExecutionInProgressPage+<GetProgress>d__8.MoveNext () [0x000f1] in <cdb9f36899a64a91848b5bcdb31effa2>:0
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at Inedo.Web.Handlers.JsonDataHttpHandler+AsyncHandler+<ProcessRequestAsync>d__9.MoveNext () [0x001bd] in <1d7c5050779a45edba4fcc6d8ea97586>:0
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Runtime.CompilerServices.TaskAwaiter.GetResult () [0x00000] in <2e7c1c96edae44d496118948ca617c11>:0
    at System.Web.TaskAsyncResult.Wait (System.IAsyncResult result) [0x00032] in <52b8d38f1da445f7ad770be558c9fed4>:0
    at System.Web.HttpTaskAsyncHandler.System.Web.IHttpAsyncHandler.EndProcessRequest (System.IAsyncResult result) [0x00000] in <52b8d38f1da445f7ad770be558c9fed4>:0
    at Inedo.Web.Handlers.AsyncHandlerWrapper.EndProcessRequest (System.IAsyncResult result) [0x00000] in <1d7c5050779a45edba4fcc6d8ea97586>:0
    at System.Web.HttpApplication.async_handler_complete_cb (System.IAsyncResult ar) [0x00015] in <52b8d38f1da445f7ad770be558c9fed4>:0

    Product: ProGet
    Version: 5.0.6

    0
  • ben
    inedo-engineer

    Hello Jarrod,

    This was fixed in PG-1209, which is part of ProGet 5.0.9.

    0
  • J

    We've been holding to v5.0.6 because it appears this issue is still open and was introduced (as far as we can tell) in 5.0.7:
    https://inedo.com/support/questions/8240

    Has this been addressed in the latest build for linux on docker?

    0
proget 1568 nuget 227 symbols 65
Log in to reply
 
Inedo Website Home • Support Home • Code of Conduct • Forums Guide • Documentation