|
Mantis - Resin
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 2323 | block | random | 01-14-08 04:19 | 01-16-08 16:03 | |
|
|
|||||
| Reporter: | rilux | Platform: | |||
| Assigned To: | ferg | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | closed | Product Version: | 3.0.23 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 3.1.4 | ||
|
|
|||||
| Summary: | 0002323: java.sql.SQLException: transaction timed out waiting for lock 226858 | ||||
| Description: | 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. | ||||
| Steps To Reproduce: | |||||
| Additional Information: |
[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) |
||||
| Relationships | |||||
| Attached Files: | |||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||