Unable to delete node with missing child

[Scott Mitchell]

I am trying to clean up some corrupted data. I have a node that is missing its child. I have tried to re-create the child, but it has a different uuid so it does not see it as the same. 

This is the exception I get when I try to delete the parent node:
 javax.jcr.ItemNotFoundException: 1efc103b-27c2-4947-831a-d3e1d3f45523

I have gone in to groovy console. I have moved the node to /trash, But I still cannot get it to remove from the system entirely.

I rebuilt the search indexes, and I saw this error in the log:
2019-12-11 16:33:09,594 ERROR che.jackrabbit.core.query.OnWorkspaceInconsistency: Node /trash/cha-544310953 (363d4639-b029-41f1-98e5-7d46b5ed7a8a) has missing child 'rss1822926571' (1efc103b-27c2-4947-831a-d3e1d3f45523)

How can I remove a node from JCR when its child is missing?

[Mikaël Geljić]

Hi Scott,

Apparently you might be able to fix this at persistence manager level, see this troubleshooting page in our wiki (a bit old, but should be doable with JCR 2.0 as well):

https://wiki.magnolia-cms.com/display/WIKI/JCR+Troubles+FAQs#JCRTroublesFAQs-GroovyScripttoremoveinvalidchildnodeentries

 

Cheers,

Mika