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-21363) ORA-00911 error during Ambari server schema upgrade due to incorrect syntax of Update statement
Date Thu, 29 Jun 2017 12:49:00 GMT

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

Hudson commented on AMBARI-21363:
---------------------------------

FAILURE: Integrated in Jenkins build Ambari-branch-2.5 #1643 (See [https://builds.apache.org/job/Ambari-branch-2.5/1643/])
AMBARI-21363 ORA-00911 error during Ambari server schema upgrade due to (hapylestat: [http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=52980df6f7ac8ee22895c2b102f4c5fe6346a12b])
* (edit) ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java
* (edit) ambari-server/src/main/java/org/apache/ambari/server/orm/helpers/dbms/GenericDbmsHelper.java


> ORA-00911 error during Ambari server schema upgrade due to incorrect syntax of Update
statement
> -----------------------------------------------------------------------------------------------
>
>                 Key: AMBARI-21363
>                 URL: https://issues.apache.org/jira/browse/AMBARI-21363
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.5.2
>            Reporter: Vivek Sharma
>            Assignee: Dmytro Grinenko
>            Priority: Blocker
>              Labels: regression, upgrade
>             Fix For: 2.5.2
>
>         Attachments: AMBARI-21363.patch
>
>
> Looks due to the fix of AMBARI-21291 
> *STR*
> # Deployed cluster with Ambari version: 2.2.2.0 and HDP version: 2.4.2.0-258 (Oracle
DB)
> # Upgrade Ambari to target Version: 2.5.2.0-77 | Hash: 3ebf403f9d5065bfc83fae5d699bc4a88f67d179
> *Result*
> {code}
> 28 Jun 2017 04:42:23,733  INFO [main] DBAccessorImpl:848 - Executing query: ALTER TABLE
request ADD cluster_host_info BLOB NULL
> 28 Jun 2017 04:42:23,763  INFO [main] DBAccessorImpl:878 - Executing prepared query:
UPDATE REQUEST SET CLUSTER_HOST_INFO=? WHERE CLUSTER_HOST_INFO IS NULL;
> 28 Jun 2017 04:42:23,770 ERROR [main] DBAccessorImpl:895 - Error executing prepared query:
UPDATE REQUEST SET CLUSTER_HOST_INFO=? WHERE CLUSTER_HOST_INFO IS NULL;
> java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
>         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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
>         at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
>         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
>         at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
>         at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
>         at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
>         at org.apache.ambari.server.orm.DBAccessorImpl.executePreparedQuery(DBAccessorImpl.java:892)
>         at org.apache.ambari.server.orm.DBAccessorImpl.executePreparedUpdate(DBAccessorImpl.java:911)
>         at org.apache.ambari.server.orm.DBAccessorImpl.moveColumnToAnotherTable(DBAccessorImpl.java:1428)
>         at org.apache.ambari.server.upgrade.UpgradeCatalog251.moveClusterHostColumnFromStageToRequest(UpgradeCatalog251.java:131)
>         at org.apache.ambari.server.upgrade.UpgradeCatalog251.executeDDLUpdates(UpgradeCatalog251.java:90)
>         at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:925)
>         at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:208)
>         at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:426)
> 28 Jun 2017 04:42:23,773 ERROR [main] SchemaUpgradeHelper:210 - Upgrade failed.
> java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
>         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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
>         at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
>         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
>         at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
>         at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
>         at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
>         at org.apache.ambari.server.orm.DBAccessorImpl.executePreparedQuery(DBAccessorImpl.java:892)
>         at org.apache.ambari.server.orm.DBAccessorImpl.executePreparedUpdate(DBAccessorImpl.java:911)
>         at org.apache.ambari.server.orm.DBAccessorImpl.moveColumnToAnotherTable(DBAccessorImpl.java:1428)
>         at org.apache.ambari.server.upgrade.UpgradeCatalog251.moveClusterHostColumnFromStageToRequest(UpgradeCatalog251.java:131)
>         at org.apache.ambari.server.upgrade.UpgradeCatalog251.executeDDLUpdates(UpgradeCatalog251.java:90)
>         at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:925)
> {code}
> Issue appears Oracle specific possibly due to missing quotes in ? of the Update SQL statement



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message