Add chaos tests simulating Postgres pool exhaustion and Starknet RPC timeouts against src/db/index.ts and src/starknet/client.ts

[Jagadeeshftw]

Description

src/db/index.ts and src/starknet/client.ts both have documented reliability behaviors — bounded pool size with DB_POOL_MAX, connection retry with backoff (waitForDbReadiness), and RPC failover with per-endpoint circuit breakers — but none of these are exercised under an actually degraded environment in tests; the test suite mocks happy-path and simple error responses. Add chaos-style tests that saturate the pool and inject RPC timeouts/connection resets to prove the documented degradation behavior actually holds.

Requirements and context

• Add a test that exhausts DB_POOL_MAX connections concurrently and asserts getPoolStats().waiting behaves as documented and that waitForDbReadiness recovers once connections free up
• Add a test that forces every Starknet RPC endpoint to time out/reset and asserts the circuit breakers in src/starknet/circuit-breaker.ts open as configured and that src/starknet/client.ts surfaces a clean error rather than hanging
• Keep these tests isolated (a dedicated test suite/tag) so they do not slow down the default pnpm test run if they are inherently slower
• Must be secure, tested, and documented
• Should be efficient and easy to review

Suggested execution

Fork the repo and create a branch

git checkout -b test/chaos-db-rpc-failures

Implement changes

• Update/Write: src/db/index.ts
• Update/Write: src/starknet/client.ts
• Add/Update tests: src/db/chaos.test.ts, src/starknet/client.chaos.test.ts
• Add documentation: docs/starknet/client.md
• Include clear code comments and TS types
• Validate security assumptions

Test and commit

• Run tests: pnpm test
• Cover edge cases
• Include test output and security notes

Example commit message

test: add chaos tests for DB and RPC failure modes

Guidelines

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

[1nonlypiece]

Hi Maintainers 👋,

I’d like to apply for this issue.

I have hands-on experience with Next.js frontend development as well as Stellar smart contracts using Rust (Soroban). I’m comfortable working with Figma designs, integrating APIs/wallets on the frontend, and implementing, testing, and optimizing smart contracts on Stellar.

I can follow the project guidelines, communicate progress clearly, and deliver clean, well-tested code within the expected timeline.

Looking forward to contributing to the project 🚀
Thanks!

[grantfox-oss]

🦊 GrantFox — @1nonlypiece has been assigned to this issue as part of the Official Campaign | FWC26 campaign!

Next steps:

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

Good luck! Track your progress on GrantFox.