0000419: Transaction timeout problems with cluster and file sessions store

Notes
(0000466) sam 10-10-05 00:00	(rep by K Fetterman) [18:26:21.479] java.sql.SQLException: transaction timed out waiting for lock 1020 [18:26:21.479] at com.caucho.db.store.Lock.queue(Lock.java:348) [18:26:21.479] at com.caucho.db.store.Lock.queue(Lock.java:315) [18:26:21.479] at com.caucho.db.store.Lock.lockReadAndUpgrade(Lock.java:190) [18:26:21.479] at com.caucho.db.store.Transaction.lockAutoCommitWrite(Transaction.java:240) [18:26:21.479] at com.caucho.db.sql.UpdateQuery.execute(UpdateQuery.java:106) and [02:04:07.890] Can't store session default;aaOhVCTnmiK4OvGNuB [02:04:09.417] Can't store session default;aExvxLlqRB8eunHNuB [02:04:09.417] Can't store session default;a4WG8jzTMN74i9HNuB Since a JSP file is referenced in the stack trace, I looked at the Java source file at line 22. The Java source statement is below: [18:26:21.479] at _jsp._meeting__jsp._jspService(_greeting__jsp.java:22) javax.servlet.http.HttpSession session = request.getSession(true);

(0000467) keithdfetterman 10-10-05 00:00	I want to add another example of the problem. The code that was executed at [2005-10-15 22:55:12.655] at com.marinersupply.bean.CustomerBean.logout(CustomerBean.java:406) was: session.invalidate(); This is the Exception/stacktrace that was the result when the invalidate() method failed: [2005-10-15 22:55:12.655] java.sql.SQLException: transaction timed out waiting for lock 3060 [2005-10-15 22:55:12.655] at com.caucho.db.store.Lock.queue(Lock.java:348) [2005-10-15 22:55:12.655] at com.caucho.db.store.Lock.queue(Lock.java:315) [2005-10-15 22:55:12.655] at com.caucho.db.store.Lock.lockReadAndUpgrade(Lock.java:190) [2005-10-15 22:55:12.655] at com.caucho.db.store.Transaction.lockAutoCommitWrite(Transaction.java:240) [2005-10-15 22:55:12.655] at com.caucho.db.sql.DeleteQuery.execute(DeleteQuery.java:82) [2005-10-15 22:55:12.655] at com.caucho.db.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:349) [2005-10-15 22:55:12.655] at com.caucho.db.jdbc.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:325) [2005-10-15 22:55:12.655] at com.caucho.server.cluster.FileBacking.remove(FileBacking.java:375) [2005-10-15 22:55:12.655] at com.caucho.server.cluster.FileStore.remove(FileStore.java:189) [2005-10-15 22:55:12.655] at com.caucho.server.cluster.ClusterObject.remove(ClusterObject.java:421) [2005-10-15 22:55:12.655] at com.caucho.server.session.SessionImpl.invalidateImpl(SessionImpl.java:590) [2005-10-15 22:55:12.655] at com.caucho.server.session.SessionImpl.invalidate(SessionImpl.java:545) [2005-10-15 22:55:12.655] at com.caucho.server.session.SessionImpl.invalidate(SessionImpl.java:506) [2005-10-15 22:55:12.655] at com.marinersupply.bean.CustomerBean.logout(CustomerBean.java:406) [2005-10-15 22:55:12.655] at com.marinersupply.servlet.actions.NewCommercialCustomer.doAction(NewCommercialCustomer.java:62) [2005-10-15 22:55:12.655] at com.marinersupply.servlet.Control.service(Control.java:164) [2005-10-15 22:55:12.655] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92) [2005-10-15 22:55:12.655] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:99) [2005-10-15 22:55:12.655] at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:175) [2005-10-15 22:55:12.655] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:163) [2005-10-15 22:55:12.655] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:208) [2005-10-15 22:55:12.655] at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:396) [2005-10-15 22:55:12.655] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:363) [2005-10-15 22:55:12.655] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490) [2005-10-15 22:55:12.655] at com.caucho.util.ThreadPool.run(ThreadPool.java:423) [2005-10-15 22:55:12.655] at java.lang.Thread.run(Thread.java:534)

(0000529) arvoreen 12-08-05 06:51	Why was this issue closed with no resolution or comments?

(0000530) ferg 12-08-05 07:37	Fixed in 3.0.15. If a related problem occurs, please file it against 3.0.15, not 3.0.14.

Issue History
Date Modified	Username	Field	Change
10-10-05 00:00	arvoreen	New Issue
12-07-05 15:25	ferg	Status	acknowledged => closed
12-08-05 06:51	arvoreen	Status	closed => feedback
12-08-05 06:51	arvoreen	Resolution	open => reopened
12-08-05 06:51	arvoreen	Note Added: 0000529
12-08-05 07:37	ferg	Status	feedback => closed
12-08-05 07:37	ferg	Note Added: 0000530
02-12-06 21:52	keisuk-t	Issue Monitored: keisuk-t

Relationships