issue with cypher neo4j

[nickdevrekerdelta]

hello

as mentioned in an issue of 2022/23, i have here the same problem
can anybody help?

thx

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]

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
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
// id,sctid index created, requiring uniqueness
// Note: Can't have "FSN is UNIQUE"" constraint, can have dups (inactive concepts)
// for example -- "retired procedure" is FSN of multiple inactive concepts
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
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
// need index so setting HAS_DESCRIPTION edges doesn't stall
// there can be more than one description for the same sctid, sctid not unique, but id is unique
// ROLE_GROUP nodes. Index needed for defining relationship assignment.
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

[kaicode]

What version of Python, py2neo and Java are you using? What memory parameters are you using?