[ 
https://issues.apache.org/jira/browse/AMBARI-23587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Doroszlai, Attila updated AMBARI-23587:
---------------------------------------
    Labels: upgrade  (was: )

> Ambari Schema Upgrade Failing source 2.6.1.0 target 2.7.0.0
> -----------------------------------------------------------
>
>                 Key: AMBARI-23587
>                 URL: https://issues.apache.org/jira/browse/AMBARI-23587
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.7.0
>            Reporter: Pradarttana
>            Assignee: Doroszlai, Attila
>            Priority: Critical
>              Labels: upgrade
>             Fix For: 2.7.0
>
>
> {code:title=ambari-server.log}
> 16 Apr 2018 11:04:47,676 INFO [main] DBAccessorImpl:876 - Executing query: 
> ALTER TABLE stage ADD status VARCHAR2(255) NULL
> 16 Apr 2018 11:04:47,695 ERROR [main] SchemaUpgradeHelper:207 - Upgrade 
> failed.
> java.sql.SQLSyntaxErrorException: ORA-00904: "PENDING": invalid identifier
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
>  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
>  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
>  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
>  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
>  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
>  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
>  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
>  at 
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
>  at 
> oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
>  at 
> oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
>  at 
> oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
>  at 
> org.apache.ambari.server.orm.DBAccessorImpl.updateTable(DBAccessorImpl.java:829)
>  at 
> org.apache.ambari.server.orm.DBAccessorImpl.addColumn(DBAccessorImpl.java:632)
>  at 
> org.apache.ambari.server.upgrade.UpgradeCatalog270.updateStageTable(UpgradeCatalog270.java:842)
>  at 
> org.apache.ambari.server.upgrade.UpgradeCatalog270.executeDDLUpdates(UpgradeCatalog270.java:283)
>  at 
> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:973)
>  at 
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:205)
>  at 
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:448)
> 16 Apr 2018 11:04:47,695 ERROR [main] SchemaUpgradeHelper:473 - Exception 
> occurred during upgrade, failed
> org.apache.ambari.server.AmbariException: ORA-00904: "PENDING": invalid 
> identifier
> at 
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:208)
>  at 
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:448)
> Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "PENDING": invalid 
> identifier
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
>  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
>  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
>  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
>  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
>  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
>  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
>  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
>  at 
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
>  at 
> oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
>  at 
> oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
>  at 
> oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
>  at 
> org.apache.ambari.server.orm.DBAccessorImpl.updateTable(DBAccessorImpl.java:829)
>  at 
> org.apache.ambari.server.orm.DBAccessorImpl.addColumn(DBAccessorImpl.java:632)
>  at 
> org.apache.ambari.server.upgrade.UpgradeCatalog270.updateStageTable(UpgradeCatalog270.java:842)
>  at 
> org.apache.ambari.server.upgrade.UpgradeCatalog270.executeDDLUpdates(UpgradeCatalog270.java:283)
>  at 
> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:973)
>  at 
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:205)
>  ... 1 more
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to