Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-13025

The document tree doesn't load on Postgres

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 7.4.1, 8.0-milestone-1
    • 7.4
    • Index
    • None
    • Postgres
    • High
    • Unknown
    • N/A
    • N/A

    Description

      After upgrading to 7.4 from 7.2, the ‘Pages in <spacename>’ on the Dashboard page never finish loading. This error only appears on new spaces. Existing spaces load fine.

      postgres syslog

      Jan 22 05:46:54 perch postgres[13210]: [1487-3] DETAIL:  parameters: $1 = 'test4', $2 = 'test4.%', $3 = 'dummy', $4 = 'xwiki', $5 = 'xwiki:XWiki.mfarrell', $6 = 'xwiki:XWiki.mfarrell^XWiki.XWikiUsers', $7 = 'xwiki:Main.LDAPFrigoff^XWiki.XWikiGroups', $8 = 'xwiki:Main.LDAPUsers^XWiki.XWikiGroups', $9 = 'xwiki:Main.LDAPAdmin^XWiki.XWikiGroups', $10 = '20'
      Jan 22 05:46:56 perch postgres[13210]: [1488-1] ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list at character 505
      Jan 22 05:46:56 perch postgres[13210]: [1488-2] STATEMENT:  select distinct case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end as col_0_0_, case when xwikispace1_.XWS_PARENT='test4' then 0 else 1 end as col_1_0_ from xwikidoc xwikidocum0_ cross join xwikispace xwikispace1_ where xwikispace1_.XWS_HIDDEN<>true and (xwikidocum0_.XWD_HIDDEN<>true or xwikidocum0_.XWD_HIDDEN is null) and (xwikispace1_.XWS_PARENT=$1 or xwikidocum0_.XWD_WEB=$2 and xwikidocum0_.XWD_TRANSLATION=0 and xwikidocum0_.XWD_NAME<>$3) order by lower(case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end), case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end limit $4
      

      catalina.out

      2016-01-22 05:46:56,315 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSyntax=plain&root=document%3Axwiki%3Atest4.WebHome&showAttachments=false&showTranslations=false&root=document%3Axwiki%3Atest4.WebHome&data=children&id=%23] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 0, SQLState: 42P10
      2016-01-22 05:46:56,327 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSyntax=plain&root=document%3Axwiki%3Atest4.WebHome&showAttachments=false&showTranslations=false&root=document%3Axwiki%3Atest4.WebHome&data=children&id=%23] ERROR o.h.u.JDBCExceptionReporter    - ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
        Position: 505
      2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSyntax=plain&root=document%3Axwiki%3Atest4.WebHome&showAttachments=false&showTranslations=false&root=document%3Axwiki%3Atest4.WebHome&data=children&id=%23] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #addNestedChildDocuments called at 63:xwiki:XWiki.DocumentTree[line 440, column 1]
      2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSyntax=plain&root=document%3Axwiki%3Atest4.WebHome&showAttachments=false&showTranslations=false&root=document%3Axwiki%3Atest4.WebHome&data=children&id=%23] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #addChildDocuments called at 63:xwiki:XWiki.DocumentTree[line 626, column 1]
      2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSyntax=plain&root=document%3Axwiki%3Atest4.WebHome&showAttachments=false&showTranslations=false&root=document%3Axwiki%3Atest4.WebHome&data=children&id=%23] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #addDocumentChildren called at 63:xwiki:XWiki.DocumentTree[line 1, column 1]
      2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSyntax=plain&root=document%3Axwiki%3Atest4.WebHome&showAttachments=false&showTranslations=false&root=document%3Axwiki%3Atest4.WebHome&data=children&id=%23] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #getChildren called at 63:xwiki:XWiki.DocumentTree[line 39, column 1]
      2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSyntax=plain&root=document%3Axwiki%3Atest4.WebHome&showAttachments=false&showTranslations=false&root=document%3Axwiki%3Atest4.WebHome&data=children&id=%23] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #handleDocumentTreeRequest called at 63:xwiki:XWiki.DocumentTree[line 3, column 1]
      

      Attachments

        Activity

          People

            mflorea Marius Dumitru Florea
            mwfarrell Mike Farrell
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: