Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
2.6.0
-
System Date Monday, 22 Oct 2007
System Time 11:30:18
System Favourite Colour Ecru
Java Version 1.5.0_09
Java Vendor Sun Microsystems Inc.
JVM Version 1.0
JVM Vendor Sun Microsystems Inc.
JVM Implementation Version 1.5.0_09-b01
Java Runtime Java(TM) 2 Runtime Environment, Standard Edition
Java VM Java HotSpot(TM) Server VM
User Name tsgops
User Timezone US/Eastern
Operating System SunOS 5.8
OS Architecture sparc
Filesystem Encoding ISO646-USJava VM Memory Statistics
Total Memory 623 MB
Free Memory 460 MB
Used Memory 163 MB
Memory Graph
[Used Memory (26 %)] [Free Memory (74 %)]
74 % FreeRuntime Information
Database Dialect net.sf.hibernate.dialect.SybaseDialect
Database Connection URL java:jdbc/SybaseServer
Database Driver Name N/A
Database Driver Version N/A
Application Server JBossWeb/2.0.0.GA
Servlet Version 2.5
Server Base Url http://webster.bfm.com/Wiki
Confluence Home /usr/local/ext/confluence-home
Uptime 22 minutes, 9 seconds
Confluence Version 2.6.0
Build Number 913System Date Monday, 22 Oct 2007 System Time 11:30:18 System Favourite Colour Ecru Java Version 1.5.0_09 Java Vendor Sun Microsystems Inc. JVM Version 1.0 JVM Vendor Sun Microsystems Inc. JVM Implementation Version 1.5.0_09-b01 Java Runtime Java(TM) 2 Runtime Environment, Standard Edition Java VM Java HotSpot(TM) Server VM User Name tsgops User Timezone US/Eastern Operating System SunOS 5.8 OS Architecture sparc Filesystem Encoding ISO646-US Java VM Memory Statistics Total Memory 623 MB Free Memory 460 MB Used Memory 163 MB Memory Graph [Used Memory (26 %)] [Free Memory (74 %)] 74 % Free Runtime Information Database Dialect net.sf.hibernate.dialect.SybaseDialect Database Connection URL java:jdbc/SybaseServer Database Driver Name N/A Database Driver Version N/A Application Server JBossWeb/2.0.0.GA Servlet Version 2.5 Server Base Url http://webster.bfm.com/Wiki Confluence Home /usr/local/ext/confluence-home Uptime 22 minutes, 9 seconds Confluence Version 2.6.0 Build Number 913
Description
Sybase does not allow a key size (group by clause) of more than 600bytes.
In Confluence, while searching by labels, the following query:
<sql-query name="confluence.label_findSingleDegreeSeparationFromLabelBySpace"><![CDATA[select distinct {l.*}, count(lc2.LABELID) as labelCount from LABEL l, CONTENT_LABEL lc1, CONTENT_LABEL lc2 where lc1.LABELID = :labelID and lc1.CONTENTID = lc2.CONTENTID and lc2.LABELID != :labelID and lower(lc2.SPACEKEY) = :spaceKey and lc2.LABELID = l.LABELID AND l.NAMESPACE = 'global' group by lc2.LABELID, l.LABELID, l.NAMESPACE, l.NAME, l.OWNER, l.CREATIONDATE, l.LASTMODDATE order by labelCount desc]]><return alias="l" class="com.atlassian.confluence.labels.Label"/></sql-query>
generates a key size of more than 600 bytes, leading to an exception such as:
[23-10-2007 09:12:59.037] [224565] [STDOUT] [INFO ] [ajp-0.0.0.0-61781-1] 2007-10-23 09:12:59,033 ERROR [ajp-0.0.0.0-61781-1] [sf.hibernate.util.JDBCExceptionReporter] logExceptions The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600.
Apart from the above query, there are other queries pertaining to "Search by label", which add upto a key size of more than 600 bytes, which may potentially lead to a similar error.
Logs attached for more details.
Attachments
Issue Links
- duplicates
-
CONFSERVER-6928 Label queries fail on Sybase
- Closed
- is related to
-
CONFSERVER-6715 Sybase error when removing space
- Closed