Versions aren't deleted in Alfresco 3.2 CE

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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‍‍‍‍‍‍