| Anonymous | Login | Signup for a new account | 12-17-2024 10:45 PST |
| Main | My View | View Issues | Change Log | Docs |
| Viewing Issue Simple Details [ Jump to Notes ] | [ View Advanced ] [ Issue History ] [ Print ] | ||||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||
| 0002323 | [Resin] | block | random | 01-14-08 04:19 | 01-16-08 16:03 | ||||
| Reporter | rilux | View Status | public | ||||||
| Assigned To | ferg | ||||||||
| Priority | normal | Resolution | fixed | ||||||
| Status | closed | Product Version | 3.0.23 | ||||||
| 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. | ||||||||
| 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) |
||||||||
| Attached Files | |||||||||
|
|
|||||||||
 Relationships |
|
|
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. |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 01-14-08 04:19 | rilux | New Issue | |
| 01-14-08 04:21 | rilux | Note Added: 0002648 | |
| 01-16-08 16:03 | ferg | Note Added: 0002656 | |
| 01-16-08 16:03 | ferg | Assigned To | => ferg |
| 01-16-08 16:03 | ferg | Status | new => closed |
| 01-16-08 16:03 | ferg | Resolution | open => fixed |
| 01-16-08 16:03 | ferg | Fixed in Version | => 3.1.4 |
| 04-16-08 22:38 | bjguan | Issue Monitored: bjguan | |
| Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
33 total queries executed. 28 unique queries executed. |  |
