0001495: continuous errors with dangling connections in amber when using cmp relations

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001495

[Resin]

major

always

12-06-06 05:41

12-07-06 11:59

Reporter

plehov

View Status

public

Assigned To

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.0

Product Version

3.0.22

Product Build

Summary

0001495: continuous errors with dangling connections in amber when using cmp relations

Description

Our CMP code works in resin 2 without errors
In resin 3 we get this error and connection pull become full.

running example from "resin-doc/cmp/tutorial/cmp-one2one/client" give the same error.

Steps To Reproduce

Additional Information

[15:31:54.215] Closing dangling connections. All connections must have a close() in a finally block.
[15:31:54.216] java.lang.IllegalStateException: unclosed connection: UserPoolItem[jdbc/resin,23] was allocated at
[15:31:54.216] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:112)
[15:31:54.216] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:118)
[15:31:54.216] at com.caucho.jca.PoolItem.toActive(PoolItem.java:256)
[15:31:54.216] at com.caucho.jca.ConnectionPool.create(ConnectionPool.java:791)
[15:31:54.216] at com.caucho.jca.ConnectionPool.allocatePool(ConnectionPool.java:649)
[15:31:54.216] at com.caucho.jca.ConnectionPool.allocate(ConnectionPool.java:608)
[15:31:54.216] at com.caucho.jca.ConnectionPool.allocateConnection(ConnectionPool.java:505)
[15:31:54.216] at com.caucho.sql.DataSourceImpl.getConnection(DataSourceImpl.java:65)
[15:31:54.216] at com.caucho.sql.DBPool.getConnection(DBPool.java:624)
[15:31:54.216] at com.caucho.amber.manager.AmberConnection.getConnection(AmberConnection.java:974)
[15:31:54.216] at com.caucho.amber.manager.AmberConnection.prepareStatement(AmberConnection.java:1004)
[15:31:54.216] at com.caucho.amber.query.UserQuery.executeQuery(UserQuery.java:375)
[15:31:54.216] at com.caucho.amber.query.UserQuery.executeQuery(UserQuery.java:341)
[15:31:54.216] at com.caucho.amber.query.UserQuery.getSingleResult(UserQuery.java:454)
[15:31:54.216] at _ejb.one2one_courses.CourseBean__Amber.getTeacher(CourseBean__Amber.java:87)
[15:31:54.216] at _ejb.one2one_courses.CourseBean__EJB$Local.getTeacher(CourseBean__EJB.java:372)
[15:31:54.216] at example.cmp.one2one.ClientServlet.service(ClientServlet.java:77)
[15:31:54.216] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
[15:31:54.216] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
[15:31:54.216] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
[15:31:54.216] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[15:31:54.216] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
[15:31:54.216] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[15:31:54.216] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[15:31:54.216] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[15:31:54.216] at java.lang.Thread.run(Thread.java:595)
[15:31:54.219] java.lang.IllegalStateException: unclosed connection: UserPoolItem[jdbc/resin,21] was allocated at
[15:31:54.219] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:112)
[15:31:54.219] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:118)
[15:31:54.219] at com.caucho.jca.PoolItem.toActive(PoolItem.java:256)
[15:31:54.219] at com.caucho.jca.ConnectionPool.create(ConnectionPool.java:791)
[15:31:54.219] at com.caucho.jca.ConnectionPool.allocatePool(ConnectionPool.java:649)
[15:31:54.219] at com.caucho.jca.ConnectionPool.allocate(ConnectionPool.java:608)
[15:31:54.219] at com.caucho.jca.ConnectionPool.allocateConnection(ConnectionPool.java:505)
[15:31:54.219] at com.caucho.sql.DataSourceImpl.getConnection(DataSourceImpl.java:65)
[15:31:54.219] at com.caucho.sql.DBPool.getConnection(DBPool.java:624)
[15:31:54.219] at com.caucho.amber.manager.AmberConnection.getConnection(AmberConnection.java:974)
[15:31:54.219] at com.caucho.amber.manager.AmberConnection.prepareStatement(AmberConnection.java:1004)
[15:31:54.219] at com.caucho.amber.query.UserQuery.executeQuery(UserQuery.java:375)
[15:31:54.219] at com.caucho.amber.query.UserQuery.executeQuery(UserQuery.java:341)
[15:31:54.219] at com.caucho.amber.query.UserQuery.getSingleResult(UserQuery.java:454)
[15:31:54.219] at _ejb.one2one_courses.CourseBean__Amber.getTeacher(CourseBean__Amber.java:87)
[15:31:54.219] at _ejb.one2one_courses.CourseBean__EJB$Local.getTeacher(CourseBean__EJB.java:372)
[15:31:54.219] at example.cmp.one2one.ClientServlet.service(ClientServlet.java:77)
[15:31:54.219] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
[15:31:54.219] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
[15:31:54.219] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
[15:31:54.219] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[15:31:54.219] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
[15:31:54.219] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[15:31:54.219] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[15:31:54.219] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[15:31:54.219] at java.lang.Thread.run(Thread.java:595)
[15:31:54.222] java.lang.IllegalStateException: unclosed connection: UserPoolItem[jdbc/resin,19] was allocated at
[15:31:54.222] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:112)
[15:31:54.222] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:118)
[15:31:54.222] at com.caucho.jca.PoolItem.toActive(PoolItem.java:256)
[15:31:54.222] at com.caucho.jca.ConnectionPool.allocateIdle(ConnectionPool.java:724)
[15:31:54.222] at com.caucho.jca.ConnectionPool.allocatePool(ConnectionPool.java:643)
[15:31:54.222] at com.caucho.jca.ConnectionPool.allocate(ConnectionPool.java:608)
[15:31:54.222] at com.caucho.jca.ConnectionPool.allocateConnection(ConnectionPool.java:505)
[15:31:54.222] at com.caucho.sql.DataSourceImpl.getConnection(DataSourceImpl.java:65)
[15:31:54.222] at com.caucho.sql.DBPool.getConnection(DBPool.java:624)
[15:31:54.222] at com.caucho.amber.manager.AmberConnection.getConnection(AmberConnection.java:974)
[15:31:54.222] at com.caucho.amber.manager.AmberConnection.prepareStatement(AmberConnection.java:1004)
[15:31:54.222] at com.caucho.amber.query.UserQuery.executeQuery(UserQuery.java:375)
[15:31:54.222] at com.caucho.amber.query.UserQuery.executeQuery(UserQuery.java:341)
[15:31:54.222] at com.caucho.amber.query.UserQuery.getSingleResult(UserQuery.java:454)
[15:31:54.222] at _ejb.one2one_courses.CourseBean__Amber.getTeacher(CourseBean__Amber.java:87)
[15:31:54.222] at _ejb.one2one_courses.CourseBean__EJB$Local.getTeacher(CourseBean__EJB.java:372)
[15:31:54.222] at example.cmp.one2one.ClientServlet.service(ClientServlet.java:77)
[15:31:54.222] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
[15:31:54.222] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
[15:31:54.222] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
[15:31:54.222] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[15:31:54.222] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
[15:31:54.222] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[15:31:54.222] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[15:31:54.222] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[15:31:54.222] at java.lang.Thread.run(Thread.java:595)
[15:31:54.225] java.lang.IllegalStateException: Connection UserConnection[com.caucho.sql.ManagedConnectionImpl@faa550] was not closed. Connections must have a close() in a finally block.
[15:31:54.225] at com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.java:497)
[15:31:54.225] at com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProxy.java:183)
[15:31:54.225] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:193)
[15:31:54.225] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[15:31:54.225] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
[15:31:54.225] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[15:31:54.225] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[15:31:54.225] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[15:31:54.225] at java.lang.Thread.run(Thread.java:595)

Attached Files

Relationships

Notes
(0001643) westrupp 12-07-06 11:59	Fixed in 3.1.0 - ejb/0a0b (Rodrigo Westrupp).

Issue History
Date Modified	Username	Field	Change
12-06-06 05:41	plehov	New Issue
12-07-06 11:59	westrupp	Status	new => closed
12-07-06 11:59	westrupp	Note Added: 0001643
12-07-06 11:59	westrupp	Resolution	open => fixed
12-07-06 11:59	westrupp	Fixed in Version	=> 3.1.0

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.