Teiid connection timeout, only 2 connection in use - ARJUNA012117: TransactionReaper::check timeout
We are trying to connect local db instances. we have user xa data-source for this. for small transaction it is working fine. but for large transaction > 1min. it gives ARJUNA012117: TransactionReaper::check timeout. I checked with 'netstat' command and it shows 23 and 45 connection for both DB. I checked other post but it is not helpful.
My question is why there is not connection available to teiid. How can we free connections?
We set teiid properties as follow
setautocommit : false
<xa-pool> <min-pool-size>10</min-pool-size> <max-pool-size>20</max-pool-size> <flush-strategy>FailingConnectionOnly</flush-strategy> </xa-pool>
<timeout> <blocking-timeout-millis>30000</blocking-timeout-millis> <idle-timeout-minutes>1</idle-timeout-minutes> </timeout>
Exception we are getting
erialized view table #MAT_PG_CATALOG.PG_ATTRIBUTE with row count 1,521.
11:14:04,208 WARN [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012117: TransactionReaper::check timeout for
TX 0:ffff0a8e000b:-3598d462:5d00dcd1:20 in state RUN
11:14:04,210 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012095: Abort of action id 0:ffff0a8e000b:-3598d462:5d00dcd1:20 invoked while multiple threads active within it.
11:14:04,212 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012381: Action id 0:ffff0a8e000b:-3
598d462:5d00dcd1:20 completed with multiple threads - thread Worker0_QueryProcessorQueue58 was in progress with jav
a.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
11:14:04,213 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012108: CheckedAction::check - atom
ic action 0:ffff0a8e000b:-3598d462:5d00dcd1:20 aborting with 1 threads active!
11:14:04,710 WARN [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012117: TransactionReaper::check timeout for
TX 0:ffff0a8e000b:-3598d462:5d00dcd1:20 in state CANCEL
11:14:04,711 WARN [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012378: ReaperElement appears to be wedged:
sun.misc.Unsafe.park(Native Method)
java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:836)
java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireQueued(AbstractQueuedSynchronizer.java:870)
java.util.concurrent.locks.AbstractQueuedSynchronizer.acquire(AbstractQueuedSynchronizer.java:1199)
java.util.concurrent.locks.ReentrantLock$FairSync.lock(ReentrantLock.java:224)
java.util.concurrent.locks.ReentrantLock.lock(ReentrantLock.java:285)
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.lock(BaseWrapperManagedConnection.java:374)
org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:290)
org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.end(XAResourceWrapperImpl.java:118)
