Automation : why do I got zombies doc with PATH=null in database ?

[milonette_]

Hello,

When I did NXQL with Nuxeo Automation I got some documents with : path:null and uid:uid:null

This documents got an ID, a title, and some data files and a lifecycle state.

But why did I got that documents in my database, because this documents doesn't exist in the interface and doesn't have a path ?

To be sure, i cleaned all my binaries and doesn't got any binaries orphans.

Moreover, this is all versions documents, but in database, their versions.versionableid doesn't exist in hierarchy table... This is all documents like that :

select * from hierarchy where id in (select v.id from versions v left join hierarchy h on h.id=v.versionableid where h.id is null) order by name;

I don't understand anything about that.. if you know what are this zombies, please tell me.

thank you

[Florent_Guillau · Accepted solution]

These are likely leftovers versions of documents that were deleted. They should have been deleted as well, but there is an issue in some Nuxeo versions where this can happen (you didn't specify what version of the Nuxeo Platform you use). Note that the version documents don't have a path and therefore are not accessible by normal users, only Administrators.

You can delete them safely at the SQL level if they are a problem for you.

[milonette_]

Hello,