You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@ambari.apache.org by sm...@apache.org on 2013/06/04 21:54:01 UTC

svn commit: r1489582 - /incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql

Author: smohanty
Date: Tue Jun  4 19:54:01 2013
New Revision: 1489582

URL: http://svn.apache.org/r1489582
Log:
AMBARI-2255. Ambari failes to start after upgrading from 1.2.3 to 1.2.4. (Myroslav Papirkovskyy via smohanty)

Modified:
    incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql

Modified: incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql
URL: http://svn.apache.org/viewvc/incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql?rev=1489582&r1=1489581&r2=1489582&view=diff
==============================================================================
--- incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql (original)
+++ incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql Tue Jun  4 19:54:01 2013
@@ -29,6 +29,11 @@ ALTER TABLE ambari.clusterstate
 CREATE TABLE ambari.metainfo ("metainfo_key" VARCHAR(255), "metainfo_value" VARCHAR, PRIMARY KEY("metainfo_key"));
 GRANT ALL PRIVILEGES ON TABLE ambari.metainfo TO :username;
 
+ALTER TABLE ambari.hostconfigmapping
+  ADD COLUMN user_name VARCHAR(255) NOT NULL DEFAULT '_db';
+ALTER TABLE ambari.clusterconfigmapping
+  ADD COLUMN user_name VARCHAR(255) NOT NULL DEFAULT '_db';
+
 CREATE TABLE ambari.hostconfigmapping (cluster_id bigint NOT NULL, host_name VARCHAR(255) NOT NULL, type_name VARCHAR(255) NOT NULL, version_tag VARCHAR(255) NOT NULL, service_name VARCHAR(255), create_timestamp BIGINT NOT NULL, selected INTEGER NOT NULL DEFAULT 0, user_name VARCHAR(255) NOT NULL DEFAULT '_db', PRIMARY KEY (cluster_id, host_name, type_name, create_timestamp));
 GRANT ALL PRIVILEGES ON TABLE ambari.hostconfigmapping TO :username;
 ALTER TABLE ambari.hostconfigmapping ADD CONSTRAINT FK_hostconfigmapping_cluster_id FOREIGN KEY (cluster_id) REFERENCES ambari.clusters (cluster_id);