Persist Stellar Payment Listener Cursor to Database

[Emmzyemms]

Labels: bug, reliability, backend

Description

The Stellar payment listener (src/stellar/stellar-payment-listener.service.ts) tracks its cursor (the last processed transaction) in memory only. When the service restarts, it loses the cursor and may reprocess old payments or miss payments that arrived during the downtime.

Acceptance Criteria

• Cursor is persisted to the database (a new StellarCursor table or a key-value config table)
• On startup, the listener reads the last saved cursor from the database
• Cursor is updated in the database after each successfully processed payment
• If no cursor exists in the database, the listener starts from "now" (not from the beginning of the ledger)
• Prisma migration included for the new table/column
• Unit tests cover cursor persistence and recovery on restart

---

[Pee-pheelips]

@Pee-pheelips has applied to work on this issue as part of the Stellar Wave Program's 4th wave.

Hi, I'd love to work on this issue, my name is Paul. I am a fullstack web3 engineer with 4 years of experience building Web and mobile applications.

I can confidently handle this issue. Here is my portfolio and projects I have handled:

https://Paulfolio-delta.vercel.app
https://www.rown.xyz/
https://ecohotels.com
https://eduvacity.com/
https://www.mollateral.com/

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

[Akanimoh12]

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

Hi, I'd love to work on this issue. I'm a full-stack blockchain developer specializing in web apps and Smart Contracts, with experience in Next.js, TypeScript, Tailwind, and blockchain integration's and writing tests. I can handle this confidently, here's my portfolio and key projects:

• https://frontend-nine-mocha.vercel.app/
• https://i-predict.vercel.app/
• https://somnia-screams.vercel.app/
• https://chessflip-celo.vercel.app/

Active OSS contributor.

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

[CNduka001]

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

Hi Maintainer,
I will get this done for you, ASAP!
Please assign, ETA - 6 hours

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

[Dev-Ben-Theo]

@Dev-Ben-Theo has applied to work on this issue as part of the Stellar Wave Program's 4th wave.

i want to work on this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Dev-Ben-Theo to this issue.

[drips-wave]

Congratulations, @Dev-Ben-Theo! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on April 29, 2026.

🧑‍💻 @Dev-Ben-Theo: 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 🌊