1 Reply Latest reply on Jun 12, 2019 12:24 PM by Ramesh Reddy

    Teiid connection timeout, only 2 connection in use - ARJUNA012117: TransactionReaper::check timeout

    anil kumar Newbie

      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)