Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.5.0
-
None
Description
clusterconfigmapping table already exists
ambari-server.log
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)