You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Alejandro Fernandez (JIRA)" <ji...@apache.org> on 2014/07/08 00:01:34 UTC
[jira] [Created] (AMBARI-6409) Postgres create script generates
errors for clusterconfig
Alejandro Fernandez created AMBARI-6409:
-------------------------------------------
Summary: Postgres create script generates errors for clusterconfig
Key: AMBARI-6409
URL: https://issues.apache.org/jira/browse/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.
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 http://public-repo-1.hortonworks.com/ambari/centos6/1.x/updates/1.6.0/ambari.repo
* 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 http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm
* 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 http://docs.hortonworks.com/HDPDocuments/Ambari-1.6.0.0/bk_ambari_reference/content/nndb-using-ambari-postgresql.html 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
(v6.2#6252)