Versions aren't deleted in Alfresco 3.2 CE

[luca]

Hi,
I've found that versions of a document are not deleted from the repository, I'm using Alfresco 3.2 CE.

For example I have deleted a document (also removed from the trashcan and moved in contentsore.deleted by ContentStoreCleaner). The problem is that if I search that file in the database I found some reference with this query:

select * from alf_node nd, alf_node_properties np
where nd.id = np.node_id
and np.string_value = 'DELETED_FILE_NAME.doc'‍‍‍

This nodes are stored in workspace://version2Store and have also a binary in the filesystem.

How can I find these orphan versions and delete them from the database and the filesystem? Or there is some patch/workaround that I can try?

Thanks,
Luca

[luca]

Is it possible that I have a lot (~280K) of versioned nodes without their parent in the SpaceStore??

I found them with this query:

select np.node_id, np.string_value
from alf_qname qn, alf_node_properties np
left outer join alf_node n on n.uuid = substring(np.string_value from 25 for 61)
where np.qname_id = qn.id
and qn.local_name = 'frozenNodeRef'
and n.id is null‍‍‍‍‍‍

[kattaweb]

Hi Luca,
did you find an explanation to this issue ?

I am exactly in the same situation, fortunately the number of nodes are only 1099 ( but increasing )

Do you think is it safe to remove this kind of nodes ?

Regards,
Marco

PS : I'm using Alfresco Community 5.0.a