ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-15737) Ambari DB schema upgrade fails with ORA-01408 error
Date Wed, 06 Apr 2016 17:37:25 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-15737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15228710#comment-15228710
] 

Hudson commented on AMBARI-15737:
---------------------------------

SUCCESS: Integrated in Ambari-branch-2.2 #600 (See [https://builds.apache.org/job/Ambari-branch-2.2/600/])
AMBARI-15737. Ambari DB schema upgrade fails with ORA-01408 error (aonishuk: [http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=4bc6a52a4187c7314486ef16245591cae7cbb527])
* ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog222.java
* ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog222Test.java


> Ambari DB schema upgrade fails with ORA-01408 error
> ---------------------------------------------------
>
>                 Key: AMBARI-15737
>                 URL: https://issues.apache.org/jira/browse/AMBARI-15737
>             Project: Ambari
>          Issue Type: Bug
>            Reporter: Andrew Onischuk
>            Assignee: Andrew Onischuk
>             Fix For: 2.2.2
>
>         Attachments: AMBARI-15737.patch
>
>
> 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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message