topic alf_data is being fat : is this a dummy question ? in Alfresco Archive

alf_data is being fat : is this a dummy question ?

tog — Wed, 11 Jun 2008 13:58:28 GMT

Hi, I have being playing around with uploading big (1GB to 10GB) files to Alfresco for few days now. The disk space of my laptop is exhausted I found out that alf_data is getting bigger and bigger. The fact is that even if you delete the files using the trash icon it does not slim down.As indicate

Re: alf_data is being fat : is this a dummy question ?

florinmarcus — Thu, 05 Mar 2009 08:32:26 GMT

I have tested myself this behavior. I have deleted a large amount of documents, I have removed everything from Manage Deleted Items also. Still , the contentstore.deleted is empty. Therefore, nothing to delete manually in order to free the disk space .

Re: alf_data is being fat : is this a dummy question ?

archana_bonkanp — Wed, 11 Mar 2009 09:31:06 GMT

so when it is safe to remove contentstore.delete.
We need a clarification like,is there a time gap to delete the same.
it doesnt have any effect on the application.

Re: alf_data is being fat : is this a dummy question ?

rogier_oudshoor — Wed, 11 Mar 2009 11:15:26 GMT

Under the bonnet, deleting an item from the "manage deleted items" is JUST a DB delete. A cron job will then eventually find the orhpans in the content store and move those into the contentstore.deleted

Therefore, it may take 24 hours (assuming your server is running night & day) for the deleted items to appear in the contentstore.deleted From there, you can delete them whenever you want - Alfresco isn't using them.

Re: alf_data is being fat : is this a dummy question ?

archana_bonkanp — Wed, 11 Mar 2009 11:35:00 GMT

is based on the property set for the value,the unused data will move from contentstore to contentstore.deleted

<property name="protectDays" >
<value>1</value>
</property>

Re: alf_data is being fat : is this a dummy question ?

archana_bonkanp — Thu, 12 Mar 2009 06:27:45 GMT

when the cron job will run?
how it will find orphans?

suppose i have taken the backup 0f 2008 in contentstore and kept it.
now in the application the cron job will delete the orphans found in 2008 of contentstore .
Then if some problem exists and i restore the 2008 contentstore which i took backup previously,now if the cron job runs and will it delete the orphans again?
i mean the orphans which were deleted before will be identified or not.

Re: alf_data is being fat : is this a dummy question ?

rogier_oudshoor — Fri, 13 Mar 2009 08:49:17 GMT

I would say probably, but i have never tested this so i'm not sure. You would need to copy your backup over what's here, rather then replace it - it would break your repository otherwise.