SqlScriptTest is unstable

[ThorbenLindhauer]

This issue was imported from JIRA:

Field	Value
JIRA Link	CAM-14750
Reporter	@tmetzke
Has restricted visibility comments	true

---

Acceptance Criteria (Required on creation):

The test org.camunda.bpm.sql.test.SqlScriptTest is stable.

Hints (Optional):

The test fails with the following exception:

<2022-07-04T06:27:27.113Z> <INFO> Running org.camunda.bpm.sql.test.SqlScriptTest

<2022-07-04T06:27:27.113Z> <ERROR> Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.863 s <<< FAILURE! - in org.camunda.bpm.sql.test.SqlScriptTest

<2022-07-04T06:27:27.113Z> <ERROR> shouldEqualLiquibaseChangelogAndCreateScripts(org.camunda.bpm.sql.test.SqlScriptTest)  Time elapsed: 0.795 s  <<< ERROR!

<2022-07-04T06:27:27.113Z> liquibase.exception.DatabaseException: 

<2022-07-04T06:27:27.113Z> ERROR: relation "act*ge*property" already exists <Failed SQL: (0) --

[2022-07-04T06:27:27.113Z> -- Copyright Camunda Services GmbH and/or licensed to Camunda Services GmbH

<2022-07-04T06:27:27.113Z> -- under one or more contributor license agreements. See the NOTICE file

<2022-07-04T06:27:27.113Z> -- distributed with this work for additional information regarding copyright

<2022-07-04T06:27:27.113Z> -- ownership. Camunda licenses this file to you under the Apache License,

<2022-07-04T06:27:27.113Z> -- Version 2.0; you may not use this file except in compliance with the License.

<2022-07-04T06:27:27.113Z> -- You may obtain a copy of the License at

<2022-07-04T06:27:27.113Z> --

<2022-07-04T06:27:27.113Z> --     http://www.apache.org/licenses/LICENSE-2.0

<2022-07-04T06:27:27.113Z> --

<2022-07-04T06:27:27.113Z> -- Unless required by applicable law or agreed to in writing, software

<2022-07-04T06:27:27.113Z> -- distributed under the License is distributed on an "AS IS" BASIS,

<2022-07-04T06:27:27.113Z> -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

<2022-07-04T06:27:27.113Z> -- See the License for the specific language governing permissions and

<2022-07-04T06:27:27.113Z> -- limitations under the License.

<2022-07-04T06:27:27.113Z> --

<2022-07-04T06:27:27.113Z> 

<2022-07-04T06:27:27.113Z> create table ACT*GE*PROPERTY (

<2022-07-04T06:27:27.113Z>     NAME_ varchar(64),

<2022-07-04T06:27:27.113Z>     VALUE_ varchar(300),

<2022-07-04T06:27:27.113Z>     REV_ integer,

<2022-07-04T06:27:27.113Z>     primary key (NAME_)

<2022-07-04T06:27:27.113Z> )]

<2022-07-04T06:27:27.113Z>  at org.camunda.bpm.sql.test.SqlScriptTest.executeSqlScript(SqlScriptTest.java:145)

<2022-07-04T06:27:27.113Z>  at org.camunda.bpm.sql.test.SqlScriptTest.shouldEqualLiquibaseChangelogAndCreateScripts(SqlScriptTest.java:98)

<2022-07-04T06:27:27.113Z> Caused by: org.postgresql.util.PSQLException: ERROR: relation "act*ge*property" already exists

<2022-07-04T06:27:27.113Z>  at org.camunda.bpm.sql.test.SqlScriptTest.executeSqlScript(SqlScriptTest.java:145)

<2022-07-04T06:27:27.113Z>  at org.camunda.bpm.sql.test.SqlScriptTest.shouldEqualLiquibaseChangelogAndCreateScripts(SqlScriptTest.java:98)

Links:

• is related to https://jira.camunda.com/browse/CAM-14485

[ThorbenLindhauer]

This comment was imported from JIRA and written by user @ThorbenLindhauer

---

Still fails on CRDB at least.

[tmetzke]

The tests are stable in our CI except for CRDB, see more details at https://github.com/camunda/camunda-bpm-platform/issues/3613. Closing this issue as mainly fixed and also superseded by https://github.com/camunda/camunda-bpm-platform/issues/3613.