You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@ambari.apache.org by Andrew Onischuk <ao...@hortonworks.com> on 2016/04/06 17:47:46 UTC
Review Request 45815: Ambari DB schema upgrade fails with ORA-01408
error
-----------------------------------------------------------
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
Re: Review Request 45815: Ambari DB schema upgrade fails with
ORA-01408 error
Posted by Myroslav Papirkovskyy <mp...@hortonworks.com>.
-----------------------------------------------------------
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
>
>