similar to: Instantiation fails when database schema update is set to "drop-create"
When running Springbook with @Rule public ProcessEngineRule processEngine = new StandaloneInMemoryTestConfiguration().rule()
, the default usage is to have drop-create
as the schema update.
What is the reason for this, as it causes non-blocking errors in the build:
such as
2019-04-04 13:14:18.959 INFO --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@55f616cf, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@1356d4d4, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@c03cf28, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@1329eff, org.springframework.test.context.support.DirtiesContextTestExecutionListener@6497b078, org.springframework.test.context.transaction.TransactionalTestExecutionListener@41c2284a, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@53aad5d5, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@46fa7c39, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@1fb700ee, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@4f67eb2a, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@4a668b6e, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@5f683daf]2019-04-04 13:14:23.747 ERROR --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03015 Problem during schema operation 'drop' with statement '--
--
--
--
--
alter table ACT_RE_DECISION_DEF
drop constraint ACT_FK_DEC_REQ'. Cause: 'Table "ACT_RE_DECISION_DEF" not found; SQL statement:
--
--
--
--
--
alter table ACT_RE_DECISION_DEF
drop constraint ACT_FK_DEC_REQ [42102-197]'
2019-04-04 13:14:23.752 ERROR --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03015 Problem during schema operation 'drop' with statement 'drop index ACT_IDX_DEC_DEF_TENANT_ID'. Cause: 'Index "ACT_IDX_DEC_DEF_TENANT_ID" not found; SQL statement:
drop index ACT_IDX_DEC_DEF_TENANT_ID [42112-197]'
2019-04-04 13:14:23.753 ERROR --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03015 Problem during schema operation 'drop' with statement 'drop index ACT_IDX_DEC_DEF_REQ_ID'. Cause: 'Index "ACT_IDX_DEC_DEF_REQ_ID" not found; SQL statement:
drop index ACT_IDX_DEC_DEF_REQ_ID [42112-197]'
2019-04-04 13:14:23.753 ERROR --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03015 Problem during schema operation 'drop' with statement 'drop index ACT_IDX_DEC_REQ_DEF_TENANT_ID'. Cause: 'Index "ACT_IDX_DEC_REQ_DEF_TENANT_ID" not found; SQL statement:
drop index ACT_IDX_DEC_REQ_DEF_TENANT_ID [42112-197]'
2019-04-04 13:14:23.754 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation 'drop' on component 'decision.engine' with resource 'org/camunda/bpm/engine/db/drop/activiti.h2.drop.decision.engine.sql'
2019-04-04 13:14:23.920 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation 'create' on component 'engine' with resource 'org/camunda/bpm/engine/db/create/activiti.h2.create.engine.sql'
2019-04-04 13:14:23.982 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation 'create' on component 'history' with resource 'org/camunda/bpm/engine/db/create/activiti.h2.create.history.sql'
2019-04-04 13:14:24.006 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation 'create' on component 'identity' with resource 'org/camunda/bpm/engine/db/create/activiti.h2.create.identity.sql'
2019-04-04 13:14:24.025 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation 'create' on component 'case.engine' with resource 'org/camunda/bpm/engine/db/create/activiti.h2.create.case.engine.sql'
2019-04-04 13:14:24.034 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation 'create' on component 'case.history' with resource 'org/camunda/bpm/engine/db/create/activiti.h2.create.case.history.sql'
2019-04-04 13:14:24.039 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation 'create' on component 'decision.engine' with resource 'org/camunda/bpm/engine/db/create/activiti.h2.create.decision.engine.sql'
2019-04-04 13:14:24.050 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation 'create' on component 'decision.history' with resource 'org/camunda/bpm/engine/db/create/activiti.h2.create.decision.history.sql'
2019-04-04 13:14:24.090 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03067 No history level property found in database
2019-04-04 13:14:24.091 INFO --- [ main] org.camunda.bpm.engine.persistence : ENGINE-03065 Creating historyLevel property in database for level: HistoryLevelFull(name=full, id=3)
2019-04-04 13:14:24.164 INFO --- [ main] org.camunda.bpm.engine : ENGINE-00001 Process Engine default created.
@jangalinski even in the travis builds of the Camunda spring boot, I can see where this error appears in passing logs.
Whats the history on this?
THanks