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 _______________________________________________ Aerogear-users mailing list [hidden email] https://lists.jboss.org/mailman/listinfo/aerogear-users |
Free forum by Nabble | Edit this page |