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

The document tree doesn't load on Postgres

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 7.4
    • Fix Version/s: 7.4.1, 8.0-milestone-1
    • Component/s: Index
    • Labels:
      None
    • Environment:
      Postgres
    • Development Priority:
      High
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      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

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

              Dates

              • Created:
                Updated:
                Resolved:
                Date of First Response: