-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/63150/
-----------------------------------------------------------
(Updated Oct. 19, 2017, 6:38 p.m.)
Review request for Ambari, Jonathan Hurley and Nate Cole.
Bugs: AMBARI-22216
https://issues.apache.org/jira/browse/AMBARI-22216
Repository: ambari
Description
-------
Yet another failure when upgrading 2.5.2.0 to 2.6.0.0
ERROR: Exception in thread "main" org.apache.ambari.server.AmbariException:
Cannot drop index 'FK_upgrade_from_repo_version_id': needed in a foreign key
constraint
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:203)
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:418)
Caused by: java.sql.SQLException: Cannot drop index
'FK_upgrade_from_repo_version_id': needed in a foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
at
org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:877)
at
org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:869)
at
org.apache.ambari.server.orm.DBAccessorImpl.dropColumn(DBAccessorImpl.java:974)
at
org.apache.ambari.server.upgrade.UpgradeCatalog260.updateUpgradeTable(UpgradeCatalog260.java:333)
at
org.apache.ambari.server.upgrade.UpgradeCatalog260.executeDDLUpdates(UpgradeCatalog260.java:200)
at
org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:923)
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:200)
... 1 more
Diffs
-----
ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java
09316be8b3
ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog260.java
6f379858c0
Diff: https://reviews.apache.org/r/63150/diff/1/
Testing (updated)
-------
Live cluster check passed
Tests passed
Thanks,
Dmitro Lisnichenko
