Graph query unable to delete node

[somdeb44]

Hi all,

Today i noticed that my graph has some nodes which are propertyless. that means i can see the node is created but there is no property assigned to it.

I wanted to delete these garbage data. what filter i can use to delete them?

[glilienfield (Gary Lilienfield)]

Try this:

Match(n)
Where size(keys(n)) = 0
Detach delete n

Please test it first with this query to make sure it is returning the nodes you want to delete.

Match(n)
Where size(keys(n)) = 0
Return n

[somdeb44]

I tried using the query, though simply using return clause return me the expected data but when i try to delete the data i face the below error

while we use apoc procedure to delete them then we face

[glilienfield (Gary Lilienfield)]

This error is outside my wheelhouse. It looks like you may have a corrected database. You may want to try checking the consistency with the neo4j-admin tool.

Consistency checker - Operations Manual

Let me see if I can some help for you.