[Backend] Hardcoded 'singleton' INDEXER_STATE_ID duplicated across files — extract to one constant

[ogazboiz]

Join the discussion on Telegram

Why this matters

The string 'singleton' is used as the IndexerState row's primary key from at least four places — if anyone ever changes it, they have to find them all:

• backend/src/workers/soroban-event-worker.ts:8 — const INDEXER_STATE_ID = 'singleton';
• backend/src/services/indexerService.ts:5 — const INDEXER_STATE_ID = 'singleton';
• backend/src/routes/health.routes.ts:65 — prisma.indexerState.findUnique({ where: { id: 'singleton' } }) (inline)
• backend/src/routes/v1/admin.routes.ts:59 — prisma.indexerState.findUnique({ where: { id: 'singleton' } }) (inline)
• backend/src/routes/adminRoutes.ts:106 — same inline (this file is also a duplicate addressed in [Backend] Reconcile duplicate admin metrics endpoints with divergent auth #542)

Acceptance criteria

• Move the constant to a shared module (e.g. backend/src/lib/indexer-state.ts or extend indexerService.ts to export it)
• All four other call sites import it
• No behavior change

Files to touch

• backend/src/workers/soroban-event-worker.ts
• backend/src/services/indexerService.ts
• backend/src/routes/health.routes.ts (line 65)
• backend/src/routes/v1/admin.routes.ts (line 59)
• backend/src/routes/adminRoutes.ts (line 106) — if not removed by [Backend] Reconcile duplicate admin metrics endpoints with divergent auth #542 first

Out of scope

• The duplicate admin routes file ([Backend] Reconcile duplicate admin metrics endpoints with divergent auth #542)

[coderolisa]

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

Hello maintainer let me work on this
please assign

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

[Babigdk]

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

Hi Maintainer,
I’d like to work on this issue. Could you please assign it to me?
I will provide a detailed explanation of the implementation and the changes made in the pull request once it's ready.
Thank you.

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

[Songu3020]

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

Hello, I’m a full stack developer with hands-on experience building with variety of tools including Nextjs, nodejs, nestjs, React, Typescript and more

I focus on writing clear, maintainable code and making sure features work as expected end to end, not just in isolation. I communicate progress regularly and keep things transparent as I work. I’m confident I can complete this task within an ETA of 4 HOURS

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

[khanavi272-spec]

@khanavi272-spec has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

I would like to work on this issue

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

[Bug-Hunter-X]

@Bug-Hunter-X has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

I would love to work on this issue sir

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Bug-Hunter-X to this issue.

[drips-wave]

Congratulations, @Bug-Hunter-X! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 2, 2026.

🧑‍💻 @Bug-Hunter-X: 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 🌊

[drips-wave]

This issue has been completed by @Bug-Hunter-X as part of the Stellar Wave Program's 5th Wave 🥳

😎 @Bug-Hunter-X: 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.