----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/62085/#review184679 -----------------------------------------------------------
Ship it! Ship It! - Nate Cole On Sept. 5, 2017, 12:25 p.m., Dmitro Lisnichenko wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/62085/ > ----------------------------------------------------------- > > (Updated Sept. 5, 2017, 12:25 p.m.) > > > Review request for Ambari, Jonathan Hurley and Nate Cole. > > > Bugs: AMBARI-21883 > https://issues.apache.org/jira/browse/AMBARI-21883 > > > Repository: ambari > > > Description > ------- > > When performing an Ambari upgrade to Ambari 2.6.0 using {{ambari-server > upgrade}}, the process fails with the following error: > > {noformat} > 01 Sep 2017 14:36:24,340 ERROR [main] DBAccessorImpl:882 - Error executing > query: DELETE FROM upgrade > org.postgresql.util.PSQLException: ERROR: update or delete on table "upgrade" > violates foreign key constraint "fk_sc_history_upgrade_id" on table > "servicecomponent_history" > Detail: Key (upgrade_id)=(1) is still referenced from table > "servicecomponent_history". > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) > 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 > org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:879) > at > org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:871) > at > org.apache.ambari.server.orm.DBAccessorImpl.clearTable(DBAccessorImpl.java:1502) > at > org.apache.ambari.server.upgrade.UpgradeCatalog260.updateUpgradeTable(UpgradeCatalog260.java:225) > at > org.apache.ambari.server.upgrade.UpgradeCatalog260.executeDDLUpdates(UpgradeCatalog260.java:153) > at > org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:923) > at > org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:197) > at > org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:415) > {noformat} > > > Diffs > ----- > > > ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog260.java > 5d50f29533 > > > Diff: https://reviews.apache.org/r/62085/diff/1/ > > > Testing > ------- > > mvn clean test > > Checked upgrade on live cluster, the issue scoped by jira is fixed. But later > upgrade fails with permissions problems. > > > Thanks, > > Dmitro Lisnichenko > >