Add Indexer Reconciliation Job For Missing Streams

[ritik4ever]

Problem:
Current syncing and event indexing can diverge if one path misses data or if the node was unavailable temporarily.

Scope:
Add a reconciliation job that compares local streams against on-chain IDs and repairs gaps.

Acceptance criteria:

• Missing local streams can be backfilled from chain
• The job avoids duplicating already indexed streams
• Failures are logged clearly
• Reconciliation can run safely more than once

[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

[drips-wave]

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

🧑‍💻 @quickweb-stack: 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 🌊