snomed-database-loader icon indicating copy to clipboard operation
snomed-database-loader copied to clipboard

NEO4J CYPHER EXECUTION failes

Open adhave opened this issue 2 years ago • 1 comments

CYPHER EXECUTION fails loading the INT release of 20210731; there are 7 DB failures. Any ideas on how to solve these?

step:[CYPHER_EXECUTION],result:[FAILED (STATUS 7)],command:[python /Users/arabella/Downloads/SNOMED-CT-Database-master/NEO4J//snomed_g_neo4j_tools.py run_cypher build.cypher --verbose --neopw SCT2107],status/expected:7/0,duration:0:02:47.579488,output:[],error:[],cmd_start:[2022-01-25 15:43:14.437101],cmd_end:[2022-01-25 15:46:02.016589]

  1. CREATE CONSTRAINT ON (c:ObjectConcept) ASSERT c.id IS UNIQUE; Sending CYPHER:[CREATE CONSTRAINT ON (c:ObjectConcept) ASSERT c.id IS UNIQUE;] *** DB failure: command 14 [CREATE CONSTRAINT ON (c:ObjectConcept) ASSERT c.id IS UNIQUE;] : [<class 'py2neo.errors.ClientError'>,[Schema.EquivalentSchemaRuleAlreadyExists] An equivalent constraint already exists, 'Constraint( id=4, name='constraint_db5f75eb', type='UNIQUENESS', schema=(:ObjectConcept {id}), ownedIndex=3 )'.] CYPHER execution time: 0:00:00.091368
  2. CREATE CONSTRAINT ON (c:ObjectConcept) ASSERT c.sctid IS UNIQUE; Sending CYPHER:[CREATE CONSTRAINT ON (c:ObjectConcept) ASSERT c.sctid IS UNIQUE;] *** DB failure: command 15 [CREATE CONSTRAINT ON (c:ObjectConcept) ASSERT c.sctid IS UNIQUE;] : [<class 'py2neo.errors.ClientError'>,[Schema.EquivalentSchemaRuleAlreadyExists] An equivalent constraint already exists, 'Constraint( id=6, name='constraint_49108c16', type='UNIQUENESS', schema=(:ObjectConcept {sctid}), ownedIndex=5 )'.] CYPHER execution time: 0:00:00.010839
  3. // id,sctid index created, requiring uniqueness
  4. // Note: Can't have "FSN is UNIQUE"" constraint, can have dups (inactive concepts)
  5. // for example -- "retired procedure" is FSN of multiple inactive concepts
  6. CREATE CONSTRAINT ON (c:Description) ASSERT c.id IS UNIQUE; Sending CYPHER:[CREATE CONSTRAINT ON (c:Description) ASSERT c.id IS UNIQUE;] *** DB failure: command 19 [CREATE CONSTRAINT ON (c:Description) ASSERT c.id IS UNIQUE;] : [<class 'py2neo.errors.ClientError'>,[Schema.EquivalentSchemaRuleAlreadyExists] An equivalent constraint already exists, 'Constraint( id=8, name='constraint_95d7434', type='UNIQUENESS', schema=(:Description {id}), ownedIndex=7 )'.] CYPHER execution time: 0:00:00.007043
  7. CREATE INDEX ON :Description(sctid); Sending CYPHER:[CREATE INDEX ON :Description(sctid);] *** DB failure: command 20 [CREATE INDEX ON :Description(sctid);] : [<class 'py2neo.errors.ClientError'>,[Schema.EquivalentSchemaRuleAlreadyExists] An equivalent index already exists, 'Index( id=9, name='index_382830f9', type='GENERAL BTREE', schema=(:Description {sctid}), indexProvider='native-btree-1.0' )'.] CYPHER execution time: 0:00:00.008324
  8. // need index so setting HAS_DESCRIPTION edges doesn't stall
  9. // there can be more than one description for the same sctid, sctid not unique, but id is unique
  10. // ROLE_GROUP nodes. Index needed for defining relationship assignment.
  11. CREATE INDEX ON :RoleGroup(sctid); Sending CYPHER:[CREATE INDEX ON :RoleGroup(sctid);] *** DB failure: command 25 [CREATE INDEX ON :RoleGroup(sctid);] : [<class 'py2neo.errors.ClientError'>,[Schema.EquivalentSchemaRuleAlreadyExists] An equivalent index already exists, 'Index( id=10, name='index_8156e621', type='GENERAL BTREE', schema=(:RoleGroup {sctid}), indexProvider='native-btree-1.0' )'.] CYPHER execution time: 0:00:00.006520

Sending CYPHER:[USING PERIODIC COMMIT 200 LOAD csv with headers from "file:///Users/arabella/empty/concept_new.csv" as line with line CREATE (:ObjectConcept { nodetype: 'concept', id: line.id, sctid: line.id, active: line.active, effectiveTime: line.effectiveTime, moduleId: line.moduleId, definitionStatusId: line.definitionStatusId, FSN: line.FSN, history: line.history} );] *** DB failure: command 42 [USING PERIODIC COMMIT 200 LOAD csv with headers from "file:///Users/arabella/empty/concept_new.csv" as line with line CREATE (:ObjectConcept { nodetype: 'concept', id: line.id, sctid: line.id, active: line.active, effectiveTime: line.effectiveTime, moduleId: line.moduleId, definitionStatusId: line.definitionStatusId, FSN: line.FSN, history: line.history} );] : [<class 'py2neo.errors.ClientError'>,[Schema.ConstraintValidationFailed] Node(108127) already exists with label ObjectConcept and property id = '100005'] CYPHER execution time: 0:00:00.054070

Sending CYPHER:[USING PERIODIC COMMIT 200 LOAD csv with headers from "file:///Users/arabella/empty/descrip_new.csv" as line with line CREATE (:Description { nodetype:'description', id: line.id, sctid: line.sctid, active: line.active, typeId: line.typeId, moduleId: line.moduleId, descriptionType: line.descriptionType, id128bit: line.id128bit, term: line.term, effectiveTime: line.effectiveTime, acceptabilityId: line.acceptabilityId, refsetId: line.refsetId, caseSignificanceId: line.caseSignificanceId, languageCode: line.languageCode, history: line.history} );] *** DB failure: command 64 [USING PERIODIC COMMIT 200 LOAD csv with headers from "file:///Users/arabella/empty/descrip_new.csv" as line with line CREATE (:Description { nodetype:'description', id: line.id, sctid: line.sctid, active: line.active, typeId: line.typeId, moduleId: line.moduleId, descriptionType: line.descriptionType, id128bit: line.id128bit, term: line.term, effectiveTime: line.effectiveTime, acceptabilityId: line.acceptabilityId, refsetId: line.refsetId, caseSignificanceId: line.caseSignificanceId, languageCode: line.languageCode, history: line.history} );] : [<class 'py2neo.errors.ClientError'>,[Schema.ConstraintValidationFailed] Node(594104) already exists with label Description and property id = '101013'] CYPHER execution time: 0:00:00.019955

adhave avatar Jan 26 '22 18:01 adhave