liandk

Oct 12, 2026 · Backend Development

AI-Generated SQL Locks Database, Exhausts Tomcat Connection Pool: Production Post-Mortem

A production post-mortem reveals how AI-generated SQL caused long-running queries that locked SQL Server, exhausted Tomcat's 300-connection pool, and repeatedly hung the service until restart; the article details root-cause analysis, missing SQL execution timeout, and fixes including connection pool abandonment recovery, query optimization, and monitoring alerts.