December 2016 - xwiki-users@xwiki.org

[xwiki-users] (no subject)
by Ekku Laukkarinen 23 Dec '16

23 Dec '16

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

2 1

[xwiki-users] How to get top level page node in documentTree?
by matmassa 21 Dec '16

21 Dec '16

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.

2 3

[xwiki-users] MyWiki.org: search is broken
by xrichard 21 Dec '16

21 Dec '16

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.

2 4

[xwiki-users] Version comment too long to view
by Gerritjan Koekkoek 21 Dec '16

21 Dec '16

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>

2 1

[xwiki-users] [ANN] XWiki 8.4.3 released
by Ecaterina Moraru (Valica) 20 Dec '16

20 Dec '16

The XWiki development team is proud to announce the availability of XWiki 8.4.3. This release is a bugfix release that brings usability improvements to the Drawer, Wiki Index and Template Providers. You can download it here: http://www.xwiki.org/xwiki/bin/view/Main/Download Make sure to review the release notes: http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/Data/XWiki/8.4.3/ Thanks for your support -The XWiki dev team

1 0

[xwiki-users] Markdown 8.3 Links to headings
by Stefan Helmerichs 20 Dec '16

20 Dec '16

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?

2 4

[xwiki-users] Distribution Wizard
by hamiazuhk26 20 Dec '16

20 Dec '16

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.

2 4

[xwiki-users] rerun distribution wizard
by Kelly Steinke 20 Dec '16

20 Dec '16

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?

3 3

[xwiki-users] markdown in xwiki8.4
by Stefan Helmerichs 19 Dec '16

19 Dec '16

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 =)

1 0

[xwiki-users] Upgrading xwiki
by Khu Gambateh 19 Dec '16

19 Dec '16

how to copy the configuration files and do the merge copy? What is merge copy? Directly copy paste or what.. Im stuck, please help me

6 10