DynamicRecord not in use

[bob_yin]

Hi

I hit a problem that we think one of our user table data/node which is broken, we can not query it or all of user data(it will stuck and the CPU up to 100%), and can not delete it even we know its uuid.

MATCH (n:Neo4jEmployee {uuid:'95536edb-013d-4066-b145-b4ac2b1c87bb'}) DETACH DELETE n

Neo.DatabaseError.General.UnknownError

DynamicRecord[55704,used=false,(0),type=-1,data=byte,start=true,next=-1] not in use

Could you please advise? Thanks a lot~

[bob_yin · Accepted solution]

Have fixed the issue by https://github.com/jexp/store-utils, thanks!

[asad1996172]

I have a similar problem but it occurs while running the neo4j data import tool.
Following is the exception:
org.neo4j.kernel.impl.store.InvalidRecordException: DynamicRecord[179470203,used=false,(0),type=-1,data=byte[],start=true,next=-1] not in use

Can you guide me on how to use store-utils to clean up csv files?
Full stacktrace:

[bob_yin]

Think the store-utils can only fix the data from neo4j DB not the csv import.

Is there any duplicate records? Neo4j-admin import fails on specific ID duplicates · Issue #12800 · neo4j/neo4j · GitHub

[asad1996172]

Thanks for pointing this out. There were no duplicate records in the db however I was using Neo4J 4.4.2 which had a bug where it repeated IDs. Its fixed in 4.4.3

Neo4j Graph Data Platform

Neo4j 4.4.3

Neo4j 4.4.3 is a maintenance release with many important improvements and fixes. Highlights Update Log4j to 2.17 to address CVE-2021-45105 Update Log4j to 2.17.1 to address CVE-2021-44832 Fixes an issue in importer where large node IDs from CSV...