[jira] [Created] (AMBARI-10246) Ambari-server does not start with Postgres_External

["Andrew Onischuk (JIRA)" <ji...@apache.org>]

Andrew Onischuk created AMBARI-10246:
----------------------------------------

             Summary: 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)