5 Mar
2010
5 Mar
'10
7:14 a.m.
The Main.RecentChanges page is failing on myxwiki (apparently all subwikis) and I was able
to get some information out of it.
The problem can be isolated to the query in this snippet, it works on my local wiki
installation with postgres but fails on the incubator.
{{velocity}}
$xwiki.searchDocuments(", XWikiRCSNodeInfo as ni where doc.id=ni.id.docId and
ni.id.version2=1 group by doc.space, doc.name order by max(ni.date) desc", 1, 0)
{{/velocity}}
This is the generated hql query I got from the logs on my local machine where the query
succeeds.
select distinct doc.space, doc.name, max(ni.date) from com.xpn.xwiki.doc.XWikiDocument as
doc , com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo as ni where (doc.hidden <> true or
doc.hidden is null) and doc.id=ni.id.docId and ni.id.version2=1 group by doc.space,
doc.name order by max(ni.date) desc
here is the query from the error message from trying to run the above snippet (or the
RecentChanges page)
select distinct doc.space, doc.name, max(ni.date) from XWikiDocument as doc ,
XWikiRCSNodeInfo as ni where (doc.hidden <> true or doc.hidden is null) and
doc.id=ni.id.docId and ni.id.version2=1 group by doc.space, doc.name order by max(ni.date)
desc
They appear to be functionally identical, maybe the query is different from 2.1 and is
disagreeing with the mysql version on myxwiki, or perhaps something is just misconfigured.
It doesn't seem like the db is corrupt since it happens on multiple subwikis.
The bottom part of the stack trace.
Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching
documents with SQL [select distinct doc.space, doc.name, max(ni.date) from XWikiDocument
as doc , XWikiRCSNodeInfo as ni where (doc.hidden <> true or doc.hidden is null) and
doc.id=ni.id.docId and ni.id.version2=1 group by doc.space, doc.name order by max(ni.date)
desc]
Wrapped Exception: could not execute query
at
com.xpn.xwiki.store.XWikiHibernateStore.searchGenericInternal(XWikiHibernateStore.java:2470)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentReferencesInternal(XWikiHibernateStore.java:2426)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNamesInternal(XWikiHibernateStore.java:2413)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2190)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2169)
at com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:373)
at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:491)
at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389)
at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270)
... 80 more
Can't be too careful.
Caleb