[
https://issues.apache.org/jira/browse/AMBARI-5154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Siddharth Wagle updated AMBARI-5154:
------------------------------------
Description:
clusterconfigmapping table already exists
ambari-server.log
{noformat}
19:02:48,449 INFO [main] DBAccessorImpl:419 - Executing query: CREATE TABLE
clusterconfigmapping (cluster_id NUMBER(19) NOT NULL, type_name VARCHAR2(255)
NOT NULL, version_tag VARCHAR2(255) NOT NULL, create_timestamp NUMBER(19) NOT
NULL, selected NUMBER(10) NOT NULL, user_name VARCHAR2(255) NOT NULL, PRIMARY
KEY (cluster_id, type_name, create_timestamp))
19:02:48,465 WARN [main] DBAccessorImpl:424 - Error executing query: CREATE
TABLE clusterconfigmapping (cluster_id NUMBER(19) NOT NULL, type_name
VARCHAR2(255) NOT NULL, version_tag VARCHAR2(255) NOT NULL, create_timestamp
NUMBER(19) NOT NULL, selected NUMBER(10) NOT NULL, user_name VARCHAR2(255) NOT
NULL, PRIMARY KEY (cluster_id, type_name, create_timestamp))
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an
existing object
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at
org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:422)
at
org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:408)
at
org.apache.ambari.server.orm.DBAccessorImpl.createTable(DBAccessorImpl.java:111)
at
org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:84)
at
org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177)
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174)
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234)
{noformat}
was:
clusterconfigmapping table already exists
ambari-server.log
{noformat}
19:02:48,449 INFO [main] DBAccessorImpl:419 - Executing query: CREATE TABLE
clusterconfigmapping (cluster_id NUMBER(19) NOT NULL, type_name VARCHAR2(255)
NOT NULL, version_tag VARCHAR2(255) NOT NULL, create_timestamp NUMBER(19) NOT
NULL, selected NUMBER(10) NOT NULL, user_name VARCHAR2(255) NOT NULL, PRIMARY
KEY (cluster_id, type_name, create_timestamp))
19:02:48,465 WARN [main] DBAccessorImpl:424 - Error executing query: CREATE
TABLE clusterconfigmapping (cluster_id NUMBER(19) NOT NULL, type_name
VARCHAR2(255) NOT NULL, version_tag VARCHAR2(255) NOT NULL, create_timestamp
NUMBER(19) NOT NULL, selected NUMBER(10) NOT NULL, user_name VARCHAR2(255) NOT
NULL, PRIMARY KEY (cluster_id, type_name, create_timestamp))
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an
existing object
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at
org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:422)
at
org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:408)
at
org.apache.ambari.server.orm.DBAccessorImpl.createTable(DBAccessorImpl.java:111)
at
org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:84)
at
org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177)
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174)
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234)
19:02:48,468 ERROR [main] SchemaUpgradeHelper:179 - Upgrade failed.
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an
existing object
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
{noformat}
> Upgrade from 1.4.4 to 1.5.0 failed on Oracle DB
> -----------------------------------------------
>
> Key: AMBARI-5154
> URL: https://issues.apache.org/jira/browse/AMBARI-5154
> Project: Ambari
> Issue Type: Bug
> Components: controller
> Affects Versions: 1.5.0
> Reporter: Siddharth Wagle
> Assignee: Siddharth Wagle
> Fix For: 1.5.0
>
>
> clusterconfigmapping table already exists
> ambari-server.log
> {noformat}
> 19:02:48,449 INFO [main] DBAccessorImpl:419 - Executing query: CREATE TABLE
> clusterconfigmapping (cluster_id NUMBER(19) NOT NULL, type_name VARCHAR2(255)
> NOT NULL, version_tag VARCHAR2(255) NOT NULL, create_timestamp NUMBER(19) NOT
> NULL, selected NUMBER(10) NOT NULL, user_name VARCHAR2(255) NOT NULL, PRIMARY
> KEY (cluster_id, type_name, create_timestamp))
> 19:02:48,465 WARN [main] DBAccessorImpl:424 - Error executing query: CREATE
> TABLE clusterconfigmapping (cluster_id NUMBER(19) NOT NULL, type_name
> VARCHAR2(255) NOT NULL, version_tag VARCHAR2(255) NOT NULL, create_timestamp
> NUMBER(19) NOT NULL, selected NUMBER(10) NOT NULL, user_name VARCHAR2(255)
> NOT NULL, PRIMARY KEY (cluster_id, type_name, create_timestamp))
> java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an
> existing object
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
> at
> oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
> at
> oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
> at
> oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:422)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:408)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.createTable(DBAccessorImpl.java:111)
> at
> org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:84)
> at
> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
