Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

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
Visitor

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
Visitor

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
Visitor

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)