topic Re: Corrupt files in Alfresco Archive

Corrupt files

back0rifice — Wed, 09 May 2007 12:54:27 GMT

Hello,atm I'm facing a quite weird problem. I think the root of this problem is that our /tmp volume (before I didn't even know that Alfresco uses a temp location - can this be configured anywhere?) ran out of space which led to several exceptions. After resizing the /tmp volume it seems to run fine

Re: Corrupt files

back0rifice — Wed, 09 May 2007 16:34:13 GMT

Ok, some additional information:

I did a search on the database. E.g.:

"SELECT * FROM alfresco.alf_node_properties WHERE node_id = 14069" returns the following rows:

14069, 'CONTENT', 0, 'STRING', 0, 0, 0, 0, 'contentUrl=store://2007/5/9/11/15/c7dcfcc4-fe0d-11db-a368-3b09f364f642.bin|mimetype=application/msword|size=138240|encoding=UTF-8|locale=en_US_', '', '{http://www.alfresco.org/model/content/1.0}content'
14069, 'DATE', 0, 'STRING', 0, 0, 0, 0, '2007-05-09T11:15:07.826+02:00', '', '{http://www.alfresco.org/model/content/1.0}created'
14069, 'STRING', 0, 'STRING', 0, 0, 0, 0, 'hstangl', '', '{http://www.alfresco.org/model/content/1.0}creator'
14069, 'DATE', 0, 'STRING', 0, 0, 0, 0, '2007-05-09T11:15:07.952+02:00', '', '{http://www.alfresco.org/model/content/1.0}modified'
14069, 'STRING', 0, 'STRING', 0, 0, 0, 0, 'hstangl', '', '{http://www.alfresco.org/model/content/1.0}modifier'
14069, 'STRING', 0, 'STRING', 0, 0, 0, 0, 'maintenance_termsheet_StG20050122.doc', '', '{http://www.alfresco.org/model/content/1.0}name'‍‍‍‍‍‍

"SELECT * FROM alf_node WHERE id = 14069" returns 1 row, with the following content:

14069, 'workspace', 'SpacesStore', 'c7d4984b-fe0d-11db-a368-3b09f364f642', '{http://www.alfresco.org/model/content/1.0}content', ‍

–

In Linux filesystem the above mentioned file (2007/5/9/11/15/c7dcfcc4-fe0d-11db-a368-3b09f364f642.bin) does exist! I don't know if the file is ok, but at least the file size(s) seem to fit.

I don't know if this information is of any interest but maybe you can give me some feedback where to find these node/file entries and how to recover or at least get rid of them… :?:

Re: Corrupt files

andy — Thu, 10 May 2007 09:02:19 GMT

Hi

See the clean up jobs defined in scheduled-jobs-context.xml.

Here you will find the bean definitions to clean up old and temporary content.

Andy

Re: Corrupt files

back0rifice — Thu, 10 May 2007 10:23:21 GMT

Hi,

Referring to this file these two cleanup jobs should be executed automatically, shouldn't they?

Assuming that they work, it doesn't seem to solve my problem. The files still appear in CIFS but not in webclient.

Is there any safe way to delete this content from the database?

Re: Corrupt files

back0rifice — Fri, 11 May 2007 08:28:39 GMT

Some additional information…

The "corrupt" files were created on 05/09/2007 so I looked after them in the folder …/contentstore/2007/5/9/11/15

The files in there seem to have a correct filesize and database entries exist for each of them…

In order to be able to at least delete them I took an working .bin-file and copied it, providing the name of one of the "corrupt" files (which I moved before). I thought this should make it possible to delete the file but it isn't. It still says, that the file cannot be found?!

Can someone please explain me what'S going on there…?!
:?:

— Edit —

I copied the .bin files from the server and renamed them according to their file type, e.g. ".doc". Seems that the files are fine.

But how comes that they can't be handled correctly by Alfresco anymore? So it must be a kind of database issue?! (Although I believe that the contentstore URL in table node_properties should be ok?!).

Any help appreciated!!