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
>
_______________________________________________
devs mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/devs
