Cloudera Community
manish_raj_anan
user rank
Contributor

Re: Ambari server startup error

by Contributor in Support Questions
‎02-15-2017 04:06 AM
‎02-15-2017 04:06 AM
@Jay SenSharma I performed the above steps. The server log is still showing the same error. I have in fact dropped the "AMBARIDATABASE". While performing the ambari server setup, I remember mentioning the "AMBARIDATABASE" and its schema and user details. Can you please let me know if this can be the issue and how to clean this up? postgres=# drop database "ambaridatabase"; DROP DATABASE postgres=# \list List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- ambari | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres : postgres=CTc/postgres : ambari=CTc/postgres postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres (4 rows) ... View more

Re: Ambari server startup error

by Contributor in Support Questions
‎02-15-2017 03:08 AM
‎02-15-2017 03:08 AM
@apappu ambari-server-log.txt PFA ... View more

Re: Ambari server startup error

by Contributor in Support Questions
‎02-15-2017 02:56 AM
‎02-15-2017 02:56 AM
There isn't any process running. What shall I do next? [root@sandbox ~]# ps -aef | grep ambari-server root 17872 17671 0 02:54 pts/0 00:00:00 grep ambari-server [root@sandbox ~]# ... View more

Re: Ambari server startup error

by Contributor in Support Questions
‎02-15-2017 12:43 AM
‎02-15-2017 12:43 AM
The version is 2.4.0 [root@sandbox ~]# rpm -qa|grep ambari-server ambari-server-2.4.0.0-1225.x86_64 The ambari server isn't starting up. Which process do you you want me to kill?? ... View more

Re: Ambari server startup error

by Contributor in Support Questions
‎02-15-2017 12:35 AM
‎02-15-2017 12:35 AM
The interesting part - Even after changing the parameter to 'ambari' in the properties file, the error log is still throwing the error on 'AMBARIDATABASE'. ... View more

Re: Ambari server startup error

by Contributor in Support Questions
‎02-15-2017 12:31 AM
‎02-15-2017 12:31 AM
Hi, I performed the modification as you mentioned but its still throwing the same error message. ... View more

Re: Ambari server startup error

by Contributor in Support Questions
‎02-14-2017 10:41 PM
‎02-14-2017 10:41 PM
@Rajesh I performed the check and I do see the database name "AMBARIDATABASE". [root@sandbox ~]# cat /etc/ambari-server/conf/ambari.properties | grep -i server.jdbc.database_name server.jdbc.database_name=AMBARIDATABASE [root@sandbox ~]# su - postgres -bash-4.1$ psql psql (8.4.20) Type "help" for help. postgres=# \list List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges ----------------+----------+----------+-------------+-------------+------------------------- ambari | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres : postgres=CTc/postgres : ambari=CTc/postgres ambaridatabase | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres : postgres=CTc/postgres : ambariuser=CTc/postgres postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres (5 rows) postgres=# ... View more

Ambari server startup error

by Contributor in Support Questions
‎02-14-2017 07:55 PM
‎02-14-2017 07:55 PM
Hi, I am getting following error message in the log file "/var/log/ambari-server/ambari-server.log" during ambari server startup. I performed all the steps as mentioned in "https://docs.hortonworks.com/HDPDocuments/Ambari-2.2.1.1/bk_ambari_reference_guide/content/_using_ambari_with_postgresql.html". 14 Feb 2017 21:21:49,597 INFO [main] ClasspathScannerUtils:64 - Found class [class org.apache.ambari.server.audit.request.eventcreator.ViewPrivilegeEventCreator] 14 Feb 2017 21:21:51,229 ERROR [main] DBAccessorImpl:109 - Error while creating database accessor org.postgresql.util.PSQLException: FATAL: database "AMBARIDATABASE" does not exist at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:574) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:177) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:138) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:410) at org.postgresql.Driver.connect(Driver.java:280) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.ambari.server.orm.DBAccessorImpl.<init>(DBAccessorImpl.java:89) ... View more
Labels:

Re: I am getting error while trying to perform Amb...

by Contributor in Support Questions
‎02-10-2017 09:27 PM
‎02-10-2017 09:27 PM
Its not running and throwing error for some issue with PostgreSQL. [root@sandbox ~]# ambari-server status Using python /usr/bin/python Ambari-server status Ambari Server not running. Stale PID File at: /var/run/ambari-server/ambari-server.pid [root@sandbox ~]# ambari-server restart Using python /usr/bin/python Restarting ambari-server Using python /usr/bin/python Stopping ambari-server Ambari Server is not running Using python /usr/bin/python Starting ambari-server Ambari Server running with administrator privileges. Running initdb: This may take up to a minute. About to start PostgreSQL ERROR: Exiting with exit code 1. REASON: Unable to start PostgreSQL server. Status None. . Exiting [root@sandbox ~]# ... View more

Re: I am getting error while trying to perform Amb...

by Contributor in Support Questions
‎02-10-2017 09:00 PM
‎02-10-2017 09:00 PM
Hi @Ameet, I am unable to access the Ambari URL even though http://127.0.0.1:8888/ is accessible. capture.jpg ... View more
Contact Me
Online
Offline
Last Visited
‎03-07-2017 03:47 PM
Community Statistics
Member Since ‎02-10-2017 08:16 PM
Last Visited ‎03-07-2017 03:47 PM
Posts 22
Kudos received 1