Error on persisting layer

Camunda 7 Topics
1

I encountered an error with my engine.

24-Jan-2024 07:24:51.438 SEVERE [http-nio-8080-exec-3] org.camunda.commons.logging.BaseLogger.logError ENGINE-16004 Exception while closing command context: An exception occurred in the persistence laye org.camunda.bpm.engine.ProcessEnginePersistenceException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace

    Caused by: org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting:### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Authorization.xml

The error may involve org.camunda.bpm.engine.impl.persistence.entity.AuthorizationEntity.selectAuthorizedGroupIds

The error occurred while executing a query

Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: java.sql.S

Here’s my Docker configuration for Camunda:

  • Camunda: 7.20
  • MariaDB: 10.6.12
  • Driver: mariadb-java-client-3.3.2.jar (latest driver)
  • autoCommit is set to 1.

Here are my en variables on Plesk panel

image
image811×855 39.9 KB

Does anyone have any insights into this issue? I have to restart the container every day to resolve this exception.

2

As the error clearly states it’s problem with the driver. Try downgrading the driver version to 3.0 and test it out.

https://mariadb.com/kb/en/about-mariadb-connector-j/#:~:text=MariaDB%20Connector%2FJ%20is%20used,The%20library%20is%20LGPL%20licensed.