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.
Are you sure you are not connecting to the replica? - amazon web services - AWS Aurora: The MySQL server is running with the --read-only option so it cann...
Ask for and offer help to other Alfresco Process Services and Activiti Users and members of the Alfresco team.
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.