OpenKM 5.0 purged files not removed from mysql database

[dzacharo]

Hi everyone,

I am using openkm 5.0 with mysql backend. I have configured repository.xml to store the actual openkm uploaded files in mysql. This creates a table named "DATASTORE" under okm_repo database. Each file uploaded to OPENKM is an independent record in the DATASTORE table. I am facing a problem which is probably a bug but there might also be a problem with my configuration.

When I delete a document from the normal workspace, it is transferred to the TRASH. When I click the file in the trash and select "purge", the file is removed from the trash. The problem is that it is not deleted at the database!

Any help would be greatly appreciated.

Best regards,
Dimitris.

[jllort]

We'll that a problem with actual jackrabbit version we're using. For some strange reason, they decided not deleting documents, and stay on some limbo. In upper versions of jackrabbit are definitively deleted ( because althought is not possible to recover limbo documents ... then why continue there ? obviously they decided deleting it on upper jackrabbit version ). I'm not sure if on 5.1 we'll upgrade to jackrabbit 2.0. probably it'll not be in version 5.1 we'll make that change because that version is focused in Saas and other features and normally between versions we don't make two major changes, we try only make one ( in order getting more stable versions )

[pavila]

I will open a bug report to be triaged.

[dzacharo]

Thank you for the fast reply. I guess I will have to wait for the next version which hopefully corrects this problem. In case you come up with a fix and need to test it, you know where to reach me

Cheers,
Dimitris.

[pavila]

Actually I can confirm a correct behaviour in this sense. When the document is deleted, it goes to user trash (not really removed from the repository). If the user empty the trash, then the document is really removed from repository. But this does not removes the document from DataStore instantly. A process called DataStoreGarbageCollector is scheduled to run every day at 00:00, and this process will force the removal of the orphan DataStore files.

I hope this clarify the question.