#kill-query

MySQL KILL QUERY and HikariCP validation: can the pool detect a transaction left by a cancelled statement?

When a long‑running DML statement is terminated with KILL QUERY , MySQL aborts the statement but leaves the surrounding transaction open. The storage engine may still be rolling back row changes, which determines when locks are actually released. Meanwhile, a Java connection pool such as HikariCP typically validates a borrowed connection with a lightweight q