johndemos
johndemos
CC#
Created by johndemos on 3/15/2024 in #help
Npgsql.NpgsqlOperationInProgressException: A Command is Already in Progress in MassTransit
Hey peeps, I've been struggling with this issue for a few days now, I'm trying to publish outbox messages and then consume them within my e2e tests. The problem is I am running into a db exception when the second test runs
Npgsql.NpgsqlOperationInProgressException (0x80004005): A command is already in progress: UPDATE identity."Outbox" SET "PublishedOnUtc" = @p0 WHERE "Id" = @p1;
Npgsql.NpgsqlOperationInProgressException (0x80004005): A command is already in progress: UPDATE identity."Outbox" SET "PublishedOnUtc" = @p0 WHERE "Id" = @p1;
This seems to be because my OutboxService creates a transaction to lock the outbox messages. I've written a full stackoverflow post explaining the issue if anyone has time to help me though this I'm so happy to pay for your time!! Stackoverflow post: https://stackoverflow.com/questions/78163988/npgsql-npgsqloperationinprogressexception-a-command-is-already-in-progress-in-m github to repo: https://github.com/JasperDaDolphin/OutboxRepo/tree/main To repoduce run TestConfirmPhoneNumber and TestConfirmEmail in a single run in XUnit
1 replies