Page 1 of 1
Cron task 'User Items Serialize' executed - Error
PostPosted:Sun Dec 15, 2013 9:38 am
by luke
Code: Select allSourced 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 ?
Re: Cron task 'User Items Serialize' executed - Error
PostPosted:Mon Dec 16, 2013 6:01 pm
by jllort
You got a username called abachta ? This user use something else than the others do not use ?
Re: Cron task 'User Items Serialize' executed - Error
PostPosted:Mon Dec 16, 2013 8:04 pm
by 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.
Re: Cron task 'User Items Serialize' executed - Error
PostPosted:Tue Dec 17, 2013 8:34 am
by pavila
I think this problem is related to database. Which one is configured with OpenKM: MySQL or HSQL?
Re: Cron task 'User Items Serialize' executed - Error
PostPosted:Tue Dec 17, 2013 9:15 am
by luke
I am using the default one. I didn`t change anything since 5 version.
Re: Cron task 'User Items Serialize' executed - Error
PostPosted:Wed Dec 18, 2013 12:08 pm
by 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.
Re: Cron task 'User Items Serialize' executed - Error
PostPosted:Sun Dec 22, 2013 8:12 pm
by 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 ?
Re: Cron task 'User Items Serialize' executed - Error
PostPosted:Mon Dec 23, 2013 6:12 pm
by 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.