how to handle Transaction scopes in Azure function and in calling API?

Question

I have a Azure function, which calls some API endpoint for database update/insert and then will complete the message in the Queue.In case azure functions code fails after API success, I want to rollback Db operations. How to do that? Please share any samples on this.

Azure Function Run
{
    transactionscope
    {
        callAPI();
        ..some operations
        x = y/0;
        scope,complete()
    }
}

API:

callAPI
{
    transactionscope
    {
        saveDB();
        scope.complete();
    }
}

I answered this already in the question that you opened here: stackoverflow.com/questions/79230541/…. Why open another question asking the same thing? — Jesse Squire
– Jesse Squire, Commented Nov 29, 2024 at 17:44

Sean Feldman · Accepted Answer · 2024-11-28 19:38:03Z

0

Assuming you're using Azure Service Bus for your messaging service, you cannot have a transaction spanning two different resources. In the past, with messaging services like MSMQ, you had a distributed coordinator, and resources such as SQL Server and MSMQ could participate in the same transaction to be committed or rolled back together. This is not the case for cloud services. While ASB supports messaging transactions and Azure SQL supports data transactions, those cannot be combined.

What can you do?

Build your Functions to be idempotent. If data is stored successfully but the message fails to be completed and is retried, ensure there's a validation that the data doesn't have to be written again.

For more advanced scenarios, consider implementing the outbox pattern.

answered Nov 28, 2024 at 19:38

Sean Feldman

26.3k9 gold badges63 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to handle Transaction scopes in Azure function and in calling API?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related