Add structured log for failed alert threshold check after trade event with error details

[Chucks1093]

Summary

If the alert threshold check fails after a trade is indexed — for example due to a database error reading the alerts table — that failure should be logged with enough context to replay the check manually without losing the triggering trade event details.

Scope

• Emit a structured error log when the alert check fails with fields: creator_id, ledger_sequence, new_price, error_message, failed_at
• Log should be emitted even if the trade write itself succeeded
• Include enough context that an operator can manually re-run the check for the same creator and price

Acceptance Criteria

• Error log emitted when alert check fails after successful trade write
• All five fields present with correct values
• Log is not emitted when alert check succeeds

ETA: 12 hours

---

Coordinate on Telegram

[ayaoba24]

@ayaoba24 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I’d love to work on this please assign

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

[Godfrey-Delight]

@Godfrey-Delight has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I would love to work on this issue

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

[drips-wave]

Congratulations, @Godfrey-Delight! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @Godfrey-Delight: 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 🌊

[grantfox-oss]

🦊 GrantFox — @Godfrey-Delight has been assigned to this issue as part of the Official Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #510)
2. Your PR will be reviewed by the accesslayerorg maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Official Campaign campaign!

@Godfrey-Delight's PR #525 was approved and merged by @Chucks1093.

🏆 @Godfrey-Delight: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (401 total points). Track your full progress on GrantFox.

👏 Great work, @Godfrey-Delight! Keep contributing to accesslayerorg.

[drips-wave]

This issue has been completed by @Godfrey-Delight as part of the Stellar Wave Program's 6th Wave 🥳

😎 @Godfrey-Delight: You earned 150 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.