18 Sep
2009
18 Sep
'09
6:41 p.m.
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