1. Messages
  2. Unique composite index with label constraint - issue?

Unique composite index with label constraint - issue?

Ivan Cikic <ivan...@...>
 

So, evaluating JanusGraph for a project, I ran into this: unique index on a Vertex property with a specific VertexLabel constraint doesn't seem to be respected across transactions? Or I'm just doing something wrong? Code snippet below should reproduce the issue.

plugin activated: janusgraph.imports
plugin activated: tinkerpop.server
plugin activated: tinkerpop.utilities
plugin activated: tinkerpop.hadoop
plugin activated: tinkerpop.spark
plugin activated: tinkerpop.tinkergraph

gremlin> graph = JanusGraphFactory.build().set('storage.backend','hbase').set('storage.hbase.table','janusgraph').open()
==>standardjanusgraph[hbase:[127.0.0.1]]
gremlin> m=graph.openManagement()
==>org.janusgraph.graphdb.database.management.ManagementSystem@541179e7
gremlin> vl=m.makeVertexLabel('system').partition().make()
==>system
gremlin> pk=m.makePropertyKey('system_id').dataType(String.class).make()
==>system_id
gremlin> i=m.buildIndex('idx_system_id', Vertex.class).addKey(pk).indexOnly(vl).unique().buildCompositeIndex()
==>idx_system_id
gremlin> m.commit()
==>null
gremlin> g=graph.traversal()
==>graphtraversalsource[standardjanusgraph[hbase:[127.0.0.1]], standard]
gremlin> g.addV('system').property('system_id','A')  
==>v[4226]                                                              <-- add Vertex: OK
gremlin> g.tx().commit()
==>null
gremlin> g.addV('system').property('system_id','A')
==>v[8202]                                                              <-- add Vertex with same property value: OK
gremlin> g.addV('system').property('system_id','A')                     <-- add Vertex with same property value same TX: FAIL
Adding this property for key [system_id] and value [A] violates a uniqueness constraint [idx_system_id]

Compared to this behaviour when using unique index without a VertexLabel constraint:


gremlin> graph = JanusGraphFactory.build().set('storage.backend','hbase').set('storage.hbase.table','janusgraph2').open()
==>standardjanusgraph[hbase:[127.0.0.1]]
gremlin> m=graph.openManagement()
==>org.janusgraph.graphdb.database.management.ManagementSystem@27443560
gremlin> vl=m.makeVertexLabel('system').partition().make()
==>system
gremlin> pk=m.makePropertyKey('system_id').dataType(String.class).make()
==>system_id
gremlin> i=m.buildIndex('idx_system_id', Vertex.class).addKey(pk).unique().buildCompositeIndex()  <-- no indexOnly
==>idx_system_id
gremlin> m.commit()
==>null
gremlin> g=graph.traversal()
==>graphtraversalsource[standardjanusgraph[hbase:[127.0.0.1]], standard]
gremlin> g.addV('system').property('system_id','A')
==>v[4226]
gremlin> g.addV('system').property('system_id','A')         <-- add Vertex with same property value same TX: FAIL
Adding this property for key [system_id] and value [A] violates a uniqueness constraint [idx_system_id]
gremlin> g.tx().commit()
==>null
gremlin> g.addV('system').property('system_id','A')         <-- add Vertex with same property value new TX: FAIL
Adding this property for key [system_id] and value [A] violates a uniqueness constraint [idx_system_id]

Thanks,
Ivan
Join {janusgraph-users@lists.lfaidata.foundation to automatically receive all group messages.