One runaway report query held a lock for 40 minutes and took down our payouts API last month.
Aarav Sharma
Senior Backend Engineer @ Paylane | Java, Spring Boot, Kafka | Building payment rails that don't wake you up at 3am
One runaway report query held a lock for 40 minutes and took down our payouts API last month.
Now every service sets `options=-c statement_timeout=30s` on the Hikari datasource. Long-running jobs use a separate datasource with a higher limit. Should have done this years ago.
5 reactions3 comments