You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by Andrew Onischuk <ao...@hortonworks.com> on 2015/05/12 14:13:26 UTC
Review Request 34095: Can not upgrade ambari 2.0.0->2.0.1 on sles113
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34095/
-----------------------------------------------------------
Review request for Ambari and Vitalyi Brodetskyi.
Bugs: AMBARI-11063
https://issues.apache.org/jira/browse/AMBARI-11063
Repository: ambari
Description
-------
STR:
1) Install Ambari 2.0.0, stack 2.2 with default options
2) Ambari-only upgrade
Results:
ambari-server upgrade failed:
08 May 2015 08:46:24,771 INFO [main] Configuration:527 - Reading password from existing file
08 May 2015 08:46:24,789 INFO [main] Configuration:747 - Hosts Mapping File null
08 May 2015 08:46:24,789 INFO [main] HostsMap:60 - Using hostsmap file null
08 May 2015 08:46:25,435 INFO [main] ControllerModule:173 - Detected POSTGRES as the database type from the JDBC URL
08 May 2015 08:46:31,576 INFO [main] SchemaUpgradeHelper:231 - Upgrading schema to target version = 2.0.1
08 May 2015 08:46:31,615 INFO [main] SchemaUpgradeHelper:240 - Upgrading schema from source version = 2.0.0
08 May 2015 08:46:31,621 INFO [main] SchemaUpgradeHelper:147 - Upgrade path: [{ upgradeCatalog: sourceVersion = 1.7.0, targetVersion = 2.0.1 }]
08 May 2015 08:46:31,622 INFO [main] SchemaUpgradeHelper:180 - Executing DDL upgrade...
08 May 2015 08:46:31,622 INFO [main] DBAccessorImpl:547 - Executing query: ALTER SCHEMA ambari OWNER TO "ambari";
08 May 2015 08:46:31,623 INFO [main] DBAccessorImpl:547 - Executing query: ALTER ROLE "ambari" SET search_path to 'ambari';
08 May 2015 08:46:31,632 INFO [main] DBAccessorImpl:547 - Executing query: INSERT INTO ambari_sequences(sequence_name, sequence_value) VALUES('repo_version_id_seq', 0)
08 May 2015 08:46:31,635 ERROR [main] DBAccessorImpl:553 - Error executing query: INSERT INTO ambari_sequences(sequence_name, sequence_value) VALUES('repo_version_id_seq', 0)
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:550)
at org.apache.ambari.server.upgrade.UpgradeCatalog200.prepareRollingUpgradesDDL(UpgradeCatalog200.java:204)
at org.apache.ambari.server.upgrade.UpgradeCatalog200.executeDDLUpdates(UpgradeCatalog200.java:123)
at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:371)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:185)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:245)
08 May 2015 08:46:31,638 ERROR [main] SchemaUpgradeHelper:187 - Upgrade failed.
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:550)
at org.apache.ambari.server.upgrade.UpgradeCatalog200.prepareRollingUpgradesDDL(UpgradeCatalog200.java:204)
at org.apache.ambari.server.upgrade.UpgradeCatalog200.executeDDLUpdates(UpgradeCatalog200.java:123)
at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:371)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:185)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:245)
08 May 2015 08:46:31,643 ERROR [main] SchemaUpgradeHelper:258 - Exception occured during upgrade, failed
org.apache.ambari.server.AmbariException: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:188)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:245)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:550)
at org.apache.ambari.server.upgrade.UpgradeCatalog200.prepareRollingUpgradesDDL(UpgradeCatalog200.java:204)
at org.apache.ambari.server.upgrade.UpgradeCatalog200.executeDDLUpdates(UpgradeCatalog200.java:123)
at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:371)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:185)
... 1 more
Diffs
-----
ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessor.java 2b01c72
ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java 279c78f
ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog200.java dd6d6dd
ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog200Test.java 76552bc
Diff: https://reviews.apache.org/r/34095/diff/
Testing
-------
mvn clean test
Thanks,
Andrew Onischuk
Re: Review Request 34095: Can not upgrade ambari 2.0.0->2.0.1 on
sles113
Posted by Vitalyi Brodetskyi <vb...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34095/#review83390
-----------------------------------------------------------
Ship it!
Ship It!
- Vitalyi Brodetskyi
On Травень 12, 2015, 12:13 після полудня, Andrew Onischuk wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/34095/
> -----------------------------------------------------------
>
> (Updated Травень 12, 2015, 12:13 після полудня)
>
>
> Review request for Ambari and Vitalyi Brodetskyi.
>
>
> Bugs: AMBARI-11063
> https://issues.apache.org/jira/browse/AMBARI-11063
>
>
> Repository: ambari
>
>
> Description
> -------
>
> STR:
> 1) Install Ambari 2.0.0, stack 2.2 with default options
> 2) Ambari-only upgrade
> Results:
> ambari-server upgrade failed:
>
>
>
> 08 May 2015 08:46:24,771 INFO [main] Configuration:527 - Reading password from existing file
> 08 May 2015 08:46:24,789 INFO [main] Configuration:747 - Hosts Mapping File null
> 08 May 2015 08:46:24,789 INFO [main] HostsMap:60 - Using hostsmap file null
> 08 May 2015 08:46:25,435 INFO [main] ControllerModule:173 - Detected POSTGRES as the database type from the JDBC URL
> 08 May 2015 08:46:31,576 INFO [main] SchemaUpgradeHelper:231 - Upgrading schema to target version = 2.0.1
> 08 May 2015 08:46:31,615 INFO [main] SchemaUpgradeHelper:240 - Upgrading schema from source version = 2.0.0
> 08 May 2015 08:46:31,621 INFO [main] SchemaUpgradeHelper:147 - Upgrade path: [{ upgradeCatalog: sourceVersion = 1.7.0, targetVersion = 2.0.1 }]
> 08 May 2015 08:46:31,622 INFO [main] SchemaUpgradeHelper:180 - Executing DDL upgrade...
> 08 May 2015 08:46:31,622 INFO [main] DBAccessorImpl:547 - Executing query: ALTER SCHEMA ambari OWNER TO "ambari";
> 08 May 2015 08:46:31,623 INFO [main] DBAccessorImpl:547 - Executing query: ALTER ROLE "ambari" SET search_path to 'ambari';
> 08 May 2015 08:46:31,632 INFO [main] DBAccessorImpl:547 - Executing query: INSERT INTO ambari_sequences(sequence_name, sequence_value) VALUES('repo_version_id_seq', 0)
> 08 May 2015 08:46:31,635 ERROR [main] DBAccessorImpl:553 - Error executing query: INSERT INTO ambari_sequences(sequence_name, sequence_value) VALUES('repo_version_id_seq', 0)
> org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:550)
> at org.apache.ambari.server.upgrade.UpgradeCatalog200.prepareRollingUpgradesDDL(UpgradeCatalog200.java:204)
> at org.apache.ambari.server.upgrade.UpgradeCatalog200.executeDDLUpdates(UpgradeCatalog200.java:123)
> at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:371)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:185)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:245)
> 08 May 2015 08:46:31,638 ERROR [main] SchemaUpgradeHelper:187 - Upgrade failed.
> org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:550)
> at org.apache.ambari.server.upgrade.UpgradeCatalog200.prepareRollingUpgradesDDL(UpgradeCatalog200.java:204)
> at org.apache.ambari.server.upgrade.UpgradeCatalog200.executeDDLUpdates(UpgradeCatalog200.java:123)
> at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:371)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:185)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:245)
> 08 May 2015 08:46:31,643 ERROR [main] SchemaUpgradeHelper:258 - Exception occured during upgrade, failed
> org.apache.ambari.server.AmbariException: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:188)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:245)
> Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:550)
> at org.apache.ambari.server.upgrade.UpgradeCatalog200.prepareRollingUpgradesDDL(UpgradeCatalog200.java:204)
> at org.apache.ambari.server.upgrade.UpgradeCatalog200.executeDDLUpdates(UpgradeCatalog200.java:123)
> at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:371)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:185)
> ... 1 more
>
>
> Diffs
> -----
>
> ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessor.java 2b01c72
> ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java 279c78f
> ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog200.java dd6d6dd
> ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog200Test.java 76552bc
>
> Diff: https://reviews.apache.org/r/34095/diff/
>
>
> Testing
> -------
>
> mvn clean test
>
>
> Thanks,
>
> Andrew Onischuk
>
>