----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/45815/#review127348 -----------------------------------------------------------
Ship it! Ship It! - Myroslav Papirkovskyy On Квітень 6, 2016, 6:47 після полудня, Andrew Onischuk wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/45815/ > ----------------------------------------------------------- > > (Updated Квітень 6, 2016, 6:47 після полудня) > > > Review request for Ambari and Myroslav Papirkovskyy. > > > Bugs: AMBARI-15737 > https://issues.apache.org/jira/browse/AMBARI-15737 > > > Repository: ambari > > > Description > ------- > > Artifacts: > <http://qelog.hortonworks.com/log/os-r7-rjjfis-dergtodergm10dwngd-r7/artifacts > /artifacts/screenshots/com.hw.ambari.ui.tests.monitoring.admin_page.e2e_expres > s_upgrade.E2E_EU_AmbariUpgrade/test001_performAmbariUpgrade/_5_22_52_6_Ambari_ > schema_upgrade_failed/> > > **Steps** > > 1. Install Ambari 2.2.1.1 with HDP-2.4.0.0 and Oracle as Ambari DB > 2. Upgrade Ambari to ambari-server-2.2.2.0-385.x86_64. As part of running > "ambari-server upgrade", observed below error: > > > > 05 Apr 2016 22:51:48,890 INFO [main] AbstractUpgradeCatalog:491 - No > changes detected to config hive-site. Skipping configuration properties update > 05 Apr 2016 22:51:49,159 INFO [main] DBAccessorImpl:744 - Executing > query: CREATE INDEX idx_hrc_status ON host_role_command (status, role) > 05 Apr 2016 22:51:49,203 ERROR [main] DBAccessorImpl:750 - Error > executing query: CREATE INDEX idx_hrc_status ON host_role_command (status, > role) > java.sql.SQLException: ORA-01408: such column list already indexed > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) > at > oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) > at > oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890) > at > oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855) > at > oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304) > at > org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:747) > at > org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:739) > at > org.apache.ambari.server.orm.DBAccessorImpl.createIndex(DBAccessorImpl.java:416) > at > org.apache.ambari.server.upgrade.UpgradeCatalog222.updateHostRoleCommands(UpgradeCatalog222.java:296) > at > org.apache.ambari.server.upgrade.UpgradeCatalog222.executeDMLUpdates(UpgradeCatalog222.java:180) > at > org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:662) > at > org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:228) > at > org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:305) > 05 Apr 2016 22:51:49,205 ERROR [main] SchemaUpgradeHelper:230 - Upgrade > failed. > java.sql.SQLException: ORA-01408: such column list already indexed > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) > > > Not sure if this is a regression > > > Diffs > ----- > > > ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog222.java > 7021a46 > > ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog222Test.java > 7321f69 > > Diff: https://reviews.apache.org/r/45815/diff/ > > > Testing > ------- > > mvn clean test > > > Thanks, > > Andrew Onischuk > >