No operations allowed after statement closed || Connection Issues
11 views
Skip to first unread message
Ankit Kumar
Jul 23, 2025, 6:59:15 AMJul 23
to proxysql
Hi Team,
We are facing issues on app getting a few errors in one of the environment:
Rolling back transaction due to java.lang.RuntimeException: org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [ UPDATE permissions SET version = ?, deleted = true, last_modified_by = ? WHERE id = ? and deleted = false and (c_md5 = MD5(?) or path like ?) No operations allowed after statement closed.
We tried checking below things on proxysql:
1. Error related to this in error log. while no error reported related to this.
2. free Connections / latencies / load / memory - looks good.
We are not able to find root cause of the issue. Please help us.
We are facing issues on app getting a few errors in one of the environment:
Rolling back transaction due to java.lang.RuntimeException: org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [ UPDATE permissions SET version = ?, deleted = true, last_modified_by = ? WHERE id = ? and deleted = false and (c_md5 = MD5(?) or path like ?) No operations allowed after statement closed.
We tried checking below things on proxysql:
1. Error related to this in error log. while no error reported related to this.
2. free Connections / latencies / load / memory - looks good.
We are not able to find root cause of the issue. Please help us.
Reply all
Reply to author
Forward
0 new messages