cancel
Showing results for 
Search instead for 
Did you mean: 

Error when get simple graph (Index traversal aborted)

leminhvn
Node Clone

I got a very simple Cypher query as bellowing. However, it return error of Index traversal.

> match (u:USER)
> where u.USER_ID in [100014822224680,100007051087899]
> return (u)-[:friend]->(u)

Neo.DatabaseError.Statement.ExecutionFailed

Index traversal aborted due to being stuck in infinite loop. This is most likely caused by an inconsistency in the index. Loop occurred when restarting search from root from page 24290. | GB+Tree[file:/data/databases/graph.db/neostore.relationshipgroupstore.degrees.db, layout:CountsLayout[version:0.1, identifier:4859186502451594203, fixedSize:true], generation:467/471]

Please help to explain the problem and how to fix it.

2 REPLIES 2

bennu_neo
Neo4j
Neo4j

Hi @leminhvn !

What indexes do you have on your DB? I guess you have an index on *USER_ID *. Have you try dropping it and recreating it back again?

Bennu

Oh, y’all wanted a twist, ey?

leminhvn
Node Clone

I had done that: drop and recreate the index. Unluckily it does not work.
I try to delete neostore.relationshipgroupstore.degrees.db and startup database.
It takes long time to start in order to rebuild the files. Now the error is gone. But I still have to double check.

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.