Unable to remove Vertices and Edges from SecureGraph

[mars76]

Hi All,

I have inserted few vertices and edges using SecureGraph API and when i tried to delete these by using the Id and the following method is returning true. How ever when i query the graph with the same Id i am getting the data back !!.

Graph graph = createGraph();
if(elementTye==Edge){
graph.removeEdge(element.getId(), authorizations);
}
else{
org.securegraph.Vertex sgVertex = getSecureGraphVertex(uuid, authorizations);
graph.removeVertex(sgVertex, authorizations);
}
// This is redundant . still i am calling
graph.flush();

// I have set the auto flush to true in my props file
mapConfig.put(AccumuloGraphConfiguration.AUTO_FLUSH, true);

which is used in my createGraph() method

When i go to admin screen for checking the table status i don't see the no.of entries changing in _v and _e tables.

Not sure what i am doing wrong. I am not getting any exceptions..

Thanks

[mars76]

I am able to delete all the elements when i use clearGraph().
How ever this is not i want when i want to delete a specific element by Id.

[srgudi]

Hi mars76,

I tried to reproduce your issue with secure graph API, I was not able to.
You mention that you are trying to verify the deleted counts from Accumulo Admin/Console UI.
You will not be able to verify on Admin/Console UI as Accumulo marks for deletion and during next compaction, the actual row data will be removed.

If you are having issues from the API itself please send your test case.
If you don't have one, currently I see similar tests cases in Secure graph.

1. AccumuloGraphTest.testRemoveVertex(): This method is there in the base class, GraphTestBase
2. AccumuloGraphTest.testRemoveEdge(): This method is there in the base class, GraphTestBase
   Both of them run fine indicating deletion works.

However both of them focus on removing the vertex and edges respectively not vertexes having edges.
If you are having problems in removing vertexes with edges, you can try to remove the vertex in 2nd test case and verify the results from API as below (at the end of current tests):
AccumuloGraphTest.testRemoveEdge(){
.....
...
graph.removeVertex(v1, AUTHORIZATIONS_A);
v1 = graph.getVertex("v1", AUTHORIZATIONS_A);
assertNull(v1);
}

Please let me know if this helps in resolving this issue.

Thanks
Shrinivas