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