Details
-
Bug
-
Resolution: Fixed
-
Medium
-
2.2.7
-
None
Description
Apparently the find unused labels SQL uses a GROUP BY clause that exceeds the 600 byte limit for Sybase.
Reference: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_12.5.svrtsg/html/svrtsg/svrtsg192.htm (Error 414)
Stack trace below.
—
Cause:
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.jdbc2.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.jdbc2.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.jdbc2.tds.Tds.processEed(Tds.java:2636)
Stack Trace: [hide]
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.jdbc2.jdbc.SybSQLException: The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600.
com.sybase.jdbc2.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.jdbc2.tds.Tds.processEed(Tds.java:2636)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1537)
at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1522)
at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:72)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:92)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92)
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3867)
at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$9.doInHibernate(HibernateLabelDao.java:519)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findUnusedLabels(HibernateLabelDao.java:513)
at com.atlassian.confluence.labels.DefaultLabelManager.removeAllLabels(DefaultLabelManager.java:207)
Attachments
Issue Links
- relates to
-
CONFSERVER-9796 Search by Labels generates a "group by" clause of more than 600 bytes, leading to an exception in Sybase
- Closed