[xwiki-devs] [Help] About Sanity Check
Hi, there, I'm running the sanity check script on mysql 5.0.54 and there are some queries return results. To correct these problems, should I simply just delete these results or I need to do something else before the deletion? Take an example, for the following query: select * from xwikiproperties,xwikilargestrings where xwp_classtype='com.xpn.xwiki.objects.StringListProperty' and xwp_name=xwl_name and xwp_id=xwl_id +---------+-----------------+--------------------------------------+---------+-----------------+--------------------------------------------- | XWP_ID | XWP_NAME | XWP_CLASSTYPE | XWL_ID | XWL_NAME | XWL_VALUE +---------+-----------------+--------------------------------------+---------+-----------------+--------------------------------------------- | -1877168607 | subscribedDocuments | com.xpn.xwiki.objects.StringListProperty | -1877168607 | subscribedDocuments | Main.WebSearch|Main.Categories | 261169163 | subscribedDocuments | com.xpn.xwiki.objects.StringListProperty | 261169163 | subscribedDocuments | Service Measurements.WebHome|IMProcess.WebHome | 683557787 | subscribedWebs | com.xpn.xwiki.objects.StringListProperty | 683557787 | subscribedWebs | Replication | 683557787 | subscribedDocuments | com.xpn.xwiki.objects.StringListProperty | 683557787 | subscribedDocuments | IIS.WebHome I've got couple hundred lines of records like this. If I delete all these records, what kind of impact will be to my content? Thank you very much for your help -- View this message in context: http://n2.nabble.com/Help-About-Sanity-Check-tp3670302p3670302.html Sent from the XWiki- Dev mailing list archive at Nabble.com.
Hello, I think this check is wrong. the comment above says : ## this should not return lines. This shows data in large string table that should be in largestring table select * from xwikiproperties,xwikilargestrings where xwp_classtype='com.xpn.xwiki.objects.StringListProperty' and xwp_name=xwl_name and xwp_id=xwl_id; AFAIK we are indeed storing string list properties as large strings, so it sound normal that it returns results. Can someone confirm/infirm this, to know if we have to update the sanitycheck. The proper check should be instead: ## this should not return lines. This shows data in string table that should be in largestring table select * from xwikiproperties,xwikistrings where xwp_classtype='com.xpn.xwiki.objects.StringListProperty' and xwp_name=xws_name and xwp_id=xws_id; Please let us which from the other queries that return results. Thanks, Jerome. Junjun He wrote:
Hi, there,
I'm running the sanity check script on mysql 5.0.54 and there are some queries return results. To correct these problems, should I simply just delete these results or I need to do something else before the deletion?
Take an example, for the following query:
select * from xwikiproperties,xwikilargestrings where xwp_classtype='com.xpn.xwiki.objects.StringListProperty' and xwp_name=xwl_name and xwp_id=xwl_id
+---------+-----------------+--------------------------------------+---------+-----------------+--------------------------------------------- | XWP_ID | XWP_NAME | XWP_CLASSTYPE | XWL_ID | XWL_NAME | XWL_VALUE +---------+-----------------+--------------------------------------+---------+-----------------+--------------------------------------------- | -1877168607 | subscribedDocuments | | -1877168607 | subscribedDocuments | Main.WebSearch|Main.Categories | 261169163 | subscribedDocuments | com.xpn.xwiki.objects.StringListProperty | 261169163 | subscribedDocuments | Service Measurements.WebHome|IMProcess.WebHome | 683557787 | subscribedWebs | com.xpn.xwiki.objects.StringListProperty | 683557787 | subscribedWebs | Replication | 683557787 | subscribedDocuments | com.xpn.xwiki.objects.StringListProperty | 683557787 | subscribedDocuments | IIS.WebHome
I've got couple hundred lines of records like this. If I delete all these records, what kind of impact will be to my content?
Thank you very much for your help
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 <[email protected]> wrote:
From: Jerome Velociter <[email protected]> Subject: Re: [xwiki-devs] [Help] About Sanity Check To: "XWiki Developers" <[email protected]> Date: Friday, September 18, 2009, 12:41 PM Hello,
I think this check is wrong. the comment above says :
## this should not return lines. This shows data in large string table that should be in largestring table select * from xwikiproperties,xwikilargestrings where xwp_classtype='com.xpn.xwiki.objects.StringListProperty' and xwp_name=xwl_name and xwp_id=xwl_id;
AFAIK we are indeed storing string list properties as large strings, so it sound normal that it returns results. Can someone confirm/infirm this, to know if we have to update the sanitycheck.
The proper check should be instead:
## this should not return lines. This shows data in string table that should be in largestring table select * from xwikiproperties,xwikistrings where xwp_classtype='com.xpn.xwiki.objects.StringListProperty' and xwp_name=xws_name and xwp_id=xws_id;
Please let us which from the other queries that return results.
Thanks, Jerome.
Junjun He wrote:
Hi, there,
I'm running the sanity check script on mysql 5.0.54 and there are some queries return results. To correct these problems, should I simply just delete these results or I need to do something else before the deletion?
Take an example, for the following query:
select * from xwikiproperties,xwikilargestrings where
xwp_classtype='com.xpn.xwiki.objects.StringListProperty' and
xwp_name=xwl_name and xwp_id=xwl_id
+---------+-----------------+--------------------------------------+---------+-----------------+---------------------------------------------
| XWP_ID | XWP_NAME | XWP_CLASSTYPE | XWL_ID | XWL_NAME | XWL_VALUE
+---------+-----------------+--------------------------------------+---------+-----------------+---------------------------------------------
| -1877168607 | subscribedDocuments | | -1877168607 | subscribedDocuments | Main.WebSearch|Main.Categories | 261169163 | subscribedDocuments | com.xpn.xwiki.objects.StringListProperty | 261169163 | subscribedDocuments | Service Measurements.WebHome|IMProcess.WebHome | 683557787 | subscribedWebs | com.xpn.xwiki.objects.StringListProperty | 683557787 | subscribedWebs | Replication | 683557787 | subscribedDocuments | com.xpn.xwiki.objects.StringListProperty | 683557787 | subscribedDocuments | IIS.WebHome
I've got couple hundred lines of records like this. If I delete all these records, what kind of impact will be to my content?
Thank you very much for your help
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
participants (2)
-
Jerome Velociter -
Junjun He