I'm trying to upgrade to 1.2.0 so i cloned our production database and am trying to run the ups-migrator but i'm getting a strange error about one of the new tables.
I'm attaching the full output of the migrator (.txt) as well as the contents of my changelog table (.xls)
DEBUG 10/16/17 2:43 PM: liquibase: liquibase/master.xml: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-16::matzew (generated): Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="PRIMARY"
tableName="flat_push_message_info"
] as 3464de402322ecb56aa2ec149c55bd6d
DEBUG 10/16/17 2:43 PM: liquibase: liquibase/master.xml: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-16::matzew (generated): Computed checksum for 7:3464de402322ecb56aa2ec149c55bd6d: as d120fdfbd02d16d8f644519467ff5b87
DEBUG 10/16/17 2:43 PM: liquibase: liquibase/master.xml: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated): Running Changeset:liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated)
DEBUG 10/16/17 2:43 PM: liquibase: liquibase/master.xml: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated): Changeset liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated)
DEBUG 10/16/17 2:43 PM: liquibase: liquibase/master.xml: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated): Reading ChangeSet: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated)
DEBUG 10/16/17 2:43 PM: liquibase: liquibase/master.xml: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated): Executing Statement: liquibase.statement.core.AddPrimaryKeyStatement@54eb2b70
DEBUG 10/16/17 2:43 PM: liquibase: liquibase/master.xml: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated): Executing EXECUTE database command: ALTER TABLE public.variant_error_status ADD CONSTRAINT "PRIMARY" PRIMARY KEY (push_message_variant_id)
SEVERE 10/16/17 2:43 PM: liquibase: liquibase/master.xml: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated): Change Set liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated) failed. Error: org.postgresql.util.PSQLException: ERROR: relation "PRIMARY" already exists
liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: relation "PRIMARY" already exists
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
at liquibase.Liquibase.update(Liquibase.java:200)
at liquibase.integration.commandline.Main.doMigration(Main.java:1044)
at liquibase.integration.commandline.Main.run(Main.java:175)
at liquibase.integration.commandline.Main.main(Main.java:94)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "PRIMARY" already exists
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
... 11 more
DEBUG 10/16/17 2:43 PM: liquibase: liquibase/1.2.0/2017-09-06-flat-model-entities.xml::1504688114371-22::matzew (generated): Release Database Lock