Hi Micheal, Seems like you are exhausting all the JDBC connections in the pool. The below log message indicates it.
Caused by: java.sql.SQLException: unable to get a connection from pool of a PoolingDataSource containing an XAPool of resource jdbc/ode with 5 connection(s) (0 still available) Share the configurations settings of ODE. What is the load that you are testing with? regards, sathwik On Mon, Jan 20, 2014 at 7:51 PM, Servaas, M. (Michael) < [email protected]> wrote: > I've removed Bitronix from the config (INTERNAL db). This results in the > following exception: > > 15:17:33,167 ERROR [BpelEngineImpl] Scheduled job failed; > jobDetail=JobDetails( instanceId: null mexId: 705598 processId: > {http://www.example.com/docloket/}docloket-4 type: INVOKE_INTERNAL > channel: null correlatorId: null correlationKeySet: null retryCount: > null inMem: false detailsExt: {}) > org.hibernate.exception.LockAcquisitionException: could not execute > query > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java > :87) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. > java:43) > at org.hibernate.loader.Loader.doList(Loader.java:2147) > at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) > at org.hibernate.loader.Loader.list(Loader.java:2023) > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) > at > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: > 338) > at > org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:17 > 2) > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) > at > org.apache.ode.daohib.bpel.CorrelatorDaoImpl.findRoute(CorrelatorDaoImpl > .java:143) > at > org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.findRoute(PartnerLinkMy > RoleImpl.java:140) > at > org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:23 > 3) > at > org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:27 > 9) > at > org.apache.ode.bpel.engine.BpelProcess.handleJobDetails(BpelProcess.java > :426) > at > org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl. > java:460) > at > org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl. > java:450) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleSche > duler.java:523) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleSche > duler.java:517) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleSc > heduler.java:289) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleSc > heduler.java:244) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleSchedu > ler.java:517) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleSchedu > ler.java:501) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto > r.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja > va:908) > at java.lang.Thread.run(Thread.java:662) > Caused by: java.sql.SQLException: ORA-00060: deadlock detected while > waiting for resource > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:505) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav > a:207) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedSt > atement.java:884) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement. > java:1167) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1288) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3593) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt > atement.java:3637) > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePre > paredStatementWrapper.java:1495) > at > org.tranql.connector.jdbc.PreparedStatementHandle.executeQuery(PreparedS > tatementHandle.java:49) > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186 > ) > at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) > at org.hibernate.loader.Loader.doQuery(Loader.java:662) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade > r.java:224) > at org.hibernate.loader.Loader.doList(Loader.java:2144) > ... 25 more > > Seems the TM is not to blame. > > Regards, > > Michael > > ________________________________ > > Van: Servaas, M. (Michael) > Verzonden: 20 januari 2014 14:59 > Aan: '[email protected]' > Onderwerp: Transaction timeouts under heavy load > > > Hi, > > I'm encountering, seemingly random, transaction timeouts with my ODE > process under heavy load (10 requests/second). I say 'seemingly random', > because sometimes the test run completes without problems and the next > time it will crash early in the run. Not sure if this is an ODE problem > or related to Bitronix TM, but you'll probably be able to help with > that. > > Attached you'll find some of the exceptions that were thrown. > > I'm running Apache ODE 1.3.6 with Hibernate 3.2.0 GA on Tomcat 7 with > Bitronix 2.1.4. > My Bitronix config is: > > resource.ds1.className=oracle.jdbc.xa.client.OracleXADataSource > resource.ds1.uniqueName=jdbc/ode > resource.ds1.minPoolSize=0 > resource.ds1.maxPoolSize=50 > resource.ds1.driverProperties.URL=jdbc:oracle:thin:@<omitted> > resource.ds1.driverProperties.user=ode > resource.ds1.driverProperties.password=ode > resource.ds1.allowLocalTransactions=true > resource.ds1.shareTransactionConnections=true > resource.ds1.acquisitionTimeout=120 > > I'm able to provide more info if needed. > > Regards, > > Michael > > -------------------------Disclaimer------------------------------- > De informatie verzonden met dit e-mailbericht (en bijlagen) is uitsluitend > bestemd voor de geadresseerde(n) en zij die van de geadresseerde(n) > toestemming kregen dit bericht te lezen. Gebruik door anderen dan > geadresseerde(n) is verboden. De informatie in dit e-mailbericht (en > bijlagen) kan vertrouwelijk van aard zijn en kan binnen het bereik vallen > van een geheimhoudingsplicht en een verschoningsrecht. > ------------------------------------------------------------------- >
