ambari-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eirik Thorsnes <eirik.thors...@uni.no>
Subject Re: Ambari 2.0, stack: HDP-2.2.4: Unable to remove STORM service/components by using API
Date Sun, 17 May 2015 15:09:55 GMT
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