Bug 1010976

Summary: After 2 days of being UP, JON server runs out of database connections
Product: [JBoss] JBoss Operations Network Reporter: Libor Zoubek <lzoubek>
Component: DatabaseAssignee: John Sanda <jsanda>
Status: CLOSED CURRENTRELEASE QA Contact: Mike Foley <mfoley>
Severity: urgent Docs Contact:
Priority: urgent    
Version: JON 3.2CC: hrupp, jsanda, theute
Target Milestone: ER02   
Target Release: JON 3.2.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-01-02 20:33:06 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1006862, 1012435    

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