Support Questions

Find answers, ask questions, and share your expertise

A server error has occurred. (java.lang.NullPointerException at LocalCache.java line 2263)

avatar

The below error appears after logging in the cloudera manager.

Following a restart of the cloudera manager service the error remains.

Has anyone got any helpful intel?

 

1 ACCEPTED SOLUTION

avatar

Resolved.

 

It was a buggy entry in the HOSTS table.

 

Just execute:

 

select *
from HOSTS
where ip_address is null or name is null;

Grab the host_id and update the record just in case removing it does any bad juju.

 

update HOSTS set name = 'ignoreme', ip_address = '0.0.0.0' where host_id = your_host_id_here;

View solution in original post

4 REPLIES 4

avatar

Resolved.

 

It was a buggy entry in the HOSTS table.

 

Just execute:

 

select *
from HOSTS
where ip_address is null or name is null;

Grab the host_id and update the record just in case removing it does any bad juju.

 

update HOSTS set name = 'ignoreme', ip_address = '0.0.0.0' where host_id = your_host_id_here;

avatar
New Contributor

Hello!

 

I'm relatively new to the Hadoop ecosystem. Can you tell me from where I would go about querying against the hosts table you mention? Is it a Zookeeper thing? Hive? Any advice or direction towards documentation is greatly appreciated. Thanks!

avatar
New Contributor

Found it myself, but in case someone else has the same question I did:

 

On a default CDH install, check /var/lib/cloudera-scm-server-db/data/generated-password.txt for the DB password. Then:

 

psql -h 127.0.0.1 -p 7432 -U cloudera-scm -W scm

 

HTH!

avatar
New Contributor

I am seeing an empty set of hosts

 

psql (8.4.20)
Type "help" for help.

scm=# select *
scm-# from HOSTS
scm-# where ip_address is null or name is null;
host_id | optimistic_lock_version | host_identifier | name | ip_address | rack_id | status | config_container_id | mainten
ance_count | decommission_count | cluster_id | num_cores | total_phys_mem_bytes | public_name | public_ip_address | cloud_p
rovider
---------+-------------------------+-----------------+------+------------+---------+--------+---------------------+--------
-----------+--------------------+------------+-----------+----------------------+-------------+-------------------+--------
--------
(0 rows)