topic 'Error updating database' in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-updating-database/m-p/304470#M257600 <HTML><HEAD></HEAD><BODY><SPAN>I've got logs full of that general error and I don't know what to do about it.&nbsp; Not sure what forum to post in, but I'm guessing it's due to a configuration error?&nbsp; Appears to have something to do with Activiti, which I believe is the workflow engine.&nbsp; The errors have been going on for a long time, and workflows were working for the bulk of that time.&nbsp; As of today, workflows no longer function, but we had a catastrophic failure trying to add the Records Management module over the weekend.&nbsp; New errors could have been introduced, but the error logs actually look the same…&nbsp; Could also be that it was just waiting for a reboot to fail?</SPAN><BR /><BR /><SPAN>**edit**</SPAN><BR /><BR /><SPAN>I was able to fix our workflow issues.&nbsp; Apparently an amp went missing during the Records Management install.&nbsp; However, these database errors continue.&nbsp; Not only that, but I pulled historical logs and they've been going on for weeks before I tried the RM upgrade.&nbsp; Appears to be a long running issue unrelated to my recent changes.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />### Error updating database.&nbsp; Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction<BR />### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.updateByteArray_postgres-Inline<BR />### The error occurred while setting parameters<BR />### Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:120)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:646)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:458)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:169)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:116)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.TaskServiceImpl.getVariables(TaskServiceImpl.java:199)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.activiti.properties.ActivitiPropertyConverter.getTaskProperties(ActivitiPropertyConverter.java:122)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.activiti.ActivitiTypeConverter.getTaskProperties(ActivitiTypeConverter.java:485)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.service.cmr.workflow.LazyActivitiWorkflowTask.ensureProperties(LazyActivitiWorkflowTask.java:131)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.service.cmr.workflow.LazyActivitiWorkflowTask$LazyPropertiesMap.get(LazyActivitiWorkflowTask.java:212)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.service.cmr.workflow.LazyActivitiWorkflowTask$LazyPropertiesMap.get(LazyActivitiWorkflowTask.java:150)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.workflow.WorkflowModelBuilder.isPooled(WorkflowModelBuilder.java:404)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.workflow.WorkflowModelBuilder.buildSimple(WorkflowModelBuilder.java:196)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.workflow.TaskInstancesGet.buildModel(TaskInstancesGet.java:187)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.workflow.AbstractWorkflowWebscript.executeImpl(AbstractWorkflowWebscript.java:81)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)<BR />&nbsp;&nbsp;&nbsp;… 32 more<BR />Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:410)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:87)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:46)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)<BR />&nbsp;&nbsp;&nbsp;… 52 more<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 29 Sep 2014 14:59:46 GMT sscbrian 2014-09-29T14:59:46Z 'Error updating database' https://connect.hyland.com/t5/alfresco-archive/error-updating-database/m-p/304470#M257600 I've got logs full of that general error and I don't know what to do about it.&nbsp; Not sure what forum to post in, but I'm guessing it's due to a configuration error?&nbsp; Appears to have something to do with Activiti, which I believe is the workflow engine.&nbsp; The errors have been going on for a long time, Mon, 29 Sep 2014 14:59:46 GMT https://connect.hyland.com/t5/alfresco-archive/error-updating-database/m-p/304470#M257600 sscbrian 2014-09-29T14:59:46Z Re: 'Error updating database' https://connect.hyland.com/t5/alfresco-archive/error-updating-database/m-p/304471#M257601 <HTML><HEAD></HEAD><BODY><SPAN>This error has magically gone away of it's own accord…</SPAN></BODY></HTML> Mon, 24 Nov 2014 20:51:26 GMT https://connect.hyland.com/t5/alfresco-archive/error-updating-database/m-p/304471#M257601 sscbrian 2014-11-24T20:51:26Z