----------------------------------------------------------- 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 > >
