How a Transaction We Forgot to Close Took Down a Service

A survey API went down at 155 requests a minute. The database was fine the whole time. The bug was hiding in between. One request took 145 seconds. Only 65 milliseconds of it was real database work. T