When loading data into DSE graph, an error relating to a Vertex label id clash may be observed. The vertex id clash might prevent loading all or some of the data.
DSE5.0.7, DSE5.1.0 and earlier
The user may see the following error in gremlin console:
gremlin> schema.vertexLabel("Label1").partitionKey("_id").ifNotExists().create() Vertex label ID clash Type ':help' or ':h' for help. Display stack trace? [yN]y org.apache.tinkerpop.gremlin.groovy.plugin.RemoteException: Vertex label ID clash
The problem was caused by corruption of the
<graph_name>.id_allocation table. In one instance it was observed that the
id_allocation table was empty:
cqlsh> select * from mygraph.id_allocation; partition_hash | dc_id | member_id ----------------+-------+----------- (0 rows)
It may not always be the case that this table is empty, other possible scenarios may exist
The following information will be valuable to determine if it is possible to correct the table manually. Do not attempt to correct yourself. As each case is different contact Datastax support with the following information.
1. Gather the output of
graph.schemaModel() from gremlin console
2. Gather the output of
select * from mygraph.id_allocation; from cqlsh where
mygraph is the name of your graph.
Internal jira DSP-12826 contains a check to make sure that a schema element’s id is not already in use before allocating it. Therefore it is recommended upgrade to DSE 5.0.8, DSE 5.1.1 or later.