Hello,
I recently loaded ~3000 pages into my XWiki (8.2.1) instance. And noticed a
enormous increase in loading times of DocumentTree in my custom navigation
panel, which shows the pages under first level of space hierarchy:
#set( $root = $doc.getDocumentReference().getSpaceReferences().get(0).
toString().replaceAll('([~"])', '~$1').replace("Space ", "document:") +
".WebHome")
{{documentTree showTranslations="false" root="$root" showRoot="true"
showAttachments="false" /}}
Before loading the pages each request took around ~600ms. After adding the
pages load time was around 15 seconds. After bit of googling I found the
JIRA issue:
http://jira.xwiki.org/browse/XWIKI-13700
<http://jira.xwiki.org/browse/XWIKI-13700>
And decided to upgrade to 8.4.3. However, the issue did not get fixed and
there was no change in load times. Turning on debug prints for hibernate
resulted in the following:
2016-12-21 16:07:36,479 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.i.SessionImpl
- opened session at timestamp: 14823292564
2016-12-21 16:07:36,479 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.t.JDBCTransaction
- begin
2016-12-21 16:07:36,479 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.j.ConnectionManager
- opening JDBC connection
2016-12-21 16:07:36,479 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.t.JDBCTransaction
- current autocommit status: false
2016-12-21 16:07:36,479 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] INFO o.h.d.Dialect
- Using dialect: org.hibernate.dialect.HSQLDialect
2016-12-21 16:07:36,480 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.l.Loader
- loading entity: [com.xpn.xwiki.doc.XWikiDocument#-
4652072126019899209]
2016-12-21 16:07:36,480 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.j.AbstractBatcher
- about to open PreparedStatement (open PreparedStatements: 0,
globally: 0)
2016-12-21 16:07:36,480 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.SQL
- select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME
as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as
XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_,
xwikidocum0_.XWD_DEFAULT_LANGUAGE
as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_,
xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as
XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_,
xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as
XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_,
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_,
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_,
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT
as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_,
xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as
XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=?
2016-12-21 16:07:36,480 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.j.AbstractBatcher
- about to open ResultSet (open ResultSets: 0, globally: 0)
2016-12-21 16:07:36,480 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.j.AbstractBatcher
- about to close ResultSet (open ResultSets: 1, globally: 1)
2016-12-21 16:07:36,480 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.j.AbstractBatcher
- about to close PreparedStatement (open PreparedStatements: 1,
globally: 1)
2016-12-21 16:07:36,480 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG
h.e.StatefulPersistenceContext - initializing non-lazy collections
2016-12-21 16:07:36,480 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] DEBUG o.h.l.Loader
- done entity load
2016-12-21 16:07:36,481 [http://192.168.42.174/xwiki/
bin/get/XWiki/DocumentTree?outputSyntax=plain&root=
document%3Axwiki%3A2987218.WebHome&showAttachments=false&showRoot=true&
showTranslations=false&root=document%3Axwiki%3A2987218.
WebHome&showRoot=true&data=children&id=%23] INFO
h.e.d.DefaultLoadEventListener - Error performing load command
org.hibernate.ObjectNotFoundException: No row with the given identifier
exists: [com.xpn.xwiki.doc.XWikiDocument#-4652072126019899209]
at org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(
SessionFactoryImpl.java:435)
at org.hibernate.event.def.DefaultLoadEventListener.load(
DefaultLoadEventListener.java:233)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(
DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(
DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
at org.hibernate.impl.SessionImpl.load(SessionImpl.java:974)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(
XWikiHibernateStore.java:873)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(
XWikiCacheStore.java:299)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1736)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1787)
at com.xpn.xwiki.doc.XWikiDocument.getTranslatedDocument(
XWikiDocument.java:6146)
at com.xpn.xwiki.doc.XWikiDocument.getTranslatedDocument(
XWikiDocument.java:6127)
at com.xpn.xwiki.doc.XWikiDocument.getTranslatedDocument(
XWikiDocument.java:6110)
at com.xpn.xwiki.XWiki.prepareDocuments(XWiki.java:4866)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:348)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:193)
at org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:425)
at org.apache.struts.action.RequestProcessor.process(
RequestProcessor.java:228)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.
doFilter(ServletHandler.java:1669)
at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:115)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.
doFilter(ServletHandler.java:1652)
at org.xwiki.wysiwyg.server.filter.ConversionFilter.
doFilter(ConversionFilter.java:127)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.
doFilter(ServletHandler.java:1652)
at org.xwiki.container.servlet.filters.internal.
SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.
doFilter(ServletHandler.java:1652)
at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.
doFilter(SavedRequestRestorerFilter.java:208)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.
doFilter(ServletHandler.java:1652)
at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.
doFilter(SetCharacterEncodingFilter.java:111)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.
doFilter(ServletHandler.java:1652)
at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:137)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.
doFilter(ServletHandler.java:1652)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(
ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(
ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(
SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.
doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.
doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.
doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.
doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(
ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(
ContextHandlerCollection.java:215)
at org.eclipse.jetty.server.handler.HandlerCollection.
handle(HandlerCollection.java:110)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(
HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection.onFillable(
HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(
AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(
QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(
QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
*org.hibernate.ObjectNotFoundException: No row with the given identifier
exists: [com.xpn.xwiki.doc.XWikiDocument#-8266574047497816716]*So my guess
is that hibernate fails to load the entities and has to load each entity
multiple times? Is this result of a corrupt database due upgrade or
something else? This error repeats multiple times for each DocumentTree
loading ( and also some other resources ).
I have also tried to increase the amount of documents cached.
Any help is appreciated.
- Ekku Laukkarinen
Hi,
I modified the Navigation panel menu in order to have a structured tree menu
that always shows FOO page root and the opened path to reach the current
node (FOO project has nested pages).
{{velocity}}
#panelheader("FOO MENU")
## Escape special characters in macro parameter values.
#set ($openTo = $services.model.serialize($doc.documentReference,
'default').replaceAll('([~"])', '~$1'))
{{documentTree showTranslations="false" showAttachments="false"
compact="true" showRoot="true" openTo="document:$openTo"
root="document:xwiki:FOO.WebHome" /}}
#panelfooter()
{{/velocity}}
Considering all my projects are inside Main\projects page, is there a way to
find dinamically the toplevel page node without having to specify the root
page name (FOO.WebHome)?
Thanks for reply
-Matteo
--
View this message in context: http://xwiki.475771.n2.nabble.com/How-to-get-top-level-page-node-in-documen…
Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi,
Search results on wikis hosted on xxx.myxwiki.org returns:
"Failed to execute the [velocity] macro. Cause: [The execution of the
[velocity] script macro is not allowed. Check the rights of its last author
or the parameters if it's rendered from another script.]."
Thanks for your help, best regards,
--
View this message in context: http://xwiki.475771.n2.nabble.com/MyWiki-org-search-is-broken-tp7602163.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
We have editors that modified wiki pages and used the comment option that goes with a version.
But when viewing version history we see some comments ending with."..."
This suggests that the rest of the comment is in the database, but not viewable by the version history table
Is there a way to view the full comment made with a version
Is there a maximum text size for version comments
Gerritjan Koekkoek
Vader van Rai Koekkoek (cdls) en voorzitter vereniging CdLS
Visit our website<http://www.cdlsworld.org>
Facebook<https://www.facebook.com/gerritjan.koekkoek>
email<gerritjan(a)cdlsworld.org>
Hi,
I am having issues when tring to link to headings in pages with markdown.
The regular syntax (which we'd have to keep, or at least keep as basis)
for this would be [link name](#headingId).
When markdown gets parsed for xwiki, ID's are being generated for the
headings, and if the id-codes are known it is a simple matter of linking
to those, however, this becomes a near impossibility to do
beforehand. Since we'd like to avoid having to re-edit every single page
after sending a markdown page to the api, we would like to keep
this quite simple syntax, since the only workaround we could do was
insert html tags at appropriate places - however these are not evaluated
when the document is parsed with markdown.
Plus, when I use a Link to #page, xwiki will try to link to a page
named %23page instead of linking to the heading "page".
So the question is - is there a way to keep the simple markdown-syntax,
or change it slightly, to link to a heading within this page?
Hi there,
Just want to ask where to find this path /var/lib/tomcatX/webapps/ ??
My distribution wizard is fail to appear at startup, and some notes said to
delete this file.
I dont found this path.
Somebody help
Thanks
--
View this message in context: http://xwiki.475771.n2.nabble.com/Distribution-Wizard-tp7602145.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
I have recently upgraded from 3.5 to 5.5. The upgrade went fine however after logging in I accidentally hit the cancel button instead of the skip. I now want to rerun the Distribution Wizard but I cannot figure out how to re-trigger it. Can this be done?
Thank you for that information, it did indeed help.
Without understanding the phrase "on farm", that info
did not help too much, though =)
So, if you want to, blame it on me for not being informed
on what "on farm" means =)
