-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/45815/
-----------------------------------------------------------

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

Reply via email to