Ambari Config inconsistency issue

[#1]

Few weeks back we were working with a customer and configured Solr for Ranger, customer decided to skip Solr until it came as a GA feature with Ambari, after uninstalling and removing the Solr properties customer has upgraded Ambari and HDP stack, now the ambari-server logs are flooded with below error, a solution/fix would be helpful.

ERROR [qtp-ambari-client-2103] ClusterImpl:2145 - Config inconsistency exists: unknown configType=solr-env

Thanks

Mayank

[#2 · Accepted solution]

@mkataria

You may have to clear the datase manually.

su postgres

psql

\c ambari

DELETE FROM ambari.hostcomponentstate WHERE service_name IN ('SOLR');

DELETE FROM ambari.hostcomponentdesiredstate WHERE service_name IN ('SOLR');

DELETE FROM ambari.servicecomponentdesiredstate WHERE service_name IN ('SOLR');

DELETE FROM ambari.servicedesiredstate WHERE service_name IN ('SOLR');

DELETE FROM ambari.clusterservices WHERE service_name IN ('SOLR');

service ambari-server restart

[#3]

@Neeraj Sabharwal I deleted my service name from all these tables but I am still seeing the same issue in the logs. I see this name is present in lot of tables

clusterconfig

execution_command

upgrade_item

stage

serviceconfig

requestresourcefilter

requestoperationlevel

request

and there are many others. Should I delete from everywhere?