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)