Re: [xwiki-devs] [Help] About Sanity Check

Jerome, Thanks for your quick response. Sorry to get back to you so late. I ran the query you suggested and it returns with empty resultset. Do you think I don't need to worry about the xwikilargestrings table? The other queries return result are: select XWD_ID, XWD_FULLNAME from xwikidoc where (XWD_NAME like '% ' or XWD_NAME like '%?%' or XWD_NAME like '%+%' or XWD_NAME like '%\%%' or XWD_NAME like '%&%' or XWD_NAME like '%#%') 108 rows select XWA_ID from xwikiattachment_content where XWA_ID not in (select XWA_ID from xwikiattachment) 9 rows select XWA_ID from xwikiattachment where XWA_ID not in (select XWA_ID from xwikiattachment_archive) 35 rows select XWA_ID from xwikiattachment where XWA_ID not in (select XWA_ID from xwikiattachment_content) 18 rows select * from xwikiproperties where xwp_id not in (select xwo_id from xwikiobjects) 4 rows select * from xwikiproperties where xwp_classtype='com.xpn.xwiki.objects.StringProperty' and XWP_ID not in (select XWS_ID from xwikistrings) 4 rows select * from xwikiproperties where xwp_classtype='com.xpn.xwiki.objects.LargeStringProperty' and XWP_ID not in (select XWL_ID from xwikilargestrings) 1 row select * from xwikiproperties,xwikistrings where xwp_classtype='com.xpn.xwiki.objects.LargeStringProperty' and xwp_name=xws_name and xwp_id=xws_id 1 row select * from xwikilongs where XWL_ID not in (select XWO_ID from xwikiobjects) 12 rows select * from xwikilongs where XWL_ID not in (select XWP_ID from xwikiproperties) 12 rows select * from xwikilists where XWL_ID not in (select XWO_ID from xwikiobjects) 1 row select * from xwikilists where XWL_ID not in (select XWP_ID from xwikiproperties) 1 row select * from xwikidates where XWS_ID not in (select XWO_ID from xwikiobjects) 6 rows select * from xwikidates where XWS_ID not in (select XWP_ID from xwikiproperties) 6 rows The main reason I ran this sanity check on our mysql database is because there are a lot of "Object can't be found" error messages logged in log files. Here's one example: Oct 4, 2009 12:00:00 AM org.hibernate.event.def.DefaultLoadEventListener onLoad INFO: Error performing load command org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.xpn.xwiki.objects.classes.BaseClass#501166968] at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:784) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiClass(XWikiHibernateStore.java:1397) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:642) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:169) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1235) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1277) at com.xpn.xwiki.plugin.watchlist.WatchListJob.execute(WatchListJob.java:117) at org.quartz.core.JobRunShell.run(JobRunShell.java:203) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Oct 4, 2009 12:00:00 AM com.xpn.xwiki.store.DBCPConnectionProvider logStatistics INFO: active: 0 (max: 50) idle: 3(max: 5) Oct 4, 2009 12:00:00 AM com.xpn.xwiki.store.DBCPConnectionProvider logStatistics These kind of messages make our log file increasing very quickly and the wiki has some mysterious problems I think perhpas it's related to these object can't be found error. Could you sled some light about how to solve problems like this? Thank you again for your help, Junjun --- On Fri, 9/18/09, Jerome Velociter <jerome(a)xwiki.com> wrote: