Hi all.
First of all, i need to upgrade version of existing camunda engine version (from 7.10 to 7.11) in some services, deployed on Kubernetes. Each service have their own postgres database. For historical reasons, the service was deployed without versioned migration (in project we use liquibase) Also, we using Spring Boot framework. So, when i’am try to upgrade version of engine - i get error:
org.camunda.bpm.engine.ProcessEngineException: ENGINE-03083 Exception while executing Batch Database Operations with message '\n### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.history.event.UserOperationLogEntryEventEntity.insertUserOperationLogEntryEvent (batch index #2) failed. 1 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_HI_OP_LOG (\n ID_,\n DEPLOYMENT_ID_,\n PROC_DEF_ID_,\n PROC_DEF_KEY_,\n ROOT_PROC_INST_ID_,\n PROC_INST_ID_,\n EXECUTION_ID_,\n CASE_DEF_ID_,\n CASE_INST_ID_,\n CASE_EXECUTION_ID_,\n TASK_ID_,\n JOB_ID_,\n JOB_DEF_ID_,\n BATCH_ID_,\n USER_ID_,\n TIMESTAMP_,\n OPERATION_ID_ ,\n OPERATION_TYPE_,\n ENTITY_TYPE_,\n PROPERTY_,\n ORG_VALUE_,\n NEW_VALUE_,\n TENANT_ID_,\n REMOVAL_TIME_,\n CATEGORY_,\n EXTERNAL_TASK_ID_\n ) values (\n 'e19f13a7-3600-11ea-b043-0a58c0a86a14',\n 'cc9520fe-338a-11ea-b043-0a58c0a86a14',\n 'PortDeprovisioning:10:cd8c5155-338a-11ea-b043-0a58c0a86a14',\n 'PortDeprovisioning',\n 'e19d3eda-3600-11ea-b043-0a58c0a86a14',\n 'e19d3eda-3600-11ea-b043-0a58c0a86a14',\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n 'wgaccessprovisioning',\n '2020-01-13 12:33:20.142+00',\n 'e19f13a6-3600-11ea-b043-0a58c0a86a14',\n 'Create',\n 'ProcessInstance',\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n 'Operator',\n NULL\n ) was aborted: ERROR: column \"category_\" of relation \"act_hi_op_log\" does not exist\n Position: 552 Call getNextException to see other errors in the batch.\n### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.history.event.UserOperationLogEntryEventEntity.insertUserOperationLogEntryEvent (batch index #2) failed. 1 prior sub executor(s) completed successfully, but will be rolled back.
This error happened because engine was upgraded, but the necessary SQL updates in the database were not made.
My final question:
It is possible to use out-of-box mechanism and somehow fix it? Or i need to create old-school migration SQl script?
Thank you.