[AMBARI-23587] Ambari Schema Upgrade Failing source 2.6.1.0 target 2.7.0.0

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.7.0
• Fix Version/s: 2.7.0
• Component/s: ambari-server
• Labels: pull-request-available upgrade
• Assignee: Attila Doroszlai
• Reporter: Pradarttana
• Created: 16/Apr/18 14:48
• Updated: 18/Apr/18 11:37
• Resolved: 18/Apr/18 11:37

Description

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

Issue Links

• links to: GitHub Pull Request #1017