Support Questions

Find answers, ask questions, and share your expertise

How can i remove registered host but do not added.

avatar
Contributor

My cluster have registered hosts but do not added on cluster.

It means that,

I was installed ambari-agent on some hosts.

This hosts registered to ambari-server by changing server hostname on amber-agent.ini

But, I didn't registered on cluster using ambari web UI.

Some times later, when i was checked ambari-server log, ambari server still check this host's heartbeat.

"WARN [ambari-hearbeat-monitor] HeartbeatMonitor:154 - Heartbeat lost from host hostname"

how can i remove this hosts?

1 ACCEPTED SOLUTION

avatar
Contributor

You have a "hoststate" and/or "hosts" table in ambari database which might have an entry of that hostsname which will give you that WARN [ambari-hearbeat-monitor] HeartbeatMonitor:154 - Heartbeat lost from host hostname" on every ambari-server restart is performed as it checks those tables. You might want to have a check if the entry exists then remove those entries by stopping the ambari-server and stopping the ambari-agent of those host which gives you that warning.

Because if the ambari-agent is in running state then you will see the same issue again.

View solution in original post

12 REPLIES 12

avatar
Contributor

You could remove via delete statement in psql..

1) Removing table entries in hoststate : Delete from hoststate where host_id=xx

2) Removing table entries from hosts : Delete from hosts where host_id=xx

And restart ambari-server

thx. It works.

avatar
Contributor

You could remove via delete statement in psql..

1) Removing table entries in hoststate : Delete from hoststate where host_id=xx

2) Removing table entries from hosts : Delete from hosts where host_id=xx

And restart ambari-server

avatar
Contributor

I restarted the ambari-agent services and was able to reregister we also have an option of ambari-agent reset hdp_server_name this was also required on other 2 hosts