[Aerogear-users] DB Migration failing (1.1.3 to 1.2.0)

[Yoann Archambault]

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