[
https://issues.apache.org/jira/browse/AMBARI-21110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16124159#comment-16124159
]
Aravindan Vijayan commented on AMBARI-21110:
--------------------------------------------
[~aonishuk] Can you commit this to branch-2.5 and resolve it?
> ambari-server setup fails with default postgres
> -----------------------------------------------
>
> Key: AMBARI-21110
> URL: https://issues.apache.org/jira/browse/AMBARI-21110
> Project: Ambari
> Issue Type: Bug
> Reporter: Andrew Onischuk
> Assignee: Andrew Onischuk
> Fix For: 2.5.2
>
> Attachments: AMBARI-21110.patch
>
>
> 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
>
>
>
> [email protected] "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] (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] (y)?
> 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] (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
> [email protected] "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
> [email protected] "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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
