[AMBARI-5154] Upgrade from 1.4.4 to 1.5.0 failed on Oracle DB

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: 1.5.0
• Component/s: ambari-server
• Assignee: Siddharth Wagle
• Reporter: Siddharth Wagle
• Created: 20/Mar/14 00:18
• Updated: 20/Mar/14 01:06
• Resolved: 20/Mar/14 01:06

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)