Deletion of certain docker images fail

[dsh_0031]

Hello guys,

We are trying to delete some docker images from our docker feed in ProGet using the web interface.
However the SQL query seems to fail, and the site throws an application error. This only affects deletion of certain image tags, not sure what makes them special.

ProGet Version 5.2.14 (Build 17)

Full error/Stack trace

Server Error in '/' Application.
512`16`1`DockerImages_DeleteImage`23`Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 512`16`1`DockerImages_DeleteImage`23`Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): 512`16`1`DockerImages_DeleteImage`23`Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.]
   System.Data.SqlClient.<>c.<ExecuteDbDataReaderAsync>b__180_0(Task`1 result) +47
   System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() +104
   System.Threading.Tasks.Task.Execute() +73
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +68
   Inedo.Data.<CreateAsync>d__14.MoveNext() +339
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +68
   Inedo.Data.<ExecuteInternalAsync>d__37.MoveNext() +1372
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +68
   Inedo.Data.<ExecuteNonQueryAsync>d__35.MoveNext() +332
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +68
   Inedo.Data.<ExecuteScalarAsync>d__34`1.MoveNext() +297
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   Inedo.ProGet.WebApplication.Pages.Docker.Images.<<CreateChildControls>b__5>d.MoveNext() +1027
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   Inedo.Web.PageFree.<ProcessPostAsync>d__64.MoveNext() +586
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   Inedo.Web.PageFree.<ProcessPostAsync>d__64.MoveNext() +929
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +68
   Inedo.Web.PageFree.<ProcessRequestAsync>d__47.MoveNext() +575
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +68
   System.Web.TaskAsyncHelper.EndTask(IAsyncResult ar) +59
   Inedo.Web.Handlers.AsyncHandlerWrapper.EndProcessRequest(IAsyncResult result) +33
   System.Web.CallHandlerExecutionStep.InvokeEndHandler(IAsyncResult ar) +234
   System.Web.CallHandlerExecutionStep.OnAsyncHandlerCompletion(IAsyncResult ar) +169

Any idea how to fix this or what could be happening?
I tried deleting the image tags using the API, but this fails the same way.

[atripp]

Hello;

Thank you for the bug report; there was a bad query in that stored procedure that would cause it to fail in some cases.

It will be fixed in the next maintence release of ProGet (5.2.28), but you can download a patch (1.DockerImages_DeleteImage.sql) and run it against your database today :)

The file is attached to the ticket: https://inedo.myjetbrains.com/youtrack/issue/PG-1684

Best,
Alana

[dsh_0031]

Thank you, sound good. I will give the patch a go.