Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-6928

Label queries fail on Sybase

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Medium
    • None
    • 2.2.8, 2.5, 2.6.0
    • None

    Description

      Because some label queries use large Group By clauses, they fail on Sybase:

      org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600. ]; nested exception is com.sybase.jdbc3.jdbc.SybSQLException: The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600.
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:94)
      caused by: com.sybase.jdbc3.jdbc.SybSQLException: The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600.
      at com.sybase.jdbc3.tds.Tds.a(Unknown Source)

      The label_findSingleDegreeSeparationFromLabel and label_findSingleDegreeSeparationFromLabelBySpace queries need to be changed for Sybase.

      Attachments

        Issue Links

          Activity

            People

              shaffenden Steve Haffenden (Inactive)
              tom@atlassian.com Tom Davies
              Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: