Apoc.merge.relationship - permitted range [0,65535]

Neo4j Graph Platform Procedures & APOC
1

Test system :
Neo4j community server 4.3.6 on CentOS7 - browser

In test system

call db.relationshipTypes() yield relationshipType return count(relationshipType) as numRelTypes;
image

Run the script as below :
( inland_route.csv file's rows are under 500 rows)

:param relType => ("INLAND_GOES_TO");

load csv with headers from "file:///Inland_Route.csv" as row
match ((orgYard:Yard {ydCd: row.LNK_ORG_NOD_CD}))
match ((dstYard:Yard {ydCd: row.LNK_DEST_NOD_CD}))
call apoc.merge.relationship(orgYard,
$relType ,
{
routOrgNodCd: row.ROUT_ORG_NOD_CD,
routDestNodCd: row.ROUT_DEST_NOD_CD,
routSeq: row.ROUT_SEQ,
routDtlSeq: row.ROUT_DTL_SEQ
},
{
lnkOrgNodCd: row.LNK_ORG_NOD_CD,
lnkDestNodCd: row.LNK_DEST_NOD_CD,
prioSeq: row.PRIO_SEQ,
pctlIoBndCd: row.PCTL_IO_BND_CD,
trspModCd: row.TRSP_MOD_CD,
vndrSeq: row.VNDR_SEQ,
vndrNm: row.VNDR_NM
},
dstYard
) yield rel
return rel
;

An error occurred as below

image
image1381×135 16.6 KB

I know the error is caused as a result of hitting the maximum number of relationship types for db.
However It looks like the 65536 limit has not been reached from the query.

2

@haidkang

This is weird, with the same $relType this should not happen.
Please, can you provide the .csv used in order to replicate the issue, and your apoc version (executing RETURN apoc.version())?

3

I think my system is weird.

call db.relationshipTypes() yield relationshipType return count(relationshipType) as numRelTypes;
image

However,
create (p:Person {name : 'haid'});
create (h:Home {name : 'myhome'});

CREATE (a)-[:OWN]->(h)

image
image1210×103 7.58 KB

4

@haidkang

It looks like after reaching the max relationship type number,
even after deleting some types, the error remains (I think because the internal relationship type id increment for each creation, it doesn't matter if some have been deleted).
I don't know how this happened, however I would suggest you to create a new database and import there what you need.

5

Thanks for the kind information.