Delete Unexpected 127.0.0.1 from Cloudera Manager

I have cloudera manager 5.0.0 installed in my small cluster, tried to delete some nodes and then found cloudera manager not working, exceptions thrown in the landing page and 500 in the hosts page, almost null pointer exception everywhere.
Next time when I restart cm and log into CM, agent upgrading guide begins again. Here I found the 127.0.0.1 appeared in the host list which is not delete-able.
So I try to delete data from PostgreSQL.

1 read database config

password can be found from Cloudera Manager Drop Database/User on Embedded Postgresql

2 check table

3 find data

The row host_id=13 has an empty cluster id, no ip address nor name filled.

4 delete data

Try to find out deletes on foreign keys.

So Delete like

5 restart

Delete Unexpected 127.0.0.1 from Cloudera Manager by @sskaje: https://sskaje.me/2014/04/delete-unexpected-127-0-0-1-cloudera-manager/

Incoming search terms: