0000998: continuous errors with dangling connections in amber

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000998

[Resin]

major

always

03-17-06 09:58

04-05-06 08:54

Reporter

nquery

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Status

closed

Product Version

3.0.18

Summary

0000998: continuous errors with dangling connections in amber

Description

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).

Additional Information

[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)

Attached Files

Relationships

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

Issue History
Date Modified	Username	Field	Change
03-17-06 09:58	nquery	New Issue
04-05-06 08:54	ferg	Note Added: 0001015
04-05-06 08:54	ferg	Assigned To	=> ferg
04-05-06 08:54	ferg	Status	new => closed
04-05-06 08:54	ferg	Resolution	open => fixed
04-05-06 08:54	ferg	Fixed in Version	=> 3.0.19

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.