Hi,
I am checking my JBoss log and found this log printed quite often:
11:14:13,726 DEBUG [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (EMailTimerTask) Unfinished local transaction was rolled back.org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@68f2e074[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@216e1580 connection handles=0 lastUse=1551755648750 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@6c0103d2 pool internal context=SemaphoreArrayListManagedConnectionPool@5f47cf2e[pool=tmsds] xaResource=LocalXAResourceImpl@424597a5[connectionListener=68f2e074 connectionManager=4793109a warned=false currentXid=null] txSync=null]
After running for a few days, the JBoss will fail to grab managed connection from the pool causing the application to stop working.
My question, does the error above correlates with the issue connection pool being full?
In my code, I am creating new EntityManager, begin transaction, and commit the transaction before closing the entity manager. I'm wondering if the above message indicates that somewhere inside the code I miss connection closing call.
As this issue happened in production environment but not in our testing environment, it has been quite a pain to detect the source of the problem.
Please advise on this issue. I have attached as well the log file.
Thanks
