topic Versions aren't deleted in Alfresco 3.2 CE in Alfresco Archive

Versions aren't deleted in Alfresco 3.2 CE

luca — Tue, 24 Mar 2015 10:22:23 GMT

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 s

Re: Versions aren't deleted in Alfresco 3.2 CE

luca — Tue, 24 Mar 2015 14:20:36 GMT

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

Re: Versions aren't deleted in Alfresco 3.2 CE

kattaweb — Thu, 31 Mar 2016 07:07:13 GMT

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