ambari-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alejandro Fernandez <afernan...@hortonworks.com>
Subject Re: Ambari 2.0, stack: HDP-2.2.4: Unable to remove STORM service/components by using API
Date Sun, 17 May 2015 17:10:11 GMT
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

On 5/17/15, 8:09 AM, "Eirik Thorsnes" <eirik.thorsnes@uni.no> wrote:

>Hi,
>
>I turned on postgresql logging and tried to delete entire service, it
>fails and rolls back, see below.
>
>Thanks,
>Eirik
>
>===========
>
>date; curl -i -u admin:admin -X  DELETE -H 'X-Requested-By: ambari'
>http://localhost:8080/api/v1/clusters/helm/services/STORM
>Sun May 17 17:02:29 CEST 2015
>HTTP/1.1 500 Transaction rolled back because transaction was set to
>RollbackOnly.
>Set-Cookie: AMBARISESSIONID=1a9unoldhj0p7a3rj3jik6cm;Path=/
>Content-Type: text/plain;charset=ISO-8859-1
>Content-Length: 104
>Server: Jetty(7.6.7.v20120910)
>
>{
>   "status": 500,
>   "message": "Transaction rolled back because transaction was set to
>RollbackOnly."
>
>===============
>
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1350> LOG:  execute
><unnamed>: SELECT user_id, active, create_time, ldap_user, user_name,
>user_password, principal_id FROM users WHERE ((LOWER(user_name) = $1)
>AND (ldap_user = $2))
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1350> DETAIL:  parameters:
>$1 = 'admin', $2 = '0'
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1351> LOG:  execute
><unnamed>: SELECT member_id, group_id, user_id FROM members WHERE
>(user_id = $1)
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1351> DETAIL:  parameters:
>$1 = '1'
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1352> LOG:  execute
><unnamed>: SELECT privilege_id, permission_id, principal_id, resource_id
>FROM adminprivilege WHERE (principal_id IN ($1))
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1352> DETAIL:  parameters:
>$1 = '4'
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1353> LOG:  execute
><unnamed>: BEGIN
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1353> LOG:  execute
><unnamed>: DELETE FROM servicedesiredstate WHERE ((cluster_id = $1) AND
>(service_name = $2))
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1353> DETAIL:  parameters:
>$1 = '2', $2 = 'STORM'
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1353> LOG:  execute
><unnamed>: DELETE FROM clusterservices WHERE ((cluster_id = $1) AND
>(service_name = $2))
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1353> DETAIL:  parameters:
>$1 = '2', $2 = 'STORM'
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1353> ERROR:  update or
>delete on table "clusterservices" violates foreign key constraint
>"srvccmponentdesiredstatesrvcnm" on table "servicecomponentdesiredstate"
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1353> DETAIL:  Key
>(service_name,cluster_id)=(STORM,2) is still referenced from table
>"servicecomponentdesiredstate".
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/1353> STATEMENT:  DELETE
>FROM clusterservices WHERE ((cluster_id = $1) AND (service_name = $2))
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/0> ERROR:  current
>transaction is aborted, commands ignored until end of transaction block
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/0> STATEMENT:  SELECT 1
><2015-05-17 17:02:29 CEST - 5558ac05.14a6-1/0> LOG:  execute S_2: ROLLBACK
>


Mime
View raw message