Bug 1010976 - After 2 days of being UP, JON server runs out of database connections
Summary: After 2 days of being UP, JON server runs out of database connections
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Operations Network
Classification: JBoss
Component: Database
Version: JON 3.2
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ER02
: JON 3.2.0
Assignee: John Sanda
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On:
Blocks: jon32-Beta-Blockers-1006862 1012435
TreeView+ depends on / blocked
 
Reported: 2013-09-23 12:38 UTC by Libor Zoubek
Modified: 2015-11-02 00:43 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-01-02 20:33:06 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1009640 0 unspecified CLOSED JDBC connections leaked during baseline calculations 2021-02-22 00:41:40 UTC

Internal Links: 1009640

Description Libor Zoubek 2013-09-23 12:38:55 UTC 
Description of problem: I am hitting ResourceException: IJ000655 when my JON server runs +- 2 days. After this amount of time, server is unable to log me in through UI and server log is full of messages like:

Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/RHQDS
        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390)
        at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)
        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
        ... 86 more
Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (300
00 [ms])

When I stopped server, I got a lot of these warnings

22:40:09,241 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (MSC service thread 1-1) IJ000615: Destroying active connection in pool: RHQDS (org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@8b3d9a0)


so it looks like there is a bug in code that does not close connections properly.

Version-Release number of selected component (if applicable):
JON 3.2.ER1

How reproducible: so far always


Additional info: I am hitting this behavior on both Windows x64 and Linux environments.
Comment 2 John Sanda 2013-09-23 13:06:53 UTC 
I think that this is the same as bug 1009640 which will be fixed in ER2.
Comment 3 Heiko W. Rupp 2013-09-27 09:58:48 UTC 
Setting target according to comment 2
Comment 5 Libor Zoubek 2013-10-04 07:02:31 UTC 
verified on JON 3.2.0.ER02
Note You need to log in before you can comment on or make changes to this bug.