ambari SERVER not running?

[#1]

Hi ,

i asked this question but during the boot it says Ambari server Running, i tried to start it also using /etc/rc.d/init.d/ambari...

I can access virtual-box-ip:8888, virtual-box-ip:8000 but i just CANT access AMBARI.

Another issue is what is the full hdfs URI in pig? hdfs://ip:port/file ... what are the ip and port numbers?

Using ambari i need to start HISTORYSERVER because pig is not running in mapreduce mode :

016-01-28 17:04:12,013 [main] INFO  org.apache.hadoop.yarn.client.api.impl.TimelineClientImpl - Timeline service address: http://sandbox.hortonworks.com:8188/ws/v1/timeline/ 2016-01-28 17:04:12,015 [main] INFO  org.apache.hadoop.yarn.client.RMProxy - Connecting to ResourceManager at sandbox.hortonworks.com/10.0.1.47:8050 2016-01-28 17:04:12,097 [main] INFO  org.apache.hadoop.mapred.ClientServiceDelegate - Application state is completed. FinalApplicationStatus=FAILED. Redirecting to job history server 2016-01-28 17:04:13,102 [main] INFO  org.apache.hadoop.ipc.Client - Retrying connect to server: sandbox.hortonworks.com/10.0.1.47:10020. Already tried 0 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS) 2016-01-28 17:04:14,103 [main] INFO  org.apache.hadoop.ipc.Client - Retrying connect to server: sandbox.hortonworks.com/10.0.1.47:10020. Already tried 1 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS)

here is a log

[root@sandbox ~]# ambari-server status Using python /usr/bin/python2.6 Ambari-server status Ambari Server not running. Stale PID File at: /var/run/ambari-server/ambari-server.pid [root@sandbox ~]# ambari-server start Using python /usr/bin/python2.6 Starting ambari-server Ambari Server running with administrator privileges. Running initdb: This may take upto a minute. About to start PostgreSQL ERROR: Exiting with exit code 3. REASON: Unable to start PostgreSQL server. Status stopped. . Exiting

Thanks.

[#2]

Could you please check the ambari-server log (/var/log/ambari-server/..) for any errors?

Also try to (re)start your postgres db manually. Afterwards restart the ambari server

service postgresql start
ambari-server start

[#3]

@John Smith agree with Jonas

About to start PostgreSQL ERROR: Exiting with exit code 3. REASON: Unable to start PostgreSQL server. Status stopped. . Exiting

[#4]

Ambari server went down when firing a Hive command on MySQL Hive instance. Any help/inputs on what all are these PSQL errors caused by ?

Call: ALTER TABLE serviceconfigmapping ADD CONSTRAINT FK_serviceconfigmapping_service_config_id FOREIGN KEY (service_config_id) REFERENCES serviceconfig (service_config_id)

Query: DataModifyQuery(sql="ALTER TABLE serviceconfigmapping ADD CONSTRAINT FK_serviceconfigmapping_service_config_id FOREIGN KEY (service_config_id) REFERENCES serviceconfig (service_config_id)")

[EL Warning]: 2016-04-29 09:57:49.244--ServerSession(162325884)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: org.postgresql.util.PSQLException: ERROR: must be owner of relation alert_grouping

Error Code: 0

Call: ALTER TABLE alert_grouping ADD CONSTRAINT FK_alert_grouping_group_id FOREIGN KEY (group_id) REFERENCES alert_group (group_id)

Query: DataModifyQuery(sql="ALTER TABLE alert_grouping ADD CONSTRAINT FK_alert_grouping_group_id FOREIGN KEY (group_id) REFERENCES alert_group (group_id)")

Apr 29, 2016 9:57:53 AM com.sun.jersey.spi.inject.Errors processErrorMessages

WARNING: The following warnings have been detected with resource and/or provider classes:

WARNING: A HTTP GET method, public javax.ws.rs.core.Response org.apache.ambari.server.api.services.HostComponentService.getHostComponents(java.lang.String,javax.ws.rs.core.HttpHeaders,javax.ws.rs.core.UriInfo), should not consume any entity.

WARNING: A HTTP GET method, public javax.ws.rs.core.Response org.apache.ambari.server.api.services.HostComponentService.getHostComponent(java.lang.String,javax.ws.rs.core.HttpHeaders,javax.ws.rs.core.UriInfo,java.lang.String,java.lang.String), should not consume any entity.

Apr 29, 2016 9:58:02 AM com.sun.jersey.spi.inject.Errors processErrorMessages

WARNING: The following warnings have been detected with resource and/or provider classes:

WARNING: A HTTP GET method, public javax.ws.rs.core.Response org.apache.ambari.server.api.services.ActiveWidgetLayoutService.getServices(java.lang.String,javax.ws.rs.core.HttpHeaders,javax.ws.rs.core.UriInfo), should not consume any entity.

Apr 29, 2016 10:00:34 AM com.sun.jersey.spi.inject.Errors processErrorMessages

WARNING: The following warnings have been detected with resource and/or provider classes:

WARNING: A HTTP GET method, public javax.ws.rs.core.Response org.apache.ambari.server.api.services.TaskService.getComponents(java.lang.String,javax.ws.rs.core.HttpHeaders,javax.ws.rs.core.UriInfo), should not consume any entity.

WARNING: A HTTP GET method, public javax.ws.rs.core.Response org.apache.ambari.server.api.services.TaskService.getTask(java.lang.String,javax.ws.rs.core.HttpHeaders,javax.ws.rs.core.UriInfo,java.lang.String), should not consume any entity.

Apr 29, 2016 10:02:36 AM com.sun.jersey.spi.container.ContainerResponse logException

SEVERE: Mapped exception to response: 500 (Internal Server Error)

org.apache.ambari.view.hive.utils.HiveClientFormattedException

at org.apache.ambari.view.hive.resources.jobs.ConnectionController.executeQuery(ConnectionController.java:69)

at org.apache.ambari.view.hive.resources.jobs.viewJobs.JobControllerImpl.submit(JobControllerImpl.java:102)

at org.apache.ambari.view.hive.resources.jobs.JobService.create(JobService.java:405)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

[#5]

hi @Jonas Straub, my postgresql start failed. Have faced similar problem?

[#6]

Pig hdfs URL will not be any different from any other hdfs URL

[#7]

the postgres was corrupted... i restored postgre and now it works... but im occuring different error:

using load function - AvroStorage in mapreduce mode (https://cwiki.apache.org/confluence/display/PIG/AvroStorage)

lLayer.FrontendException: ERROR 1066: Unable to open iterator for alias sensitiveSet. Backend error : java.lang.RuntimeException: could not instantiate 'org.apache.pig.piggybank.storage.avro.AvroStorage' with arguments 'null'

Even documentation says you can execute it during the load without arguments....

[#8]

@John Smith try to submit unrelated questions as separate threads. What do you mean by restoring postgres? Did @Jonas Straub answer solved your problem? Please accept best answer and open a new thread about Avro, I'll try to answer there. Also post your pig script.

[#9]

start the database of ambari

1)service postgres start

start ambari server with the command

2)ambari-server start

Now check 8080 port is open with command

netstat -ano |grep 8080

If this port is open then try to access on local host machine first and then try to access from out side the machin

3) localhost:8080

4)Ip:8080

[#10]

If the UI doesn't load, it's typically the Ambari Server process and/or firewall. In your case, it's also the Postgres service. Try this,

service postgresql restart
service iptables stop
ambari-server restart