Mantis - Resin
Viewing Issue Advanced Details
2323 block random 01-14-08 04:19 01-16-08 16:03
rilux  
ferg  
normal  
closed 3.0.23  
fixed  
none    
none 3.1.4  
0002323: java.sql.SQLException: transaction timed out waiting for lock 226858
I'm seeing the following error in my Resin 3.0.23 log. The box will grind to a halt and the load shoots up so the box barely responds to commands. I need to restart Resin to get it back.
[2008-01-14 12:09:54.524] java.sql.SQLException: transaction timed out waiting for lock 226858
[2008-01-14 12:09:54.524] at com.caucho.db.store.Lock.queue(Lock.java:381)
[2008-01-14 12:09:54.524] at com.caucho.db.store.Lock.queue(Lock.java:350)
[2008-01-14 12:09:54.524] at com.caucho.db.store.Lock.lockReadAndWrite(Lock.java:282)
[2008-01-14 12:09:54.524] at com.caucho.db.store.Transaction.lockWrite(Transaction.java:195)
[2008-01-14 12:09:54.524] at com.caucho.db.sql.UpdateQuery.execute(UpdateQuery.java:105)
[2008-01-14 12:09:54.524] at com.caucho.db.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:349)
[2008-01-14 12:09:54.524] at com.caucho.db.jdbc.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:325)
[2008-01-14 12:09:54.524] at com.caucho.server.cluster.FileBacking.updateAccess(FileBacking.java:354)
[2008-01-14 12:09:54.524] at com.caucho.server.cluster.ClusterStore.updateAccess(ClusterStore.java:788)
[2008-01-14 12:09:54.524] at com.caucho.server.hmux.HmuxClusterRequest.accessObject(HmuxClusterRequest.java:533)
[2008-01-14 12:09:54.524] at com.caucho.server.hmux.HmuxClusterRequest.handleRequest(HmuxClusterRequest.java:267)
[2008-01-14 12:09:54.524] at com.caucho.server.hmux.HmuxRequest.scanHeaders(HmuxRequest.java:640)
[2008-01-14 12:09:54.524] at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:350)
[2008-01-14 12:09:54.524] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[2008-01-14 12:09:54.524] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[2008-01-14 12:09:54.524] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[2008-01-14 12:09:54.524] at java.lang.Thread.run(Thread.java:619)
[2008-01-14 12:09:54.761] java.sql.SQLException: transaction timed out waiting for lock 100244
[2008-01-14 12:09:54.761] at com.caucho.db.store.Lock.queue(Lock.java:381)
[2008-01-14 12:09:54.761] at com.caucho.db.store.Lock.queue(Lock.java:350)
[2008-01-14 12:09:54.761] at com.caucho.db.store.Lock.lockReadAndWrite(Lock.java:282)
[2008-01-14 12:09:54.761] at com.caucho.db.store.Transaction.lockWrite(Transaction.java:195)
[2008-01-14 12:09:54.761] at com.caucho.db.sql.UpdateQuery.execute(UpdateQuery.java:105)
[2008-01-14 12:09:54.761] at com.caucho.db.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:349)
[2008-01-14 12:09:54.761] at com.caucho.db.jdbc.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:325)
[2008-01-14 12:09:54.761] at com.caucho.server.cluster.FileBacking.updateAccess(FileBacking.java:354)
[2008-01-14 12:09:54.761] at com.caucho.server.cluster.ClusterStore.updateAccess(ClusterStore.java:788)
[2008-01-14 12:09:54.761] at com.caucho.server.hmux.HmuxClusterRequest.accessObject(HmuxClusterRequest.java:533)
[2008-01-14 12:09:54.761] at com.caucho.server.hmux.HmuxClusterRequest.handleRequest(HmuxClusterRequest.java:267)
[2008-01-14 12:09:54.761] at com.caucho.server.hmux.HmuxRequest.scanHeaders(HmuxRequest.java:640)
[2008-01-14 12:09:54.761] at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:350)
[2008-01-14 12:09:54.761] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[2008-01-14 12:09:54.761] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[2008-01-14 12:09:54.761] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[2008-01-14 12:09:54.761] at java.lang.Thread.run(Thread.java:619)
[2008-01-14 12:09:55.522] java.sql.SQLException: transaction timed out waiting for lock 100244
[2008-01-14 12:09:55.522] at com.caucho.db.store.Lock.queue(Lock.java:381)
[2008-01-14 12:09:55.522] at com.caucho.db.store.Lock.queue(Lock.java:350)
[2008-01-14 12:09:55.522] at com.caucho.db.store.Lock.lockReadAndWrite(Lock.java:282)
[2008-01-14 12:09:55.522] at com.caucho.db.store.Transaction.lockWrite(Transaction.java:195)
[2008-01-14 12:09:55.522] at com.caucho.db.sql.UpdateQuery.execute(UpdateQuery.java:105)
[2008-01-14 12:09:55.522] at com.caucho.db.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:349)
[2008-01-14 12:09:55.522] at com.caucho.db.jdbc.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:325)
[2008-01-14 12:09:55.522] at com.caucho.server.cluster.FileBacking.updateAccess(FileBacking.java:354)
[2008-01-14 12:09:55.522] at com.caucho.server.cluster.ClusterStore.updateAccess(ClusterStore.java:788)
[2008-01-14 12:09:55.522] at com.caucho.server.hmux.HmuxClusterRequest.accessObject(HmuxClusterRequest.java:533)
[2008-01-14 12:09:55.522] at com.caucho.server.hmux.HmuxClusterRequest.handleRequest(HmuxClusterRequest.java:267)
[2008-01-14 12:09:55.522] at com.caucho.server.hmux.HmuxRequest.scanHeaders(HmuxRequest.java:640)
[2008-01-14 12:09:55.522] at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:350)
[2008-01-14 12:09:55.522] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[2008-01-14 12:09:55.522] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[2008-01-14 12:09:55.522] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[2008-01-14 12:09:55.522] at java.lang.Thread.run(Thread.java:619)

Notes
(0002648)
rilux   
01-14-08 04:21   
Seen here

http://bugs.caucho.com/view.php?id=850 [^]
http://bugs.caucho.com/view.php?id=419 [^]
(0002656)
ferg   
01-16-08 16:03   
These are fixed in the 3.1.x tree.

As a workaround in 3.0, you might need to switch to jdbc sessions.