Mantis - Resin
Viewing Issue Advanced Details
998 major always 03-17-06 09:58 04-05-06 08:54
nquery  
ferg  
normal  
closed 3.0.18  
fixed  
none    
none 3.0.19  
0000998: continuous errors with dangling connections in amber
code works in resin 2 without errors. while it happens with more than one bean, it seems to be more common with some than others (though this could just be due to the frequency that these beans are being used).
[09:33:45.807] Closing dangling connections. All connections must have a close() in a finally block.
[09:33:45.813] java.lang.IllegalStateException: unclosed connection: UserPoolItem[jdbc/webapp,3455] was allocated at
[09:33:45.813] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:112)
[09:33:45.813] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:118)
[09:33:45.813] at com.caucho.jca.PoolItem.toActive(PoolItem.java:256)
[09:33:45.813] at com.caucho.jca.ConnectionPool.allocateIdle(ConnectionPool.java:736)
[09:33:45.813] at com.caucho.jca.ConnectionPool.allocatePool(ConnectionPool.java:655)
[09:33:45.813] at com.caucho.jca.ConnectionPool.allocate(ConnectionPool.java:620)
[09:33:45.813] at com.caucho.jca.ConnectionPool.allocateConnection(ConnectionPool.java:517)
[09:33:45.813] at com.caucho.sql.DataSourceImpl.getConnection(DataSourceImpl.java:65)
[09:33:45.813] at com.caucho.sql.DBPool.getConnection(DBPool.java:602)
[09:33:45.813] at com.caucho.amber.connection.CacheConnectionImpl.getConnection(CacheConnectionImpl.java:306)
[09:33:45.813] at com.caucho.amber.connection.AmberConnectionImpl.prepareStatement(AmberConnectionImpl.java:711)
[09:33:45.813] at _ejb.symbolStats.SymbolStatsBean__Amber.__caucho_load_0(SymbolStatsBean__Amber.java:1237)
[09:33:45.813] at _ejb.symbolStats.SymbolStatsBean__Amber.__caucho_retrieve(SymbolStatsBean__Amber.java:1183)
[09:33:45.813] at com.caucho.amber.entity.AmberEntityHome.findEntityItem(AmberEntityHome.java:326)
[09:33:45.813] at com.caucho.ejb.entity.EntityServer.getContext(EntityServer.java:644)
[09:33:45.813] at _ejb.symbolStats.SymbolStatsBean__EJB$LocalHome.findByPrimaryKey(SymbolStatsBean__EJB.java:298)
[09:33:45.813] at com.quotemedia.lookup.Lookup.getSymbolStatsById(Lookup.java:80)
[09:33:45.813] at com.quotemedia.quotetools.helper.DataCacheAccessObject.getDetailedOptionsData(DataCacheAccessObject.java:753)
[09:33:45.813] at com.quotemedia.quotetools.control.GetOptionsAction.execute(GetOptionsAction.java:45)
[09:33:45.813] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
[09:33:45.813] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
[09:33:45.813] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
[09:33:45.813] at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
[09:33:45.813] at javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
[09:33:45.813] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
[09:33:45.813] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
[09:33:45.813] at com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.java:115)
[09:33:45.813] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[09:33:45.813] at com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl.java:481)
[09:33:45.813] at com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl.java:346)
[09:33:45.813] at com.quotemedia.quotetools.control.RedirectXMLServlet.doPost(RedirectXMLServlet.java:106)
[09:33:45.813] at javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
[09:33:45.813] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
[09:33:45.813] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
[09:33:45.813] at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:218)
[09:33:45.813] at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
[09:33:45.813] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178)
[09:33:45.813] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[09:33:45.813] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268)
[09:33:45.813] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
[09:33:45.813] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
[09:33:45.813] at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
[09:33:45.813] at java.lang.Thread.run(Thread.java:595)
[09:33:45.821] java.lang.IllegalStateException: unclosed connection: UserPoolItem[jdbc/webapp,3417] was allocated at
[09:33:45.821] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:112)
[09:33:45.821] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:118)
[09:33:45.821] at com.caucho.jca.PoolItem.toActive(PoolItem.java:256)
[09:33:45.821] at com.caucho.jca.ConnectionPool.allocateIdle(ConnectionPool.java:736)
[09:33:45.821] at com.caucho.jca.ConnectionPool.allocatePool(ConnectionPool.java:655)
[09:33:45.821] at com.caucho.jca.ConnectionPool.allocate(ConnectionPool.java:620)
[09:33:45.821] at com.caucho.jca.ConnectionPool.allocateConnection(ConnectionPool.java:517)
[09:33:45.821] at com.caucho.sql.DataSourceImpl.getConnection(DataSourceImpl.java:65)
[09:33:45.821] at com.caucho.sql.DBPool.getConnection(DBPool.java:602)
[09:33:45.821] at com.caucho.amber.connection.CacheConnectionImpl.getConnection(CacheConnectionImpl.java:306)
[09:33:45.821] at com.caucho.amber.connection.AmberConnectionImpl.prepareStatement(AmberConnectionImpl.java:711)
[09:33:45.821] at _ejb.symbolStats.SymbolStatsBean__Amber.__caucho_load_0(SymbolStatsBean__Amber.java:1237)
[09:33:45.821] at _ejb.symbolStats.SymbolStatsBean__Amber.__caucho_retrieve(SymbolStatsBean__Amber.java:1183)
[09:33:45.821] at com.caucho.amber.entity.AmberEntityHome.findEntityItem(AmberEntityHome.java:326)
[09:33:45.821] at com.caucho.ejb.entity.EntityServer.getContext(EntityServer.java:644)
[09:33:45.821] at _ejb.symbolStats.SymbolStatsBean__EJB$LocalHome.findByPrimaryKey(SymbolStatsBean__EJB.java:298)
[09:33:45.821] at com.quotemedia.lookup.Lookup.getSymbolStatsById(Lookup.java:80)
[09:33:45.821] at com.quotemedia.quotetools.helper.DataCacheAccessObject.getDetailedOptionsData(DataCacheAccessObject.java:753)
[09:33:45.821] at com.quotemedia.quotetools.control.GetOptionsAction.execute(GetOptionsAction.java:45)
[09:33:45.821] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
[09:33:45.821] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
[09:33:45.821] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
[09:33:45.821] at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
[09:33:45.821] at javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
[09:33:45.821] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
[09:33:45.821] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
[09:33:45.821] at com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.java:115)
[09:33:45.821] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[09:33:45.821] at com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl.java:481)
[09:33:45.821] at com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl.java:346)
[09:33:45.821] at com.quotemedia.quotetools.control.RedirectXMLServlet.doPost(RedirectXMLServlet.java:106)
[09:33:45.821] at javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
[09:33:45.821] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
[09:33:45.821] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
[09:33:45.821] at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:218)
[09:33:45.821] at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
[09:33:45.821] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178)
[09:33:45.821] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[09:33:45.821] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268)
[09:33:45.821] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
[09:33:45.821] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
[09:33:45.821] at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
[09:33:45.821] at java.lang.Thread.run(Thread.java:595)
[09:33:45.826] java.lang.IllegalStateException: Connection UserConnection[com.caucho.sql.ManagedConnectionImpl@152643] was not closed. Connections must have a close() in a finally block.
[09:33:45.826] at com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.java:466)
[09:33:45.826] at com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProxy.java:174)
[09:33:45.826] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:198)
[09:33:45.826] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[09:33:45.826] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268)
[09:33:45.826] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
[09:33:45.826] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
[09:33:45.826] at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
[09:33:45.826] at java.lang.Thread.run(Thread.java:595)

Notes
(0001015)
ferg   
04-05-06 08:54   
The CacheConnection cannot be reused.