On 17. mai 2015 19:10, Alejandro Fernandez wrote:
> Hi Eirik, you can try deleting from the database directly.
> There will be several tables related to service configs.
>
> First stop ambari-server, take a database dump, then run
>
> DELETE FROM hostcomponentdesiredstate WHERE service_name = 'STORM';
> DELETE FROM hostcomponentstate WHERE service_name = 'STORM';
> DELETE FROM servicecomponentdesiredstate WHERE service_name = 'STORM';
> DELETE FROM servicedesiredstate WHERE service_name = 'STORM';
> DELETE FROM clusterservices WHERE service_name = 'STORM';
>
> DELETE FROM hostconfigmapping WHERE service_name = 'STORM';
> DELETE FROM hostgroup_configuration WHERE type_name IN ('storm-env',
> 'storm-site');
>
> DELETE FROM serviceconfigmapping WHERE config_id IN (select config_id FROM
> clusterconfig WHERE type_name IN ('storm-env', 'storm-site'));
> DELETE FROM serviceconfighosts WHERE service_config_id IN (select
> config_id FROM clusterconfig WHERE type_name IN ('storm-env',
> 'storm-site'));
> DELETE FROM serviceconfig WHERE service_name = 'STORM';
> DELETE FROM clusterconfigmapping where type_name IN ('storm-env',
> 'storm-site');
>
> DELETE FROM configgrouphostmapping WHERE config_group_id IN (SELECT
> group_id FROM configgroup WHERE tag = 'STORM' or service_name = 'STORM');
> DELETE FROM confgroupclusterconfigmapping WHERE config_group_id IN (SELECT
> group_id FROM configgroup WHERE tag = 'STORM' or service_name = 'STORM');
>
> DELETE FROM configgroup WHERE tag = 'STORM' or service_name = 'STORM';
> DELETE FROM clusterconfig WHERE type_name IN ('storm-env', 'storm-site');
>
>
> Thanks,
> Alejandro Fernandez
Thank you, the above worked. I only had to include deletes for the
alert_* tables as well.
For completeness, included here roughly from my notes (NOT TESTED FULLY)
DELETE FROM alert_current WHERE definition_id IN (SELECT definition_id
FROM alert_definition WHERE service_name = 'STORM');
DELETE FROM alert_history WHERE service_name = 'STORM';
DELETE FROM alert_grouping WHERE definition_id IN (SELECT definition_id
FROM alert_definition WHERE service_name = 'STORM');
DELETE FROM alert_group_target WHERE group_id IN (SELECT group_id FROM
alert_group WHERE service_name = 'STORM');
DELETE FROM alert_group WHERE service_name = 'STORM';
DELETE FROM alert_definition WHERE service_name = 'STORM';
Regards,
Eirik
--
Eirik Thorsnes
Group Leader at Parallab, Uni Research Computing
Høyteknologisenteret, Thormøhlensgate 55, N-5008 Bergen, Norway
tel: (+47) 555 84153 fax: (+47) 555 84295
