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

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ 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

Status

closed

Product Version

3.0.22

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.

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.