topic Re: bin Files are not deleted from contentstore in Alfresco Archive

bin Files are not deleted from contentstore

itayh — Wed, 11 Mar 2009 09:54:13 GMT

Hi,During the past few months we used alfresco with 2 different configuration of the contentStoreCleaner bean, One with the deletedContentBackupListener and one without (according to the Wiki at http://wiki.alfresco.com/wiki/Content_Store_Configuration).Since we notice that the size of the contentst

Re: bin Files are not deleted from contentstore

itayh — Wed, 11 Mar 2009 10:18:50 GMT

One more important question, how can we permanently delete those archive files?

Re: bin Files are not deleted from contentstore

rogier_oudshoor — Wed, 11 Mar 2009 11:25:01 GMT

Hi itayh,

Alfresco (by default) archives deleted items into its archivestore. You can turn this off as shown here: http://wiki.alfresco.com/wiki/Disabling_Document_Archival. Alternatively, under your User Profile, there's a Managed Delete Items section where you can manually decide what to do. At least, that's there in my (3.0) version …

Cheers,

Rogier

Re: bin Files are not deleted from contentstore

itayh — Wed, 11 Mar 2009 12:56:49 GMT

Thanks Rogier,

Any Idea how to permanently delete all the already archived files? We switch off the archive flag but we still want to delete all our archives.

thanks,
Itay

Re: bin Files are not deleted from contentstore

rogier_oudshoor — Wed, 11 Mar 2009 13:17:03 GMT

Assuming you cannot acces the "managed deleted items" in your version, you could create some Java code to clean the store: create a spring bean, get the nodeArchiveService from spring injection, do a search inside the archivestore for all nodes, and use the nodeArchiveService to purge them all.

Re: bin Files are not deleted from contentstore

itayh — Wed, 11 Mar 2009 14:14:08 GMT

Thanks Rogier,

The nodeArchiveService actually delete all the archive items from the DB but it did not delete themfrom the contentstore (the binaries are still in the file system). Any Idea how to delete them?

Thanks,
Itay

Re: bin Files are not deleted from contentstore

rogier_oudshoor — Thu, 12 Mar 2009 06:38:05 GMT

The move of binaries from the contentstore to contentstore.deleted is done by a backgroundjob on a daily basis (every afternoon at 4 o' clock I believe). Try waiting 24 hours and checking again

Re: bin Files are not deleted from contentstore

itayh — Mon, 16 Mar 2009 08:29:12 GMT

thanks Rogier

Re: bin Files are not deleted from contentstore

itayh — Mon, 16 Mar 2009 10:18:53 GMT

Hi Rogier,

When running nodeArchiveService.purgeAllArchivedNodes I get the next error:
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`alfresco/alf_node_status`, CONSTRAINT `FK71C2002B7F2C8017` FOREIGN KEY (`node_id`) REFERENCES `alf_node` (`id`))

Any Idea?

Re: bin Files are not deleted from contentstore

robinflow — Tue, 27 Apr 2010 15:48:20 GMT

Check these links to purge deleted, but still existing files in contentstore:
Cleaning up Orphaned Content (Purge) - http://wiki.alfresco.com/wiki/Content_Store_Configuration#Cleaning_up_Orphaned_Content_.28Purge.29
Eager Content Cleanup - http://wiki.alfresco.com/wiki/Content_Store_Configuration#Eager_Content_Cleanup