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
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 = 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?