[ATLAS-3804] violates a uniqueness constraint [Referenceable.__u_qualifiedName__typeName]

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: hive-integration
• Environment: cdh5.14.4 , atlas1.2.0 ,elasticsearch5.6.4,kafka2.1.1
• Assignee: Unassigned
• Reporter: kevin
• Created: 21/May/20 03:57
• Updated: 25/May/20 01:39
• Resolved: 25/May/20 01:38

Description

{{create table t2 as select id, name from T1;  }}
 
If the T1 table is not used for 1 hours and the above statement is executed, Atlas will have a unique constraint exception.
Immediately change table t2 to T3 for execution, Atlas normal parsing record

org.apache.atlas.repository.graphdb.AtlasSchemaViolationException: org.janusgraph.core.SchemaViolationException: Adding this property for key [Referenceable.__u_qualifiedName] and value [graph.t1.name@primary] violates a uniqueness constraint [Referenceable.__u_qualifiedName__typeName]
at org.apache.atlas.repository.graphdb.janus.AtlasJanusElement.setProperty(AtlasJanusElement.java:114)
at org.apache.atlas.repository.store.graph.v2.AtlasGraphUtilsV2.setProperty(AtlasGraphUtilsV2.java:227)
at org.apache.atlas.repository.store.graph.v2.AtlasGraphUtilsV2.setEncodedProperty(AtlasGraphUtilsV2.java:195)
at org.apache.atlas.repository.store.graph.v2.EntityGraphMapper.mapPrimitiveValue(EntityGraphMapper.java:751)
at org.apache.atlas.repository.store.graph.v2.EntityGraphMapper.mapToVertexByTypeCategory(EntityGraphMapper.java:435)
at org.apache.atlas.repository.store.graph.v2.EntityGraphMapper.mapAttribute(EntityGraphMapper.java:424)
at org.apache.atlas.repository.store.graph.v2.EntityGraphMapper.mapAttributes(EntityGraphMapper.java:336)
at org.apache.atlas.repository.store.graph.v2.EntityGraphMapper.mapAttributesAndClassifications(EntityGraphMapper.java:229)
at org.apache.atlas.repository.store.graph.v2.AtlasEntityStoreV2.createOrUpdate(AtlasEntityStoreV2.java:856)
at org.apache.atlas.repository.store.graph.v2.AtlasEntityStoreV2.createOrUpdate(AtlasEntityStoreV2.java:275)
at org.apache.atlas.repository.store.graph.v2.AtlasEntityStoreV2$$FastClassBySpringCGLIB$$6861dca9.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.apache.atlas.GraphTransactionInterceptor.invoke(GraphTransactionInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:671)
at org.apache.atlas.repository.store.graph.v2.AtlasEntityStoreV2$$EnhancerBySpringCGLIB$$e49957d9.createOrUpdate(<generated>)
at org.apache.atlas.notification.NotificationHookConsumer$HookConsumer.createOrUpdate(NotificationHookConsumer.java:701)
at org.apache.atlas.notification.NotificationHookConsumer$HookConsumer.handleMessage(NotificationHookConsumer.java:582)
at org.apache.atlas.notification.NotificationHookConsumer$HookConsumer.doWork(NotificationHookConsumer.java:437)
at kafka.utils.ShutdownableThread.run(ShutdownableThread.scala:64)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.janusgraph.core.SchemaViolationException: Adding this property for key [Referenceable.__u_qualifiedName] and value [graph.t1.name@primary] violates a uniqueness constraint [Referenceable.__u_qualifiedName__typeName]
at org.janusgraph.graphdb.transaction.StandardJanusGraphTx.addProperty(StandardJanusGraphTx.java:817)
at org.janusgraph.graphdb.transaction.StandardJanusGraphTx.addProperty(StandardJanusGraphTx.java:745)
at org.janusgraph.graphdb.vertices.AbstractVertex.property(AbstractVertex.java:152)
at org.janusgraph.core.JanusGraphVertex.property(JanusGraphVertex.java:72)
at org.janusgraph.core.JanusGraphVertex.property(JanusGraphVertex.java:33)
at org.apache.atlas.repository.graphdb.janus.AtlasJanusElement.setProperty(AtlasJanusElement.java:112)

{{}}