ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alejandro Fernandez (JIRA)" <>
Subject [jira] [Created] (AMBARI-6409) Postgres create script generates errors for clusterconfig
Date Mon, 07 Jul 2014 22:01:34 GMT
Alejandro Fernandez created AMBARI-6409:

             Summary: Postgres create script generates errors for clusterconfig
                 Key: AMBARI-6409
             Project: Ambari
          Issue Type: Bug
          Components: build
    Affects Versions: 1.7.0
            Reporter: Alejandro Fernandez
             Fix For: 1.7.0

Manually running the postgres create sql script encountered errors.
* psql:Ambari-DDL-Postgres-CREATE.sql:22: ERROR:  column "config_attributes" specified more
than once
* psql:Ambari-DDL-Postgres-CREATE.sql:103: ERROR:  relation "clusterconfig" does not exist
* psql:Ambari-DDL-Postgres-CREATE.sql:126: ERROR:  relation "clusterconfig" does not exist

Repro Steps:
1. Spin up a CentOS 6.4 VM
  * vagrant up c6401
  * vagrant ssh c6401  
  * sudo su -
  * wget
  * cp ambari.repo /etc/yum.repos.d
  * yum install ambari-server -y

2. Setup a postgres database
  * vi /etc/yum.repos.d/CentOS-Base.repo
  * edit the [base] and [updates] sections by adding the following line without quotes, "exclude=postgresql*"
  * yum localinstall
  * yum install postgresql-server
  * cd /etc/yum.repos.d/
  * service postgresql initdb
  * chkconfig postgresql on
  * service postgresql start

3. Run the script
  * cp /vagrant/Ambari-DDL-Postgres-CREATE.sql /var/lib/ambari-server/resources/     (assuming
you have the latest file from trunk)
  * cp /var/lib/ambari-server/resources/Ambari-DDL-Postgres-CREATE.sql /var/lib/pgsql/
  * su - postgres
  * psql
  * Follow step #1 at
where $AMBARIDATABASE is ambari, $AMBARIUSER is postgres, and $AMBARISCHEMA is ambari.
  * \i Ambari-DDL-Postgres-CREATE.sql;
Then verify the errors. When done, issue \q on the psql command line to exit.

This message was sent by Atlassian JIRA

View raw message