Analytics (On premise - 4.16.09): Unable to delete the datastores and qpid-server from analytics

[#1]

I am unable to delete the datastores from the analytics servers. Curl command is sending 200 response but nothing removed from the group.

Curl command:

curl -v -u {sysadmin}:{pwd} -X DELETE -H 'Accept:application/json' -H 'Content-Type:application/json' 'http://{MS}:{port}/v1/analytics/groups/ax/axgroup003/consumer-groups/consumer-group-new/datastores/79c8e7b0-215d-4784-b399-97ffedf25188'

Response:

* About to connect() to {MS} port 8080 (#0)

* Trying {MS}... connected

* Connected to {MS} port 8080 (#0)

* Server auth using Basic with user '{MS}'

> DELETE /v1/analytics/groups/ax/axgroup003/consumer-groups/consumer-group-new/datastores/79c8e7b0-215d-4784-b399-97ffedf25188 HTTP/1.1

> Authorization: Basic b3BzYXBpZ2VlYWRtaW5AYm9vdHMuY28udWs6MW5jQHJyZWNU

> User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.15.3 zlib/1.2.3 libidn/1.18 libssh2/1.4.2

> Host: {MS}:8080

> Accept:application/json

> Content-Type:application/json

>

< HTTP/1.1 200 OK < Content-Type: application/json

< Date: Fri, 16 Dec 2016 15:12:40 GMT < Content-Length: 514

<

{

"name" : "axgroup003",

"properties" : {

"region" : "dc-1",

"consumer-type" : "ax"

},

"scopes" : [ ],

"uuids" : {

"qpid-server" : [ ],

"postgres-server" : [ "67c75894-6549-4dde-9892-0d48c907083c:79c8e7b0-215d-4784-b399-97ffedf25188" ]

},

"consumer-groups" : [ {

"name" : "consumer-group-new",

"consumers" : [ ],

"datastores" : [ "67c75894-6549-4dde-9892-0d48c907083c:79c8e7b0-215d-4784-b399-97ffedf25188" ],

"properties" : { }

} ],

"data-processors" : {

}

* Connection #0 to host 10.141.136.1 left intact

* Closing connection #0

Kindly suggest a way to get rid of this unwanted analytics group from Zookeper records

[gaurav_bhandari · Accepted solution]

Hi @Gagandeep Singh,

I think you need to remove the UUID from the ZOOKEEPER database manually. Please get in touch with APIGEE Suport team and they will assist you in this. I hope you have access to APIGEE support porta, where you can raise APIGEE case.

We had face similar issue ie we had extra entry for DATA CENTER in the zookeeper, and then we had to delete it manually.

[#3]

Thanks @gbhandari. This is what I was thinking. Yes we have access to support portal to raise a case.

[anilsr]

@Gagandeep Singh , Use comments for discussion, Answers are strictly for answers. Thank you.

[#5]

Hi @gbhandari,

We are facing the same scenario. Is it possible to share the steps to remove them from ZK?

[#6]

Just found a way, posted as an answer.

[#7]

I went into the same issue.
Steps to fix this:

1) Find uuid references in zk-tree using:

$ /opt/apigee/apigee-zookeeper/contrib/zk-tree.sh >> tmp/zk.out

$ cat /tmp/zk.out | grep UUID

2) Remove references in ZK:

$ /opt/apigee/apigee-zookeeper/bin/zkCli.sh

$ rmr /servers/UUID

If required or any other entry

$ rmr /analytics/groups/ax/AX_GROUP