Issue with Camunda using read only database - Java integration

Camunda 7 Topics Discussion & Questions
1

The issue is the following. I am using Camunda for sending emails in a Java Spring API 15.2

One of the environments is using a read only database instance and that is causing problems because Camunda is trying to insert some logs.

Here is the error:

> Error querying database. Cause: java.sql.SQLException: The MySQL server is running with the --read-only option so it cannot execute this statement

The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Property.xml The error may involve defaultParameterMap The error occurred while setting parameters SQL: SELECT VALUE_ FROM ACT_GE_PROPERTY WHERE NAME_ = ‘deployment.lock’ for update Cause: java.sql.SQLException: The MySQL server is running with the --read-only option so it

I have tried the following:

  • Add a new file in the resources folder bpm-platform.xml
  <?xml version="1.0" encoding="UTF-8"?>

  <job-executor>
      <job-acquisition name="default" />
  </job-executor>

  <process-engine name="default">
      <job-acquisition>default</job-acquisition>
      <configuration>org.camunda.bpm.engine.impl.cfg.StandaloneProcessEngineConfiguration</configuration>
      <datasource>java:jdbc/ProcessEngine</datasource>

      <properties>
          <property name="metricsEnabled">false</property>
          <property name="taskMetricsEnabled">false</property>
      </properties>

  </process-engine>
  • Add a new file in the resources folder camunda.cfg.xml
  <bean id="processEngineConfiguration" class="org.camunda.bpm.engine.impl.cfg.StandaloneInMemProcessEngineConfiguration">

      <!-- Empty beans map to for testing purpose -->
      <property name="beans">
          <map/>
      </property>

      <property name="processEnginePlugins">
          <list>
              <bean class="io.powertask.slack.camunda.plugin.TaskListenerPlugin" />
          </list>
      </property>
      <property name="jobExecutorActivate" value="false" />
      <property name="dbMetricsReporterActivate" value="false" />
      <property name="historyLevel" value="HISTORY_LEVEL_NONE" />
      <property name="metricsEnabled" value="false"/>
      <property name="taskMetricsEnabled" value="false"/>
  </bean>

  • Add a new file in the resources folder processes.xmldefault false false

  • Add exclusions in the pom.xml file

      <exclusions><exclusion>
          <groupId>log4j</groupId>
          <artifactId>log4j</artifactId>
      </exclusion></exclusions>

None of these and combinations of them work.

Can you please tell me how to disable all loggings of Camunda?

Thanks!