OpenMRS Core Master
Build: #1894 failed
Job: Integration Test failed
Should upgrade from clean1 9to1 10: Test case result
The below summarizes the result of the test "Should upgrade from clean1 9to1 10" in build 1,894 of OpenMRS Core - OpenMRS Core Master - Integration Test.
- Description
- Should upgrade from clean1 9to1 10
- Test class
- org.openmrs.util.databasechange.Database1_9_7UpgradeIT
- Method
- shouldUpgradeFromClean1_9To1_10
- Duration
- 6 secs
- Status
- Failed (New Failure)
Error Log
java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20181402-TRUNK-5339::esirkings: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)): Duplicate column name "PATIENT_ID"; SQL statement: CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)) [42121-196]: Caused By: Error executing SQL CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)): Duplicate column name "PATIENT_ID"; SQL statement: CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)) [42121-196]: Caused By: Duplicate column name "PATIENT_ID"; SQL statement: CREATE TABLE encounter_diagnosis (diagnosis_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, diagnosis_coded INT, diagnosis_non_coded VARCHAR(255), diagnosis_coded_name INT, encounter_id INT NOT NULL, patient_id INT NOT NULL, condition_id INT NOT NULL, certainty VARCHAR(255) NOT NULL, rank INT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created TIMESTAMP NOT NULL, changed_by INT, date_changed TIMESTAMP, voided BOOLEAN DEFAULT FALSE NOT NULL, voided_by INT, date_voided TIMESTAMP, void_reason VARCHAR(255), patient_id INT NOT NULL, CONSTRAINT PK_ENCOUNTER_DIAGNOSIS PRIMARY KEY (diagnosis_id), UNIQUE (uuid)) [42121-196] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.table.Table.setColumns(Table.java:428) at org.h2.table.TableBase.<init>(TableBase.java:45) at org.h2.table.RegularTable.<init>(RegularTable.java:74) at org.h2.schema.Schema.createTable(Schema.java:614) at org.h2.command.ddl.CreateTable.update(CreateTable.java:139) at org.h2.command.CommandContainer.update(CommandContainer.java:101) at org.h2.command.Command.executeUpdate(Command.java:260) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:192) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:114) at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:228) at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:221) at org.openmrs.util.databasechange.Database1_9_7UpgradeIT.shouldUpgradeFromClean1_9To1_10(Database1_9_7UpgradeIT.java:148)