Author: smohanty
Date: Tue Jun 4 19:58:05 2013
New Revision: 1489587
URL: http://svn.apache.org/r1489587
Log:
AMBARI-2255. Ambari failes to start after upgrading from 1.2.3 to 1.2.4.
(Myroslav Papirkovskyy via smohanty)
Modified:
incubator/ambari/trunk/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql
Modified:
incubator/ambari/trunk/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql
URL:
http://svn.apache.org/viewvc/incubator/ambari/trunk/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql?rev=1489587&r1=1489586&r2=1489587&view=diff
==============================================================================
---
incubator/ambari/trunk/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql
(original)
+++
incubator/ambari/trunk/ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Postgres-UPGRADE-1.3.0.sql
Tue Jun 4 19:58:05 2013
@@ -26,6 +26,10 @@ ALTER TABLE ambari.hosts
ALTER TABLE ambari.clusterstate
ADD COLUMN current_stack_version VARCHAR(255) NOT NULL;
+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;
