Hi,
We are running the Camunda container with tag 7.8.0 in Azure. Ever 2 hours or so we get an Process engine persistence exception. This results in us deleting our container and redeploying it.
Here are our the logs we get from the container:
11-Apr-2018 11:40:45.045 SEVERE [Camunda Metrics Reporter] org.camunda.commons.logging.BaseLogger.logError ENGINE-16004 Exception while closing command context: ENGINE-03004 Exception while executing Database Operation ‘INS
ERT MeterLogEntity[2bd5fb33-3d7d-11e8-a0d6-0a580af47805]’ with message ’
Error updating database. Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: org.p
ostgresql.util.PSQLException: This connection has been closed.
Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: org.postgresql.util.PSQLExcepti
on: This connection has been closed.’. Flush summary:
[
INSERT MeterLogEntity[2bd5fb33-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb34-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb35-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb36-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb37-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb38-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb39-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb3a-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb3b-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb3c-3d7d-11e8-a0d6-0a580af47805]
]
org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation ‘INSERT MeterLogEntity[2bd5fb33-3d7d-11e8-a0d6-0a580af47805]’ with message ’
Error updating database. Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: org.p
ostgresql.util.PSQLException: This connection has been closed.
Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: org.postgresql.util.PSQLExcepti
on: This connection has been closed.’. Flush summary:
[
INSERT MeterLogEntity[2bd5fb33-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb34-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb35-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb36-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb37-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb38-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb39-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb3a-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb3b-3d7d-11e8-a0d6-0a580af47805]
INSERT MeterLogEntity[2bd5fb3c-3d7d-11e8-a0d6-0a580af47805]
]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:120)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:331)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:314)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:286)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:203)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:132)
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:113)
at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:66)
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
at org.camunda.bpm.engine.impl.metrics.reporter.MetricsCollectionTask.collectMetrics(MetricsCollectionTask.java:72)
at org.camunda.bpm.engine.impl.metrics.reporter.MetricsCollectionTask.run(MetricsCollectionTask.java:49)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
Error updating database. Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: org.p
ostgresql.util.PSQLException: This connection has been closed.
Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: org.postgresql.util.PSQLExcepti
on: This connection has been closed.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.executeInsertEntity(DbSqlSession.java:157)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.insertEntity(DbSqlSession.java:149)
at org.camunda.bpm.engine.impl.db.AbstractPersistenceSession.executeDbOperation(AbstractPersistenceSession.java:41)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:329)
… 11 more
Caused by: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: org.postgresql.util.PSQLExcepti
on: This connection has been closed.
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:107)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:142)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:60)
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
at org.apache.ibatis.executor.BatchExecutor.doUpdate(BatchExecutor.java:69)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
… 16 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:843)
at org.postgresql.jdbc2.AbstractJdbc2Connection.getAutoCommit(AbstractJdbc2Connection.java:804)
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:79)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at com.sun.proxy.$Proxy4.getAutoCommit(Unknown Source)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:98)
… 23 more