Cron task 'User Items Serialize' executed - Error

[luke]

Code: Select all

Sourced file: inline evaluation of: ``com.openkm.cache.UserItemsManager.serialize();'' : Method Invocation com.openkm.cache.UserItemsManager.serialize : at Line: 1 : in file: inline evaluation of: ``com.openkm.cache.UserItemsManager.serialize();'' : com .openkm .cache .UserItemsManager .serialize ( ) Target exception: com.openkm.core.DatabaseException: could not update: [com.openkm.dao.bean.cache.UserItems#abachta] 

I have such error from time to time. When I restart OpenKM it works ok for about 2 weeks and then this error appear again. Can you please help me how to fix this ?

[jllort]

You got a username called abachta ? This user use something else than the others do not use ?

[luke]

Yes I have a user called abachta. This user belongs to a group of 4 other users and yes this group has more rights than the other users. I don`t know why this crashes only for this user nor all of them.

[pavila]

I think this problem is related to database. Which one is configured with OpenKM: MySQL or HSQL?

[luke]

I am using the default one. I didn`t change anything since 5 version.

[pavila]

May be a problem with the HSQL database (the default one). This database is not recommended to be used in production. I recommend switching to MySQL.

[luke]

Dear Pavila

Can you please tell me how to migrate this database to MySQL or show me where is the tutorial to do it ?

[jllort]

Change database is not trivial, should export full repository to server and import into OpenKM configured with MySQL

1- http://wiki.openkm.com/index.php/Repository_export ( export )
2- configure openkm with mysql http://wiki.openkm.com/index.php/MySQL_-_OpenKM_6.2
3- http://wiki.openkm.com/index.php/Repository_import (import)

Is more easy than you think, but we suggest make full backup to prevent any disaster.