You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by Sid Wagle <sw...@hortonworks.com> on 2014/03/20 01:39:23 UTC
Review Request 19442: Upgrade from 1.4.4 to 1.5.0 failed on Oracle DB
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19442/
-----------------------------------------------------------
Review request for Ambari, Mahadev Konar, Myroslav Papirkovskyy, and Sumit Mohanty.
Bugs: AMBARI-5154
https://issues.apache.org/jira/browse/AMBARI-5154
Repository: ambari
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
Diffs
-----
ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java 9f8a359
ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog150.java eb253a4
ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 3225c1c
ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql a585e0a
ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql f7760d4
Diff: https://reviews.apache.org/r/19442/diff/
Testing
-------
Thanks,
Sid Wagle
Re: Review Request 19442: Upgrade from 1.4.4 to 1.5.0 failed on Oracle DB
Posted by Sumit Mohanty <sm...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19442/#review37844
-----------------------------------------------------------
Ship it!
Ship It!
- Sumit Mohanty
On March 20, 2014, 12:54 a.m., Sid Wagle wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/19442/
> -----------------------------------------------------------
>
> (Updated March 20, 2014, 12:54 a.m.)
>
>
> Review request for Ambari, Mahadev Konar, Myroslav Papirkovskyy, and Sumit Mohanty.
>
>
> Bugs: AMBARI-5154
> https://issues.apache.org/jira/browse/AMBARI-5154
>
>
> Repository: ambari
>
>
> 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
>
>
> Diffs
> -----
>
> ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java 9f8a359
> ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog150.java eb253a4
> ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 3225c1c
> ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql a585e0a
> ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql f7760d4
>
> Diff: https://reviews.apache.org/r/19442/diff/
>
>
> Testing
> -------
>
> Results :
>
> Tests run: 1507, Failures: 0, Errors: 0, Skipped: 9
>
> ambari-server.log
>
> 20:39:46,495 INFO [main] SchemaUpgradeHelper:223 - Upgrading schema to target version = 1.5.0.94
> 20:39:46,580 INFO [main] SchemaUpgradeHelper:232 - Upgrading schema from source version = 1.5.0
> 20:39:46,581 INFO [main] SchemaUpgradeHelper:144 - Upgrade path: []
> 20:39:46,581 INFO [main] SchemaUpgradeHelper:172 - Executing DDL upgrade...
> 20:39:47,105 INFO [main] SchemaUpgradeHelper:193 - Execution DML changes.
> 20:39:47,105 INFO [main] SchemaUpgradeHelper:243 - Upgrade successful.
>
>
> Thanks,
>
> Sid Wagle
>
>
Re: Review Request 19442: Upgrade from 1.4.4 to 1.5.0 failed on Oracle DB
Posted by Sumit Mohanty <sm...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19442/#review37840
-----------------------------------------------------------
ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java
<https://reviews.apache.org/r/19442/#comment69600>
Why logging twice?
- Sumit Mohanty
On March 20, 2014, 12:54 a.m., Sid Wagle wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/19442/
> -----------------------------------------------------------
>
> (Updated March 20, 2014, 12:54 a.m.)
>
>
> Review request for Ambari, Mahadev Konar, Myroslav Papirkovskyy, and Sumit Mohanty.
>
>
> Bugs: AMBARI-5154
> https://issues.apache.org/jira/browse/AMBARI-5154
>
>
> Repository: ambari
>
>
> 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
>
>
> Diffs
> -----
>
> ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java 9f8a359
> ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog150.java eb253a4
> ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 3225c1c
> ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql a585e0a
> ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql f7760d4
>
> Diff: https://reviews.apache.org/r/19442/diff/
>
>
> Testing
> -------
>
> Results :
>
> Tests run: 1507, Failures: 0, Errors: 0, Skipped: 9
>
> ambari-server.log
>
> 20:39:46,495 INFO [main] SchemaUpgradeHelper:223 - Upgrading schema to target version = 1.5.0.94
> 20:39:46,580 INFO [main] SchemaUpgradeHelper:232 - Upgrading schema from source version = 1.5.0
> 20:39:46,581 INFO [main] SchemaUpgradeHelper:144 - Upgrade path: []
> 20:39:46,581 INFO [main] SchemaUpgradeHelper:172 - Executing DDL upgrade...
> 20:39:47,105 INFO [main] SchemaUpgradeHelper:193 - Execution DML changes.
> 20:39:47,105 INFO [main] SchemaUpgradeHelper:243 - Upgrade successful.
>
>
> Thanks,
>
> Sid Wagle
>
>
Re: Review Request 19442: Upgrade from 1.4.4 to 1.5.0 failed on Oracle DB
Posted by Sid Wagle <sw...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19442/
-----------------------------------------------------------
(Updated March 20, 2014, 12:54 a.m.)
Review request for Ambari, Mahadev Konar, Myroslav Papirkovskyy, and Sumit Mohanty.
Bugs: AMBARI-5154
https://issues.apache.org/jira/browse/AMBARI-5154
Repository: ambari
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
Diffs
-----
ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java 9f8a359
ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog150.java eb253a4
ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 3225c1c
ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql a585e0a
ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql f7760d4
Diff: https://reviews.apache.org/r/19442/diff/
Testing (updated)
-------
Results :
Tests run: 1507, Failures: 0, Errors: 0, Skipped: 9
ambari-server.log
20:39:46,495 INFO [main] SchemaUpgradeHelper:223 - Upgrading schema to target version = 1.5.0.94
20:39:46,580 INFO [main] SchemaUpgradeHelper:232 - Upgrading schema from source version = 1.5.0
20:39:46,581 INFO [main] SchemaUpgradeHelper:144 - Upgrade path: []
20:39:46,581 INFO [main] SchemaUpgradeHelper:172 - Executing DDL upgrade...
20:39:47,105 INFO [main] SchemaUpgradeHelper:193 - Execution DML changes.
20:39:47,105 INFO [main] SchemaUpgradeHelper:243 - Upgrade successful.
Thanks,
Sid Wagle