DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::2::qmx: Computed checksum for 7:0ce73b3                                                     15bf7651f181bc9f20f04edb4:7:7618b281ec914d0c62a2a88a194c8711: as d59b0dd54785c0203724051edf275fe4
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Running Changeset:liquibase/1                                                     .1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Changeset liquibase/1.1.0-Fin                                                     al/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Reading ChangeSet: liquibase/                                                     1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Executing Statement: liquibas                                                     e.statement.core.DropTableStatement@21ffbe3b
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Executing EXECUTE database co                                                     mmand: DROP TABLE unifiedpush_tmp.ChromePackagedAppVariant
INFO 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Table ChromePackagedAppVariant                                                      dropped
INFO 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: ChangeSet liquibase/1.1.0-Fina                                                     l/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx ran successfully in 5ms
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Computed checksum for dropTab                                                     le:[
    tableName="ChromePackagedAppVariant"
] as 8336d6591a57eaa91889c7a4872d293b
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Computed checksum for 7:8336d                                                     6591a57eaa91889c7a4872d293b: as 205dffc502ef3db7d116dee1af7d0b8c
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Executing EXECUTE database co                                                     mmand: INSERT INTO unifiedpush_tmp.ups_db_changelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, LIQUIBASE) VALUES ('1', 'qmx', 'liquiba                                                     se/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml', NOW(), 88, '7:205dffc502ef3db7d116dee1af7d0b8c', 'dropTable', '', 'EXECUTED', '3.3.2')
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Computed checksum for dropTab                                                     le:[
    tableName="ChromePackagedAppVariant"
] as 8336d6591a57eaa91889c7a4872d293b
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-09-drop-chromepackagedapp-variant.xml::1::qmx: Computed checksum for 7:8336d                                                     6591a57eaa91889c7a4872d293b: as 205dffc502ef3db7d116dee1af7d0b8c
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Running Changeset:liquiba                                                     se/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Changeset liquibase/1.1.0                                                     -Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Reading ChangeSet: liquib                                                     ase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Executing Statement: liqu                                                     ibase.statement.core.AddForeignKeyConstraintStatement@38ebb08a
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Executing EXECUTE databas                                                     e command: ALTER TABLE unifiedpush_tmp.windows_mpns_variant ADD CONSTRAINT fk_649wp2ys69m1jxb33tl3trjig FOREIGN KEY (id) REFERENCES unifiedpush_tmp.variant (id) ON UPDATE NO ACTION ON                                                      DELETE NO ACTION
SEVERE 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/releasechanges.xml: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Change Set liquibase/1.1                                                     .0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx failed.  Error: java.sql.SQLException: Failed to add the foreign key constaint. Missing index for constraint 'fk_649w                                                     p2ys69m1jxb33tl3trjig' in the referenced table 'variant'
liquibase.exception.DatabaseException: java.sql.SQLException: Failed to add the foreign key constaint. Missing index for constraint 'fk_649wp2ys69m1jxb33tl3trjig' in the referenced tab                                                     le 'variant'
        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: java.sql.SQLException: Failed to add the foreign key constaint. Missing index for constraint 'fk_649wp2ys69m1jxb33tl3trjig' in the referenced table 'variant'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
        ... 11 more
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Release Database Lock
DEBUG 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Executing UPDATE database command: UPDATE unifiedpush_tmp.ups_db_ch                                                     angeloglock SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1
INFO 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: Successfully released change log lock
Unexpected error running Liquibase: java.sql.SQLException: Failed to add the foreign key constaint. Missing index for constraint 'fk_649wp2ys69m1jxb33tl3trjig' in the referenced table                                                      'variant'

SEVERE 11/19/15 10:11 AM: liquibase: liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx: java.sql.SQLException: Failed to add the foreign key constaint. Mi                                                     ssing index for constraint 'fk_649wp2ys69m1jxb33tl3trjig' in the referenced table 'variant'
liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/1.1.0-Final/2015-07-10-reenable-constraints.xml::1436957323846-1::qmx:
     Reason: liquibase.exception.DatabaseException: java.sql.SQLException: Failed to add the foreign key constaint. Missing index for constraint 'fk_649wp2ys69m1jxb33tl3trjig' in the r                                                     eferenced table 'variant'
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586)
        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: liquibase.exception.DatabaseException: java.sql.SQLException: Failed to add the foreign key constaint. Missing index for constraint 'fk_649wp2ys69m1jxb33tl3trjig' in the ref                                                     erenced table 'variant'
        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)
        ... 6 more
Caused by: java.sql.SQLException: Failed to add the foreign key constaint. Missing index for constraint 'fk_649wp2ys69m1jxb33tl3trjig' in the referenced table 'variant'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
        ... 11 more


For more information, use the --logLevel flag