Fix broken transaction rollback on nested service failures

[Baskarayelu]

Fix broken transaction rollback on nested service failures

Description

• Ensure nested service exceptions trigger full rollback of enclosing DB transaction.

Requirements and context

• Preserve atomicity for multi-step write operations.
• Avoid swallowing exceptions in lower layers.

Suggested execution

• Refactor transaction manager to propagate errors consistently.
• Add explicit rollback assertions in service orchestration path.

Test and commit

• Add integration tests for nested failure rollback completeness.

Example commit message

• fix(tx): guarantee full rollback on nested service exceptions

Guidelines

• Keep transaction boundaries explicit and minimal.
• Avoid side effects outside transaction before commit.

[drips-wave]

This issue has been added to the Stellar Wave Program and is worth 200 Points.

🧑‍💻 Interested in contributing? Apply to work on this issue on Drips Wave, earn points, and receive rewards.

Warning

Only applications submitted via the apply link above will be considered. Please do not apply by commenting on the issue or opening a PR directly.

🤠 Repo maintainers: You can manage this issue's Points and Complexity on your Maintainer Dashboard here. Please keep an eye on applications and respond quickly 💙

ℹ️ Learn more about Drips Wave

[Caritajoe18]

@Caritajoe18 has applied to work on this issue as part of the Stellar Wave Program's 3rd wave.

hello @Baskarayelu,
I would like to work on this issue, Kindly assign to me.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Caritajoe18 to this issue.

[drips-wave]

Congratulations, @Caritajoe18! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on March 30, 2026.

🧑‍💻 @Caritajoe18: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊