Add background job that scans for booking-intents stuck in "pending_payment" > 30 min and cancels them

[thlpkee20-wq]

Description

Add a scheduled worker that finds booking_intents.status = 'pending_payment' AND created_at < now() - 30 min, cancels them, releases the slot inventory, and emits a booking_intent_expired event.

Requirements and context

• Must be secure, tested, and documented
• Should be efficient and easy to review
• Relevant code: src/workers/expireBookingIntents.ts (new), src/scheduler/registry.ts

Suggested execution

• Fork the repo and create a branch
• git checkout -b feat/expire-pending-booking-intents
• Implement changes
  • Cron every 60s; use FOR UPDATE SKIP LOCKED to allow multi-instance
  • Update status='cancelled_expired', emit booking_intent_expired event, decrement slot_reservation counter
  • Add prometheus gauge booking_intents_expired_total
• Validate security and correctness assumptions

Test and commit

• Run tests
  • npm test (integration with testcontainers pg)
• Cover edge cases
  • two workers running (no double-cancel), expiry exactly at 30 min boundary, slot already-completed
• Include test output and notes

Example commit message

feat: expire stale pending-payment booking-intents

Guidelines

• Minimum 95 percent test coverage
• Clear documentation
• Timeframe: 96 hours

[Baskarayelu]

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

I’d love to be assigned this issue and contribute across the relevant areas, whether it involves smart contracts, UI development, backend logic, design implementation, or overall system integration. I’m comfortable working across the full stack and can adapt to the project’s technical requirements to ensure a smooth and consistent contribution.

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

[GOE001]

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

I would like to work on this

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

[abdulsamadr943-code]

@abdulsamadr943-code has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

i would love to work on this issue and summit a clean pr withing 1 days

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

[Imole203]

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

I will love to work on this issue,pls 🙏 assign this to me

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

[islarmeeyah-cyber]

@islarmeeyah-cyber has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi Maintainer, I'd like to work on this issue. I can start immediately.

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

[drips-wave]

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

🧑‍💻 @islarmeeyah-cyber: 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 🌊