Some files and folders disappeared???

[ilagi]

Hi All,
This is something new and scarry. We are using OpenKM 4.1 for a few months and now the first time I got the complaint from one of the users that some of the folders and files she created disappeared.
I went to the activity logs and I can see that the referred folders were created and files were uploaded but they are not there anymore. I searched the activity log (MySQL so I can search to check whether there are any related log to these specific files and folder), but couldn't find anything so I had to concluded that some kind of system error caused these folders and files disappearing.

The user on one day created multiple folders and uploaded files into these folders, which all disappeared by a few days later.

Has anybody seen anything similar?

Thanks

[jllort]

1- Do you know some exact name of the files you've lost ?
2- Can you make a query under all users trash looking for something deleted
3- If in track log there's the file ... there's too de UUID, try looking all operations made by UUID
4- Do you've got backups from that months ?

Has been some anomalous power shutdown of the server ? is hard disk right ?

[ilagi]

Thanks for the reply! Please find my findings below:

1- Do you know some exact name of the files you've lost ?
>> Yes, I can see them in the okm_activity.activity table. But they show up only once - at creation. When I query the table for this file name, it shows up only once, at creation.
2- Can you make a query under all users trash looking for something deleted
>> How can I query all users trash? What is the phrase for querying that?
3- If in track log there's the file ... there's too de UUID, try looking all operations made by UUID
>> Under Activity Lod I found the file upload but i'm not sure where to find the UUID.
4- Do you've got backups from that months ?
>> Actually this was only a few days ago. I don't have the backup for the day when it was uploaded, but I have the day after. The upload was done on Friday and by Monday the file was gone.

Has been some anomalous power shutdown of the server ? is hard disk right ?
>> No power shutdown, the hard disk is a RAID0+1 with no errors. We have a daily OpenKM server restart, but for some reason the server didn't stop on Friday night, so on Saturday I had to issue CTRL+C to shut it down and restart. May that be the problem?

[jllort]

The problem with shutdown could be the cause. The repository is transactional, that means if for some reason the transaction is broken at the middle all the transaction is lost ( transaction is something more deep than a simple operation with repository, for it reason shutting down incorrectly jboss with a non right shudown could damage repository, really it's strange, but can happens. )

Do you use webdav ?

About activity log, take a look at something like this:
okmAdmin CHECKOUT_DOCUMENT /okm:root/test.xls 9def149b-b679-400c-83de-5416e372f6a8-P

The last number is the UUID ( only some operations have it into log, for example move, add new version etc... but not creation )