ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Onischuk" <aonis...@hortonworks.com>
Subject Review Request 34095: Can not upgrade ambari 2.0.0->2.0.1 on sles113
Date Tue, 12 May 2015 12:13:26 GMT

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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message