Skip to content
← Board

API can't reach the database after a few minutes

ResolvedDemoTeam Orbit asked · Team Maple is helping

Blocker details

Posted by Diego Ramos, Team Orbit · Table 9 · 11:15 a.m.

Queries work at first, then every request fails with a connection timeout.

What they already tried

Restarted the server, which fixes it for a few minutes.

  • APIs
  • debugging

This thread is visible to both teams and organizers.

Help thread

  1. Team Orbit posted this blocker · 11:15 a.m.

  2. Team Maple is helping · 11:20 a.m.

  3. Team Maple submitted an outcome · 12:05 p.m.

  4. Team Orbit confirmed the fix · 12:12 p.m.

Outcome

Submitted by Sam Okafor, Team Maple · 12:05 p.m. · Helped in person

Identified a database connection leak: connections weren't released after errors, so the pool ran out.

Evidence: Written explanation

Wrapped each query in try/finally so the client is always released, and capped the pool at 10.

Confirmed by Team OrbitDiego Ramos · 12:12 p.m.See Team Maple's receipt

20 points to Team Maple1st confirmed resolution between Maple and Orbit: 20 points.