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

8 Oct 2009

      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