Deleting nodes taking a lot of time and crashing server

[shubham]

Hello guys,
i want to delete the complete database and there are ~3,00,000 nodes and ~82,00,000 relationship and i tried all basic steps to delete them and most of the time query crashes the server and we have to restart it again and when i set the limit very small , in some case it doesn't take time and in some cases it keeps on running.
any suggestion?

[Cobra]

Hello @shubham

CALL apoc.periodic.iterate('MATCH (n) RETURN n', 'DETACH DELETE n', {batchSize:1000})

Regards,
Cobra

[shubham]

getting this error -
"Cannot truncate a negative index. Tried to truncate from 8870"

[Cobra]

Do you have index or constraints?

[shubham]

Dropped all of them. Now, there is none.

[Cobra]

Can you execute again the cypher query I gave you?

[shubham]

tried, getting same error.

[pavankumar_prat]

Try this query

match(n:org_name) detach delete n;

[12kunal34]

If you are using local then go to folder of your data and delete the database which you want to delete .
folder location should be /neo4j--data--dbms
Note: If you want to delete whole data in your database

[Cobra]

Which version of Neo4j are you using?
Could you reinstall a new database with the latest version available?