You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2015/03/28 16:52:53 UTC
[jira] [Commented] (AMBARI-10246) Ambari-server does not start with
Postgres_External
[ https://issues.apache.org/jira/browse/AMBARI-10246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14385374#comment-14385374 ]
Hudson commented on AMBARI-10246:
---------------------------------
SUCCESS: Integrated in Ambari-trunk-Commit #2138 (See [https://builds.apache.org/job/Ambari-trunk-Commit/2138/])
AMBARI-10246. Ambari-server does not start with Postgres_External (aonishuk) (aonishuk: http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=bfd0babd4f08c002aec747afd154727c83076900)
* ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
> Ambari-server does not start with Postgres_External
> ---------------------------------------------------
>
> Key: AMBARI-10246
> URL: https://issues.apache.org/jira/browse/AMBARI-10246
> Project: Ambari
> Issue Type: Bug
> Reporter: Andrew Onischuk
> Assignee: Andrew Onischuk
> Fix For: 2.1.0
>
>
> 1. Setup ambari-server with postgres_external DB
> 2. There is a warning for postgres embedded, setup perfomes successfully, ambari-server does not start.
> **WARNING: Before starting Ambari Server, you must run the following DDL against the database to create the schema: /var/lib/ambari-server/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql**
> The job example : <http://linux-jenkins.qe.hortonworks.com:8080/job/Run-
> Ambari-Setup/1385/console>
> Pay attention to these errors while filling DB:
>
>
> BEGIN
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:893: ERROR: duplicate key value violates unique constraint "ambari_sequences_pkey"
> DETAIL: Key (sequence_name)=(upgrade_group_id_seq) already exists.
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:900: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:903: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:908: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:911: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:914: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:923: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:926: ERROR: current transaction is aborted, commands ignored until end of transaction block
> psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:929: ERROR: current transaction is aborted, commands ignored until end of transaction block
> ROLLBACK
>
> The db output : <http://pastebin.com/9ntw9CC3>
>
>
> ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -q -i /grid/0/jenkins/workspace/Run-Ambari-Setup/build-utils/openstack-utils/accounts/hw-qe-keypair.pem root@172.22.71.84 "ambari-server setup --database=postgres --databasehost=us-rare-mon-rhe6-5013-re-4.novalocal --databaseport=5432 --databasename=ambari --databaseusername=ambari --databasepassword=bigdata --java-home=/usr/lib/jvm/java-1.7.0-openjdk.x86_64 -s"
> Using python /usr/bin/python2.6
> Setup ambari-server
> Checking SELinux...
> SELinux status is 'enabled'
> SELinux mode is 'enforcing'
> Temporarily disabling SELinux
> WARNING: SELinux is set to 'permissive' mode and temporarily disabled.
> OK to continue [y/n] (y)?
> Customize user account for ambari-server daemon [y/n] (n)?
> Adjusting ambari-server permissions and ownership...
> Checking firewall status...
> Checking JDK...
> WARNING: JAVA_HOME /usr/lib/jvm/java-1.7.0-openjdk.x86_64 must be valid on ALL hosts
> WARNING: JCE Policy files are required for configuring Kerberos security. If you plan to use Kerberos,please make sure JCE Unlimited Strength Jurisdiction Policy Files are valid on all hosts.
> Completing setup...
> Configuring database...
> Configuring database...
> Configuring ambari database...
> Configuring remote database connection properties...
> WARNING: Before starting Ambari Server, you must run the following DDL against the database to create the schema: /var/lib/ambari-server/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql
> Proceed with configuring remote database connection properties [y/n] (y)?
> Extracting system views...
> .ambari-admin-2.1.0.19.jar
> ..
> Adjusting ambari-server permissions and ownership...
> Ambari Server 'setup' completed successfully.
>
>
>
> Starting ambari-server
> Ambari Server running with administrator privileges.
> Organizing resource files at /var/lib/ambari-server/resources...
> Server PID at: /var/run/ambari-server/ambari-server.pid
> Server out at: /var/log/ambari-server/ambari-server.out
> Server log at: /var/log/ambari-server/ambari-server.log
> Waiting for server start....................
> ERROR: Exiting with exit code -1.
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)