topic Re: Lost files from filesystem in Alfresco Archive

Lost files from filesystem

mauro_lorenzutt — Thu, 10 Sep 2009 07:50:58 GMT

Hi all,yesterday a customer of mine did an error: he deleted some folders inside the contentstore folder… He deleted some folders likecontentstore/2009/7/20contentstore/2009/7/21contentstore/2009/7/22Since the documents contained in those folders are not so important, we'd like to synchronize the da

Re: Lost files from filesystem

rogier_oudshoor — Fri, 11 Sep 2009 12:38:43 GMT

Wow, you have one stupid client there

You have to write your own crawler to check every file & cm:content property and your content, version, archive and avm stores to check if they still match in Java, and deleted whatever is gone.

Re: Lost files from filesystem

mrogers — Fri, 11 Sep 2009 13:40:59 GMT

You don't neccessarily need to crawl through all your data. The folders in the content store repository correspond to dates, so your client lost 3 days worth of content. You may be able to search for all nodes created on those particular dates which will at least tell you which files you have lost.

But the most important thing (for any IT system, including alfresco) is to make sure backups are being made.

Re: Lost files from filesystem

mauro_lorenzutt — Tue, 15 Sep 2009 09:43:42 GMT

You don't neccessarily need to crawl through all your data. The folders in the content store repository correspond to dates, so your client lost 3 days worth of content. You may be able to search for all nodes created on those particular dates which will at least tell you which files you have lost.

But the most important thing (for any IT system, including alfresco) is to make sure backups are being made.

Thank you very much. I'll try to find out all the pending records and clean up the db.
Anyway, can you confirm that when I finished the cleaning everything starts to work fine again? Or is it possible that something was corrupted and will not be repaired after this operation?

In the mean time, I replaced that folders with a very old backup (maybe every file was there, I can't guarantee it…) and I rebuilt the Lucene index. Now I get the following exception in some folders:

javax.faces.FacesException: org.alfresco.service.cmr.repository.InvalidNodeRefException: Node does not exist: workspace://SpacesStore/d3bf11fa-34ed-2341fefedfdf

P.S. I know that a backup is important but someone doesn't give the right importance to backups… Now I'm sure that it will be a priority 😉

Mauro

Re: Lost files from filesystem

mrogers — Tue, 15 Sep 2009 10:24:47 GMT

You need the content store And the database backup together.
Either one without the other is not going to work.

However if you do have a backup of the filesystem then you can simply copy the missing folders from backup.   Problem over!

However assuming that you really don't have a backup then take a backup of both database and content store before you touch the live alfresco system!    And install that backup onto a test system so you can check whether your proposed changes work.

What you are missing is the content for some of your nodes.    There's no worry about any "corruption", your database is intact.    And your content store is fine as well except for a missing few folders.

Your first task is to do some analysis to identify which nodes have a problem.
And what are the associations to those problem nodes.

You may be able to "fix up" the content or delete the problem nodes.