Details
-
Bug
-
Resolution: Timed out
-
Low
-
None
-
5.10.6, 6.0, 6.0.1
-
5.1
-
Description
When the Work Sub-Filter for Kanban Board query exceed 255 characters it will thrown "Internal Server Error" in the configuration page and stacktrace in the logs. However the query works well in JIRA JQL search without throwing error.
stacktrace for MySQL:
2012-08-16 15:44:11,066 http-8089-3 ERROR admin 944x998x1 1mziyk4 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/subqueries/5/board.kanban.work [web.rapid.view.SubqueryResource] Unable to complete GreenHopper REST method java.lang.reflect.UndeclaredThrowableException at $Proxy1579.save(Unknown Source) at com.atlassian.greenhopper.service.rapid.view.GenericActiveObjectsDao.save(GenericActiveObjectsDao.java:49) at com.atlassian.greenhopper.service.rapid.view.subquery.SubqueryServiceImpl.updateSubquery(SubqueryServiceImpl.java:162) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'QUERY' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3556) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) ...
stacktrace for Postgres:
2012-08-14 14:14:15,779 http-8090-9 ERROR darmitage 854x75893x1 1ffwgq3 195.173.82.81 /rest/greenhopper/1.0/subqueries/11/board.kanban.work [web.rapid.view.SubqueryResource] Unable to complete GreenHopper REST method java.lang.reflect.UndeclaredThrowableException at $Proxy1804.save(Unknown Source) at com.atlassian.greenhopper.service.rapid.view.GenericActiveObjectsDao.save(GenericActiveObjectsDao.java:49) at com.atlassian.greenhopper.service.rapid.view.subquery.SubqueryServiceImpl.updateSubquery(SubqueryService ... Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ...
Sample query used in the testing:
summary ~ "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" AND assignee = currentUser() AND reporter = currentUser()
summary ~ "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx230xxxxxxx240xxxxxxx250xx255xx"