Implement alerting notifications on duplicate_prevention failures

[godamongstmen897]

Problem & Goal

Add threshold warning alerts to duplicate_prevention that log errors if operations stall or fail consecutively.

Context & Components

• Target Repository: escrow-backend
• Module/Component: duplicate_prevention (Unique constraint duplicate event blocker)

Implementation Details

1. Review the existing codebase inside the escrow-backend directory.
2. Locate the source files relating to duplicate_prevention.
3. Implement the feature logic/validation rules step-by-step.
4. Ensure code conforms to codebase patterns (lints, formats, types).

Verification & Testing Requirements

• Validation check: Assert warnings trigger after configured error counts.
• Add comprehensive test cases matching these validation requirements.
• Ensure all other existing project tests continue to compile and pass.

---

Note: This issue is completely self-contained and does not block or require any other issues to be resolved.

[nicbusiness83-design]

@nicbusiness83-design has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello, this issue aligns well with my experience and technical skills. I’ve reviewed the requirements and am confident I can deliver a solid solution. I’d appreciate the opportunity to work on it.

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

[drips-wave]

Congratulations, @wavyboy-build! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @wavyboy-build: 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 🌊