I am using activiti 5.22 with sql aurora and while doing certain operations(claim and post comment) I get below error. But when I try second time operation is successful and this is frequent.
The MySQL server is running with the --read-only option so it cannot execute this statement ### The error may involve org.activiti.engine.impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance-Inline ### The error occurred while setting parameters ### SQL: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? ### Cause: java.sql.SQLException: The MySQL server is running with the --read-only option so it cannot execute this statement
Can you suggest what might be the issue?
My DBConnection is not read only as indicated by query DB flag.