3:21 p.m.
Hello,
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 running a postgresql 9.6 database on centos 6.9 and wildfly 10.1
I'm attaching the full output of the migrator (.txt) as well as the
contents of my changelog table (.xls)
Any help getting unstuck would be greatly appreciated!
Yoann Archambault
----
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