Hi
I am able to partition act_ge_bytearry and act_hi_* tables but when I try to partition act_ru_* getting below error. Is it possible to partition.
Caused by: org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation ‘INSERT VariableInstanceEntity[ec8e27bf-64a7-11ef-bb99-0a0027000008]’ with message ’
Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.VariableInstanceEntity.insertVariableInstance (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_VARIABLE
(
ID_,
TYPE_,
NAME_,
PROC_DEF_ID_,
PROC_INST_ID_,
EXECUTION_ID_,
CASE_INST_ID_,
CASE_EXECUTION_ID_,
TASK_ID_,
BATCH_ID_,
BYTEARRAY_ID_,
DOUBLE_,
LONG_,
TEXT_,
TEXT2_,
VAR_SCOPE_,
SEQUENCE_COUNTER_,
IS_CONCURRENT_LOCAL_,
TENANT_ID_,
REV_
)
values (
'ec8e27bf-64a7-11ef-bb99-0a0027000008',
'CryptoStringValueSerializer',
'keyValuePair',
'OrderOrchestration:1:d973b783-64a7-11ef-bb99-0a0027000008',
'ec885b5d-64a7-11ef-bb99-0a0027000008',
'ec885b5d-64a7-11ef-bb99-0a0027000008',
NULL,
NULL,
NULL,
NULL,
'ec8e00ae-64a7-11ef-bb99-0a0027000008',
NULL,
NULL,
NULL,
NULL,
'ec885b5d-64a7-11ef-bb99-0a0027000008',
1,
'FALSE',
NULL,
1
) was aborted: ERROR: insert or update on table "act_ru_variable_p3" violates foreign key constraint "act_fk_var_bytearray_p3"
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”. Call getNextException to see other errors in the batch.
Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.VariableInstanceEntity.insertVariableInstance (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_VARIABLE
(
ID_,
TYPE_,
NAME_,
PROC_DEF_ID_,
PROC_INST_ID_,
EXECUTION_ID_,
CASE_INST_ID_,
CASE_EXECUTION_ID_,
TASK_ID_,
BATCH_ID_,
BYTEARRAY_ID_,
DOUBLE_,
LONG_,
TEXT_,
TEXT2_,
VAR_SCOPE_,
SEQUENCE_COUNTER_,
IS_CONCURRENT_LOCAL_,
TENANT_ID_,
REV_
)
values (
'ec8e27bf-64a7-11ef-bb99-0a0027000008',
'CryptoStringValueSerializer',
'keyValuePair',
'OrderOrchestration:1:d973b783-64a7-11ef-bb99-0a0027000008',
'ec885b5d-64a7-11ef-bb99-0a0027000008',
'ec885b5d-64a7-11ef-bb99-0a0027000008',
NULL,
NULL,
NULL,
NULL,
'ec8e00ae-64a7-11ef-bb99-0a0027000008',
NULL,
NULL,
NULL,
NULL,
'ec885b5d-64a7-11ef-bb99-0a0027000008',
1,
'FALSE',
NULL,
1
) was aborted: ERROR: insert or update on table "act_ru_variable_p3" violates foreign key constraint "act_fk_var_bytearray_p3"
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”. Call getNextException to see other errors in the batch.
java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_VARIABLE
(
ID_,
TYPE_,
NAME_,
PROC_DEF_ID_,
PROC_INST_ID_,
EXECUTION_ID_,
CASE_INST_ID_,
CASE_EXECUTION_ID_,
TASK_ID_,
BATCH_ID_,
BYTEARRAY_ID_,
DOUBLE_,
LONG_,
TEXT_,
TEXT2_,
VAR_SCOPE_,
SEQUENCE_COUNTER_,
IS_CONCURRENT_LOCAL_,
TENANT_ID_,
REV_
)
values (
‘ec8e27bf-64a7-11ef-bb99-0a0027000008’,
‘CryptoStringValueSerializer’,
‘keyValuePair’,
‘OrderOrchestration:1:d973b783-64a7-11ef-bb99-0a0027000008’,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
NULL,
NULL,
NULL,
NULL,
‘ec8e00ae-64a7-11ef-bb99-0a0027000008’,
NULL,
NULL,
NULL,
NULL,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
1,
‘FALSE’,
NULL,
1
) was aborted: ERROR: insert or update on table “act_ru_variable_p3” violates foreign key constraint “act_fk_var_bytearray_p3”
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”. Call getNextException to see other errors in the batch.
com.edb.util.PSQLException: ERROR: insert or update on table “act_ru_variable_p3” violates foreign key constraint “act_fk_var_bytearray_p3”
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”.
com.edb.util.PSQLException: ERROR: insert or update on table “act_ru_variable_p3” violates foreign key constraint “act_fk_var_bytearray_p3”
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”.
'. Flush summary:
[
INSERT HistoricVariableInstanceEntity[ec8e27bf-64a7-11ef-bb99-0a0027000008]
INSERT HistoricVariableInstanceEntity[ec8e4ed4-64a7-11ef-bb99-0a0027000008]
INSERT HistoricVariableInstanceEntity[ec8e4ed9-64a7-11ef-bb99-0a0027000008]
INSERT HistoricJobLogEventEntity[ec90e6ef-64a7-11ef-bb99-0a0027000008]
INSERT HistoricVariableUpdateEventEntity[ec8e4ed1-64a7-11ef-bb99-0a0027000008]
INSERT HistoricVariableUpdateEventEntity[ec8e4ed6-64a7-11ef-bb99-0a0027000008]
INSERT HistoricVariableUpdateEventEntity[ec8e4edb-64a7-11ef-bb99-0a0027000008]
INSERT HistoricProcessInstanceEventEntity[ec885b5d-64a7-11ef-bb99-0a0027000008]
INSERT HistoricActivityInstanceEventEntity[startOrderDecomposition:ec8f604d-64a7-11ef-bb99-0a0027000008]
INSERT ExecutionEntity[ec885b5d-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e00ae-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e4ed0-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e4ed2-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e4ed3-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e4ed5-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e4ed7-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e4ed8-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e4eda-64a7-11ef-bb99-0a0027000008]
INSERT ByteArrayEntity[ec8e4edc-64a7-11ef-bb99-0a0027000008]
INSERT VariableInstanceEntity[ec8e27bf-64a7-11ef-bb99-0a0027000008]
INSERT VariableInstanceEntity[ec8e4ed4-64a7-11ef-bb99-0a0027000008]
INSERT VariableInstanceEntity[ec8e4ed9-64a7-11ef-bb99-0a0027000008]
INSERT MessageEntity[ec904aae-64a7-11ef-bb99-0a0027000008]
]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:131) ~[camunda-engine-7.16.0-ee.jar!/:7.16.0-ee]
… 132 common frames omitted
Caused by: org.apache.ibatis.exceptions.PersistenceException:
Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.VariableInstanceEntity.insertVariableInstance (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_VARIABLE
(
ID_,
TYPE_,
NAME_,
PROC_DEF_ID_,
PROC_INST_ID_,
EXECUTION_ID_,
CASE_INST_ID_,
CASE_EXECUTION_ID_,
TASK_ID_,
BATCH_ID_,
BYTEARRAY_ID_,
DOUBLE_,
LONG_,
TEXT_,
TEXT2_,
VAR_SCOPE_,
SEQUENCE_COUNTER_,
IS_CONCURRENT_LOCAL_,
TENANT_ID_,
REV_
)
values (
'ec8e27bf-64a7-11ef-bb99-0a0027000008',
'CryptoStringValueSerializer',
'keyValuePair',
'OrderOrchestration:1:d973b783-64a7-11ef-bb99-0a0027000008',
'ec885b5d-64a7-11ef-bb99-0a0027000008',
'ec885b5d-64a7-11ef-bb99-0a0027000008',
NULL,
NULL,
NULL,
NULL,
'ec8e00ae-64a7-11ef-bb99-0a0027000008',
NULL,
NULL,
NULL,
NULL,
'ec885b5d-64a7-11ef-bb99-0a0027000008',
1,
'FALSE',
NULL,
1
) was aborted: ERROR: insert or update on table "act_ru_variable_p3" violates foreign key constraint "act_fk_var_bytearray_p3"
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”. Call getNextException to see other errors in the batch.
Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.VariableInstanceEntity.insertVariableInstance (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_VARIABLE
(
ID_,
TYPE_,
NAME_,
PROC_DEF_ID_,
PROC_INST_ID_,
EXECUTION_ID_,
CASE_INST_ID_,
CASE_EXECUTION_ID_,
TASK_ID_,
BATCH_ID_,
BYTEARRAY_ID_,
DOUBLE_,
LONG_,
TEXT_,
TEXT2_,
VAR_SCOPE_,
SEQUENCE_COUNTER_,
IS_CONCURRENT_LOCAL_,
TENANT_ID_,
REV_
)
values (
'ec8e27bf-64a7-11ef-bb99-0a0027000008',
'CryptoStringValueSerializer',
'keyValuePair',
'OrderOrchestration:1:d973b783-64a7-11ef-bb99-0a0027000008',
'ec885b5d-64a7-11ef-bb99-0a0027000008',
'ec885b5d-64a7-11ef-bb99-0a0027000008',
NULL,
NULL,
NULL,
NULL,
'ec8e00ae-64a7-11ef-bb99-0a0027000008',
NULL,
NULL,
NULL,
NULL,
'ec885b5d-64a7-11ef-bb99-0a0027000008',
1,
'FALSE',
NULL,
1
) was aborted: ERROR: insert or update on table "act_ru_variable_p3" violates foreign key constraint "act_fk_var_bytearray_p3"
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”. Call getNextException to see other errors in the batch.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:254) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushBatchOperations(DbSqlSession.java:444) ~[camunda-engine-7.16.0-ee.jar!/:7.16.0-ee]
at org.camunda.bpm.engine.impl.db.sql.BatchDbSqlSession.executeDbOperations(BatchDbSqlSession.java:74) ~[camunda-engine-7.16.0-ee.jar!/:7.16.0-ee]
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:341) ~[camunda-engine-7.16.0-ee.jar!/:7.16.0-ee]
… 131 common frames omitted
Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.VariableInstanceEntity.insertVariableInstance (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_VARIABLE
(
ID_,
TYPE_,
NAME_,
PROC_DEF_ID_,
PROC_INST_ID_,
EXECUTION_ID_,
CASE_INST_ID_,
CASE_EXECUTION_ID_,
TASK_ID_,
BATCH_ID_,
BYTEARRAY_ID_,
DOUBLE_,
LONG_,
TEXT_,
TEXT2_,
VAR_SCOPE_,
SEQUENCE_COUNTER_,
IS_CONCURRENT_LOCAL_,
TENANT_ID_,
REV_
)
values (
‘ec8e27bf-64a7-11ef-bb99-0a0027000008’,
‘CryptoStringValueSerializer’,
‘keyValuePair’,
‘OrderOrchestration:1:d973b783-64a7-11ef-bb99-0a0027000008’,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
NULL,
NULL,
NULL,
NULL,
‘ec8e00ae-64a7-11ef-bb99-0a0027000008’,
NULL,
NULL,
NULL,
NULL,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
1,
‘FALSE’,
NULL,
1
) was aborted: ERROR: insert or update on table “act_ru_variable_p3” violates foreign key constraint “act_fk_var_bytearray_p3”
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”. Call getNextException to see other errors in the batch.
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:149) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:114) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:252) ~[mybatis-3.5.6.jar!/:3.5.6]
… 134 common frames omitted
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_VARIABLE
(
ID_,
TYPE_,
NAME_,
PROC_DEF_ID_,
PROC_INST_ID_,
EXECUTION_ID_,
CASE_INST_ID_,
CASE_EXECUTION_ID_,
TASK_ID_,
BATCH_ID_,
BYTEARRAY_ID_,
DOUBLE_,
LONG_,
TEXT_,
TEXT2_,
VAR_SCOPE_,
SEQUENCE_COUNTER_,
IS_CONCURRENT_LOCAL_,
TENANT_ID_,
REV_
)
values (
‘ec8e27bf-64a7-11ef-bb99-0a0027000008’,
‘CryptoStringValueSerializer’,
‘keyValuePair’,
‘OrderOrchestration:1:d973b783-64a7-11ef-bb99-0a0027000008’,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
NULL,
NULL,
NULL,
NULL,
‘ec8e00ae-64a7-11ef-bb99-0a0027000008’,
NULL,
NULL,
NULL,
NULL,
‘ec885b5d-64a7-11ef-bb99-0a0027000008’,
1,
‘FALSE’,
NULL,
1
) was aborted: ERROR: insert or update on table “act_ru_variable_p3” violates foreign key constraint “act_fk_var_bytearray_p3”
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”. Call getNextException to see other errors in the batch.
at com.edb.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:156) ~[edb-jdbc18.jar:42.2.12.3]
at com.edb.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2364) ~[edb-jdbc18.jar:42.2.12.3]
at com.edb.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:542) ~[edb-jdbc18.jar:42.2.12.3]
at com.edb.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:882) ~[edb-jdbc18.jar:42.2.12.3]
at com.edb.jdbc.PgStatement.executeBatch(PgStatement.java:906) ~[edb-jdbc18.jar:42.2.12.3]
at com.edb.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1957) ~[edb-jdbc18.jar:42.2.12.3]
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) ~[HikariCP-4.0.3.jar!/:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar!/:na]
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:123) ~[mybatis-3.5.6.jar!/:3.5.6]
… 138 common frames omitted
Caused by: com.edb.util.PSQLException: ERROR: insert or update on table “act_ru_variable_p3” violates foreign key constraint “act_fk_var_bytearray_p3”
Detail: Key (bytearray_id_)=(ec8e00ae-64a7-11ef-bb99-0a0027000008) is not present in table “act_ge_bytearray_p3”.
at com.edb.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2745) ~[edb-jdbc18.jar:42.2.12.3]
at com.edb.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2363) ~[edb-jdbc18.jar:42.2.12.3]
… 145 common frames omitted