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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[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

mig_1.1.3_to_1.2.0.txt (137K) Download Attachment
ups_db_changelog.xls (43K) Download Attachment