Please HELP : 500 status code received on POST method for API: /api/v1/clusters/Analytics_Hadoop/request

Question

Hello

I get this error when restarting components :

500 status code received on POST method for API: /api/v1/clusters/Analytics_Hadoop/requests

I deleted oozie service

I am using postegres database

Thank you in advance

Shelton · Accepted Answer

@asmarz The error is below in bold I /usr/bin/hdp-select set oozie-client 3.1.4.0-315' returned 1. symlink target /usr/hdp/current/oozie-client for oozie already exists and it is not a symlink. Possible cause the symlink is broken or exists and is pointing to different location or version  so removing symlink and reinstalling the client should resolve the issueValidate Can you validate that the link exists? Move the symlinkmv /usr/hdp/current/oozie-client /usr/hdp/current/oozie-client_back Recreate the symlinkln -s  /usr/hdp/3.1.0.0-78/oozie /usr/hdp/current/oozie-client My version above is 2.1.0.0.x this should match your exact version

Shelton · Answer

@asmarz

When you delete components at times you leave the database in an inconsistent status. you will need to log onto the Ambari Database to do some manual cleaning.

There are 3 important tables that hold the component status

hostcomponentstate
hostcomponentdesiredstate
servicecomponentdesiredstate

A targeted select on the component name to show , run the below to check if your oozie components are still

[root@nakuru ~]# psql ambari ambari
Password for user ambari: #default password is "bigdata"
psql (8.4.20)
Type
"help" for help.
ambari=> select distinct component_name from hostcomponentstate;

If you see the oozie components in the databases then you will have to delete those entries, I have used 'OOZIE_SERVER','OOZIE_CLIENT' in the below example

Delete the orphaned Oozie entries

[root@nakuru ~]# psql ambari ambari
Password for user ambari: #default password is "bigdata"
psql (8.4.20)
Type
"help" for help.
ambari=> delete from hostcomponentstate where component_name='OOZIE_CLIENT';
DELETE 1
ambari=> delete from hostcomponentstate where component_name='OOZIE_SERVER';
DELETE 1
ambari=> delete from hostcomponentdesiredstate where component_name='OOZIE_CLIENT';
DELETE 1
ambari=> delete from hostcomponentdesiredstate where component_name='OOZIE_SERVER';
DELETE 1
ambari=> delete from servicecomponentdesiredstate where component_name='OOZIE_CLIENT';
DELETE 1
ambari=> delete from servicecomponentdesiredstate where component_name='OOZIE_SERVER';
DELETE 1
ambari=> commit;
WARNING: there is no transaction in progress
COMMIT
ambari=> \q
[root@nakuru ~]#

You can then stop all the components in the cluster and restart the database, you might need to restart some stale configurations that might have been orphaned due to the removal of the oozie components

HTH

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.