When I dropping Dynamic Graph will be hang up, what can I do to dropped it

[MiracleDx]

I have some Dynamic Graph about es and hbase from ConfiguredGraphFactory.When I dropping those, I used ConfiguradGraphFactory.drop('graphName'),but it will be hang up until timtout to failed or I used m.forceCloseInstance('${instanceId}') to killed instances, the graph will be dropped.

And when I dropped, will be rolling 'graph' table not existed in console.

How to dopped graph safely.

[CosmoBean]

I have faced similar issues as well, Since I was using configurationManagementGraph, and CQL-ES config, I deleted the keyspace for the graphname in cql and also the indexed i had created in ES, followed by deleting the mapping from the configuration graph :)

It's not at all clean by any means, if anyone else has a better solution, please let me know

[FlorianHockmann]

it will be hang up until timtout to failed or I used m.forceCloseInstance('${instanceId}') to killed instances

It's unfortunately a known problem that you can sometimes get instances which aren't active any more but JanusGraph doesn't know that they are inactive and will therefore wait for them indefinitely to participate in management operations.

So, if you want to be sure that ConfiguradGraphFactory.drop('graphName') will succeed, then the safest approach is probably to first force close all other instances.

We should also definitely describe that more clearly in our docs. #3974 tracks that.

@CosmoBean: Did you also try ConfiguradGraphFactory.drop('graphName') and it didn't work or why did you execute these steps manually? ConfiguradGraphFactory.drop('graphName') should usually perform these steps for you.

[CosmoBean]

Yes, The drop didn't work and i proceeded to do the manual steps, the drop timed out

[panda0120]

I have the same problem, how to fix it?

[panda0120]

You need to execute this before dropping the graph to ensure that there is no instance open. After deleting the graph, the Janusgraph log will always refresh table not found. You need to recreate the graph.在删除图表之前，您需要执行此操作以确保没有实例处于打开状态。删除图表后，Janusgraph日志将始终刷新“未找到表”信息。您需要重新创建图表。

m = ${graph}.openManagement();
ids = m.getOpenInstances();
for(String id : ids){if(!id.contains("(")){m.forceCloseInstance(id)}};
m.commit();

or

m = ${graph}.openManagement();
arr = m.getOpenInstances();for(i = 0; i < arr.size();i++){ if(!arr[i].contains("current")){ m.forceCloseInstance(arr[i]) } }
m.commit()

Thank you very much!!!

[panda0120]

@MiracleDx but I don't want to create table again,how to stop the error log?

[MiracleDx]

@MiracleDx but I don't want to create table again,how to stop the error log?

You can try restarting your janusgraph instance

[panda0120]

@MiracleDx this is my solution:

 public void dropGraph(String graphName) {
        Map<String, Object> params = new HashMap<>();
        params.put("graphName", graphName);
        this.getClient()
                .submit("m = " + graphName + ".openManagement();"
                        + "ids = m.getOpenInstances();"
                        + "for(String id : ids){if(!id.contains(\"(\")){m.forceCloseInstance(id)}};"
                        + "m.commit();"
                        + "ConfiguredGraphFactory.drop(graphName);"
                        + "ConfiguredGraphFactory.create(graphName);"
                        + "ConfiguredGraphFactory.drop(graphName);", params);
    }

[panda0120]

@MiracleDx This method doesn't seem to work every time.