Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#38 Deadlock detected

open
nobody
5
2008-03-24
2008-03-24
Anonymous
No

Deadlock was detected when my application starts.

Name: HouseKeeper
State: BLOCKED on com.mysql.jdbc.ServerPreparedStatement@2d81f owned by: pool-1-thread-6
Total blocked: 4 Total waited: 46

Stack trace:
com.mysql.jdbc.ServerPreparedStatement.realClose(ServerPreparedStatement.java:855)
com.mysql.jdbc.Connection.closeAllOpenStatements(Connection.java:2128)
com.mysql.jdbc.Connection.realClose(Connection.java:4468)
com.mysql.jdbc.Connection.close(Connection.java:2100)
- locked com.mysql.jdbc.Connection@ccfbd8
org.logicalcobwebs.proxool.ProxyConnection.reallyClose(ProxyConnection.java:192)
org.logicalcobwebs.proxool.ConnectionPool.removeProxyConnection(ConnectionPool.java:429)
org.logicalcobwebs.proxool.HouseKeeper.sweep(HouseKeeper.java:139)
org.logicalcobwebs.proxool.HouseKeeperThread.run(HouseKeeperThread.java:39)

Name: pool-1-thread-6
State: BLOCKED on com.mysql.jdbc.Connection@ccfbd8 owned by: HouseKeeper
Total blocked: 1 Total waited: 329

Stack trace:
com.mysql.jdbc.ServerPreparedStatement.realClose(ServerPreparedStatement.java:867)
- locked com.mysql.jdbc.ServerPreparedStatement@2d81f
com.mysql.jdbc.ServerPreparedStatement.close(ServerPreparedStatement.java:459)
org.logicalcobwebs.proxool.AbstractProxyStatement.close(AbstractProxyStatement.java:115)
org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:93)
org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
$java.sql.Wrapper$$EnhancerByProxool$$647bc7b4.close(<generated>)
org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534)
org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269)
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)

Discussion