I am using neo4j version 5.16.0 . When i try to delete a relationship between two node i am unable to delete it and receive this particular error: "Unable to complete transaction".
If we check the relationship for it. We see relationship in the graph but still it returns 0 relationship. This was the output: “Displaying 2 nodes, 0 relationships“
Query we used:
MATCH ()-[r]-()
WHERE id(r) = 16877806
RETURN id(r), elementId(r), type(r), startNode(r), endNode(r)
After this we ran consistency check on database. In which we found errors.
2025-09-28 01:45:42.602+0000 ERROR The target node does not have a relationship chain.Relationship[654988027,used=true,source=234353338,target=181110530,type=23,sPrev=654988028,sNext=654977381,tPrev=656996635,tNext=654189766,prop=-1,!sFirst,!tFirst]Inconsistent with: Node[181110530,used=true,created=false,rel=-1,prop=1518632281,labels=Inline(0x100000000f:[15]),light,fixedRefs=false]
2025-09-28 01:46:42.769+0000 ERROR This record should be the first in the target chain, but the target node does not reference this record.
Relationship[1444437299,used=true,source=115575791,target=181138789,type=23,sPrev=1444437300,sNext=398883520,tCount=365,tNext=1439761244,prop=-1,!sFirst, tFirst]
Inconsistent with: Node[181138789,used=true,created=false,rel=549406285,prop=1518780256,labels=Inline(0x2000f8000f:[15, 62]),light,fixedRefs=false]
Final result:
2025-09-29 13:41:56.683+0000 WARN Inconsistencies found: ConsistencySummaryStatistics {
Number of errors: 778
Number of warnings: 0
Number of inconsistent COUNTS records: 4
Number of inconsistent RELATIONSHIP records: 774
Is this issue related to inconsistency in data?? If yes, how can we resolve this issue.