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.
-------------------------------------------------------------------
