Usage Ratio going to Negative values

Neo4j Graph Platform
, ,
1

Hi, recently, i have seen that when one of my queries runs the usage ration goes to negative values.
the query i am running is like
CALL apoc.periodic.iterate("match (x1:ACCOUNT)-[rtn:TRANSFER]->(x22:ACCOUNT) where x1.TotB=true and x2.TotB=true RETURN x1,x2,
count(rtn.value) as numOpera, sum(rtn.Value) as Total, 10^3 as precision,max(rtn.Txt) as Recenttxt",
"MERGE (x1)-[trtn:TOTAL_transfer]->(x2)
set
trtn.numOpera=numOpera,
trtn.Total=round(precision*toFloat(Total))/precision,
trtn.BIZUM=apoc.date.parse(Recenttxt,'s','yyyy-MM-dd'),
trtn.BIZUMTxt=Recenttxt;",
{batchSize:20000,iterateList:true,parallel:false});

Can i know how this usage ratio could be handled!

2

@somdeb44

Neo4j Version?

usage ratio? do you have more details/specifics? Are you speaking of page cache hit usage ratio or some other ?

3

the version is 3.5.
Yes i am speaking about the Usage ratio of Page Cache section.

4

@somdeb44

oh...
Also given you are using Neo4j 3.5.x and given it is end of life any opportunity to upgrade to a more recent release, i.e. 4.4.x or even 5.x?

5

Ugh!!As of now, there is no plan for upgrading the version.

6

@somdeb44

the last release of 3.5.x was 3.5.33 Neo4j 3.5.35 - Graph Database & Analytics and released Aug 2022. So even if you are at 3.5.33, the software is now 16+ months old.

But also as you report

the version is 3.5.

its not clear is this 3.5.0? or 3.5.35? or ?

7

The version is 3.5.8.

8

@somdeb44

3.5.8 Neo4j 3.5.8 - Graph Database & Analytics was released on

Release Date: 19 July 2019

so some 3.5 years old

9

:pensive: Now for the issue which I raised this topic, is there any solution for the time being.
I feel the query is pretty simple. But yeah I have billions of data to process.
But I am not understanding why the usage ratio is going to negative only when this query runs.

10

@somdeb44

its a bug and which was fixed in 3.5.15 released Feb 2020.
But given your current 3.5.8 is some 3.5+ yrs old and if you really want this fixed and are to upgrade then it would be best to get on a more current release and or supported release.

Neo4j 3.5 changelog · neo4j/neo4j Wiki · GitHub contains a list of bugs fixed by patch release and to which given there are 27 patches post your current software version you might encounter other issues as well