AnsweredAssumed Answered

Versions aren't deleted in Alfresco 3.2 CE

Question asked by luca on Mar 24, 2015
Latest reply on Mar 31, 2016 by kattaweb
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

Outcomes