Getting Error on Prod env only java sql SQLNonTransientConnection

navrajyadav · March 1, 2019, 12:48pm

Hello Guys,

we deployed our spring boot 2 application with camunda workflow to prod env recently. but we are getting the below errors sometime while doing some processing on camunda end.

We are facing strange issues on production env only. Till UAT everything was fine. I am not able to understand why we are getting these issues on production env only.

Initially when we start deploying the application on production env, camunda was not able to create/insert its tables. And after spending complete day we just tried to update the mariadb jdbc jar to later version then we were able to deploy it on production. But the strange thing is same old jar is working fine on lower env without any single issue.

Environment Details : PCF cloud
DB : Maria DB 10.1.31-MariaDB
Camunda : 7.9.0
Spring boot: 2.0.1.RELEASE

I am not able to find out the root cause of the same. Could anyone please help me out to resolve this issue?

Your prompt help will be highly appreciable .

Below logs are printed in descending order.

09:15:54.517 [http-nio-8080-exec-7] INFO c.d.c.c.delegate.EndTaskAdapter - Update result true
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute-Inline
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.io.output.StandardPacketOutputStream.flushBuffer(StandardPacketOutputStream.java:111)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:60)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Job.xml
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error occurred while setting parameters
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Cause: java.sql.SQLNonTransientConnectionException: (conn=78562) Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:95)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:177)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:54)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:104)
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: java.sql.SQLNonTransientConnectionException: (conn=78562) Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
ab4df890-2df3-46b7-bee7-85251518533f OUT … 19 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: java.sql.SQLNonTransientConnectionException: Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:1894)
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: org.apache.ibatis.exceptions.PersistenceException:
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream.flush(AbstractPacketOutputStream.java:185)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:93)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: java.net.SocketException: Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:148)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:173)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Error querying database. Cause: java.sql.SQLNonTransientConnectionException: (conn=78562) Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### SQL: select RES.* from ACT_RU_JOB RES where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < ?) and RES.SUSPENSION_STATE_ = 1 and ( ( RES.EXCLUSIVE_ = 1 and not exists( select J2.* from ACT_RU_JOB J2 where J2.PROCESS_INSTANCE_ID_ = RES.PROCESS_INSTANCE_ID_ – from the same proc. inst. and (J2.EXCLUSIVE_ = 1) – also exclusive and (J2.LOCK_OWNER_ is not null and J2.LOCK_EXP_TIME_ >= ?) – in progress ) ) or RES.EXCLUSIVE_ = 0 ) LIMIT ? OFFSET ?
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:221)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:286)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
ab4df890-2df3-46b7-bee7-85251518533f OUT … 31 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:113)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:157)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:154)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:191)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:34)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
ab4df890-2df3-46b7-bee7-85251518533f OUT … 8 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:234)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.lang.Thread.run(Thread.java:748)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:230)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:293)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:169)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:66)
ab4df890-2df3-46b7-bee7-85251518533f OUT 09:15:53.257 [JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]] ERROR org.camunda.bpm.engine.jobexecutor - ENGINE-14019 Exception during job acquisition Process engine persistence exception
ab4df890-2df3-46b7-bee7-85251518533f OUT org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.net.SocketOutputStream.socketWrite0(Native Method)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.acquireJobs(SequentialJobAcquisitionRunnable.java:142)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165)
ab4df890-2df3-46b7-bee7-85251518533f OUT … 30 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: java.sql.SQLNonTransientConnectionException: Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.io.output.StandardPacketOutputStream.flushBuffer(StandardPacketOutputStream.java:111)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:221)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:286)
ab4df890-2df3-46b7-bee7-85251518533f OUT … 31 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: java.net.SocketException: Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:293)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.net.SocketOutputStream.socketWrite0(Native Method)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:1894)
ab4df890-2df3-46b7-bee7-85251518533f OUT … 30 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream.flush(AbstractPacketOutputStream.java:185)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error occurred while setting parameters
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:169)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:93)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:34)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:234)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Error querying database. Cause: java.sql.SQLNonTransientConnectionException: (conn=78562) Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error occurred while setting parameters
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:54)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:104)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.lang.Thread.run(Thread.java:748)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Job.xml
ab4df890-2df3-46b7-bee7-85251518533f OUT ### SQL: select RES.* from ACT_RU_JOB RES where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < ?) and RES.SUSPENSION_STATE_ = 1 and ( ( RES.EXCLUSIVE_ = 1 and not exists( select J2.* from ACT_RU_JOB J2 where J2.PROCESS_INSTANCE_ID_ = RES.PROCESS_INSTANCE_ID_ – from the same proc. inst. and (J2.EXCLUSIVE_ = 1) – also exclusive and (J2.LOCK_OWNER_ is not null and J2.LOCK_EXP_TIME_ >= ?) – in progress ) ) or RES.EXCLUSIVE_ = 0 ) LIMIT ? OFFSET ?
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Job.xml
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:95)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:177)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:165)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:230)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:157)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.acquireJobs(SequentialJobAcquisitionRunnable.java:142)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
ab4df890-2df3-46b7-bee7-85251518533f OUT org.apache.ibatis.exceptions.PersistenceException:
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute-Inline
ab4df890-2df3-46b7-bee7-85251518533f OUT 09:15:53.256 [JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]] ERROR org.camunda.bpm.engine.context - ENGINE-16004 Exception while closing command context:
ab4df890-2df3-46b7-bee7-85251518533f OUT … 19 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Cause: java.sql.SQLNonTransientConnectionException: (conn=78562) Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:66)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:191)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:60)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### SQL: select RES.* from ACT_RU_JOB RES where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < ?) and RES.SUSPENSION_STATE_ = 1 and ( ( RES.EXCLUSIVE_ = 1 and not exists( select J2.* from ACT_RU_JOB J2 where J2.PROCESS_INSTANCE_ID_ = RES.PROCESS_INSTANCE_ID_ – from the same proc. inst. and (J2.EXCLUSIVE_ = 1) – also exclusive and (J2.LOCK_OWNER_ is not null and J2.LOCK_EXP_TIME_ >= ?) – in progress ) ) or RES.EXCLUSIVE_ = 0 ) LIMIT ? OFFSET ?
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Cause: java.sql.SQLNonTransientConnectionException: (conn=78562) Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Error querying database. Cause: java.sql.SQLNonTransientConnectionException: (conn=78562) Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: java.sql.SQLNonTransientConnectionException: (conn=78562) Broken pipe (Write failed)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute-Inline
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:154)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
ab4df890-2df3-46b7-bee7-85251518533f OUT 09:15:48.458 [http-nio-8080-exec-7] INFO c.d.c.c.delegate.EndTaskAdapter - Actimize webservice parameters statusIdentifier :: 4 :: Justification

navrajyadav · March 4, 2019, 5:13am

Hi All,

Expecting a prompt response. Please help me out in this.

Yana · March 4, 2019, 8:15am

Hi,

Which isolation level is setup on the db? (1)
Which is the version of the jdbc driver?
Also could you please try to reproduce the issue with MariaDB 10.0 or 10.2, which are the versions supported by Camunda.

(1): https://docs.camunda.org/manual/7.10/user-guide/process-engine/database/#isolation-level-configuration

navrajyadav · March 5, 2019, 1:59pm

Hi Yana,

Thanks for the response.

PFB the required details.

Isolation level:
@@Global.tx_isolation, @@tx_isolation
READ-COMMITTED, REPEATABLE-READ
JDBC driver version:
mariadb-java-client:2.4.0
We have not faced any issue on lower environment for the same Maria DB 10.1.31-MariaDB
only the difference is in prod we have master and slave on DB but don’t have it on lower env. This is an InnoDB

Your prompt response will be highly appreciable.

Thank You

Yana · March 6, 2019, 7:55am

Hi,

Please make sure that the isolation level is set to READ-COMMITTED, not only as a global setting but transaction as well.
Could you please explain in more details the setup of your production setup - we have master and slave on DB
My personal opinion is that you need to switch some of the supported versions of MariaDB.
I am not a MariaDB expert but I checked that there are some reported known issues on 10.1 similar to what you have described.

navrajyadav · March 29, 2019, 10:58am

What are the MariaDB versions supported by camunda? Where i can check the same?

MichiDahm · March 29, 2019, 11:00am

Hi @navrajyadav,

the list with the supported environments can be found here.

Regards
Michael

navrajyadav · March 29, 2019, 11:07am

Thanks @MichiDahm for the prompt response

aravindhrs · March 29, 2019, 3:47pm

@Yana, how will you set the isolation level for transaction in MySQL database?

system · January 30, 2024, 11:36am