.size() function gives wrong value

[adriancoca]

OrientDB Version: 3.2.5

Java Version: 8

OS: Windows server 2019

Decided to upgrade orient from 3.0.29 to 3.2.5.
It seems that in new version the size() function give a wrong answer.

I don't know if it is a fail import with some corupted data, ai tried repair database but no problem found, also maybe libked with -> #9767

Expected behavior

Actual behavior

[tglman]

Hi,

This is probably due to a broken graph link, that means on the source record may be there a id of a record that do not exists any more, so when you traverse the relationship this get excluded, this is why you see the record id in the first query, but it result on 0 size when you traverse it.

Bye

[adriancoca]

One week ago i runned repair database and today i have again broken record.

Orient version 3.2.22

Is there a way to prevent or easy repair without database stopped ?

[tglman]

Hi,

yes for this kind of problems you could try to remove the link manually, here an example query for your case:

update #ID_I_DO_NOT_KNOW remove in_SUBORDER_OF = #26:46

the name of the field follow the convention in_relationship_name and out_relashionship_name

I''m not sure how you can produce this problem in the first place, I would say you do not have any delete .... unsafe and truncate record ... this two commands could produce this kind of errors.

Regards

[adriancoca]

Hi again,
It doesn't seem to remove that wrong item using what you said above also i am not using unsafe of truncate on that node.

LE: this works -> update #26:29 remove in_SUBORDER_OF