Uploaded image for project: 'Ambari'
  1. Ambari
  2. AMBARI-21110

ambari-server setup fails with default postgres

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Cannot Reproduce
    • None
    • 2.5.2
    • None
    • None

    Description

      Thisis the first run with oracle12. Initially infra sets up Ambari with
      default postgres and later on ambari setup happens with Oracle12. But now the
      first setup with default postgres is failing with below error

      root@172.27.24.11 "ambari-server setup --java-home=/base/tools/jdk1.8.0_112 -s"
      2017-05-22 10:57:54.032 Using python /usr/bin/python
      2017-05-22 10:57:54.032 Setup ambari-server
      2017-05-22 10:58:14.299 Checking SELinux...
      2017-05-22 10:58:14.299 SELinux status is 'disabled'
      2017-05-22 10:58:14.299 Customize user account for ambari-server daemon [y/n] ?
      2017-05-22 10:58:14.299 Adjusting ambari-server permissions and ownership...
      2017-05-22 10:58:14.299 Checking firewall status...
      2017-05-22 10:58:14.299 FATAL: Could not load /lib/modules/3.10.0-327.13.1.el7.x86_64/modules.dep: No such file or directory
      2017-05-22 10:58:14.299 iptables v1.4.7: can't initialize iptables table `nat': Permission denied (you must be root)
      2017-05-22 10:58:14.299 Perhaps iptables or your kernel needs to be upgraded.
      2017-05-22 10:58:14.299 FATAL: Could not load /lib/modules/3.10.0-327.13.1.el7.x86_64/modules.dep: No such file or directory
      2017-05-22 10:58:14.299 iptables v1.4.7: can't initialize iptables table `filter': Permission denied (you must be root)
      2017-05-22 10:58:14.299 Perhaps iptables or your kernel needs to be upgraded.
      2017-05-22 10:58:14.299 WARNING: iptables is running. Confirm the necessary Ambari ports are accessible. Refer to the Ambari documentation for more details on ports.
      2017-05-22 10:58:14.299 OK to continue [y/n] ?
      2017-05-22 10:58:14.299 Checking JDK...
      2017-05-22 10:58:14.299 WARNING: JAVA_HOME /base/tools/jdk1.8.0_112 must be valid on ALL hosts
      2017-05-22 10:58:14.299 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.
      2017-05-22 10:58:14.299 Completing setup...
      2017-05-22 10:58:14.299 Configuring database...
      2017-05-22 10:58:14.299 Enter advanced database configuration [y/n] ?
      2017-05-22 10:58:14.299 Configuring database...
      2017-05-22 10:58:14.299 Default properties detected. Using built-in database.
      2017-05-22 10:58:14.299 Configuring ambari database...
      2017-05-22 10:58:14.299 Checking PostgreSQL...
      2017-05-22 10:58:14.299 Running initdb: This may take up to a minute.
      2017-05-22 10:58:14.299 Initializing database: [ OK ]
      2017-05-22 10:58:14.299
      2017-05-22 10:58:14.299 About to start PostgreSQL
      2017-05-22 10:58:14.299 Configuring local database...
      2017-05-22 10:58:14.299 Configuring PostgreSQL...
      2017-05-22 10:58:14.299 Creating schema and user...
      2017-05-22 10:58:14.299 ERROR: Failed to execute command:['ambari-sudo.sh', 'su', 'postgres', '-', '--command=psql -f /var/lib/ambari-server/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql -v username=\'"ambari"\' -v password="\'bigdata\'" -v dbname="ambari"']
      2017-05-22 10:58:14.299 ERROR: stderr:could not change directory to "/root"
      2017-05-22 10:58:14.299 psql: could not connect to server: No such file or directory
      2017-05-22 10:58:14.299 Is the server running locally and accepting
      2017-05-22 10:58:14.299 connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
      2017-05-22 10:58:14.299
      2017-05-22 10:58:14.299 ERROR: stdout:
      2017-05-22 10:58:14.299 failed to execute queries ...retrying (1)
      2017-05-22 10:58:14.299 Creating schema and user...
      2017-05-22 10:58:14.299 ERROR: Failed to execute command:['ambari-sudo.sh', 'su', 'postgres', '-', '--command=psql -f /var/lib/ambari-server/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql -v username=\'"ambari"\' -v password="\'bigdata\'" -v dbname="ambari"']
      2017-05-22 10:58:14.299 ERROR: stderr:could not change directory to "/root"
      2017-05-22 10:58:14.299 psql: could not connect to server: No such file or directory
      2017-05-22 10:58:14.299 Is the server running locally and accepting
      2017-05-22 10:58:14.299 connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
      2017-05-22 10:58:14.299
      2017-05-22 10:58:14.299 ERROR: stdout:
      2017-05-22 10:58:14.299 failed to execute queries ...retrying (2)
      2017-05-22 10:58:14.299 Creating schema and user...
      2017-05-22 10:58:14.299 ERROR: Exiting with exit code 2.
      2017-05-22 10:58:14.299 REASON: Running database init script failed. Exiting.
      2017-05-22 10:58:14.353 Set skip.service.checks=true ambari properties file on the Server host
      2017-05-22 10:58:14.353 ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -q -i /grid/0/jenkins/workspace/Run-Ambari-Setup@4/ycloud/ycloud.pem root@172.27.24.11 "sed -i 's/skip.service.checks=false/skip.service.checks=true/' /etc/ambari-server/conf/ambari.properties"
      2017-05-22 10:58:14.454 ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -q -i /grid/0/jenkins/workspace/Run-Ambari-Setup@4/ycloud/ycloud.pem root@172.27.24.11 "export AMBARI_JVM_ARGS='-Xms512m -Xmx2048m -XX:PermSize=1024m -XX:MaxPermSize=1024m'; ambari-server start --debug" &
      2017-05-22 10:58:14.562 Using python /usr/bin/python
      2017-05-22 10:58:14.562 Starting ambari-server
      2017-05-22 10:58:15.058 ERROR: Exiting with exit code 1.
      2017-05-22 10:58:15.058 REASON: Unable to detect a system user for Ambari Server.
      2017-05-22 10:58:15.058 - If this is a new setup, then run the "ambari-server setup" command to create the user
      2017-05-22 10:58:15.058 - If this is an upgrade of an existing setup, run the "ambari-server upgrade" command.
      2017-05-22 10:58:15.058 Refer to the Ambari documentation for more information on setup and upgrade.
      2017-05-22 10:58:39.459 cmd

      This run had gone through without any issues on the same environment
      configuration during Fenton. It would be great if someone could help take a
      look to see why is it failing now.
      Checked with [Siddharth
      Wagle], and
      retrying after few minutes went fine.

      Attachments

        1. AMBARI-21110.patch
          3 kB
          Andrew Onischuk

        Issue Links

          Activity

            People

              aonishuk Andrew Onischuk
              aonishuk Andrew Onischuk
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: