New context causes SQL Exception: Data truncation: Data too long for column 'propertyvalue' at row 1

Hi, I had a bizare problem recently and thought I would share it with everyone.

I was in the middle of a planning game and tried to create a new context (stories sorted by Assignee). When I hit save, the spinner appeared and stayed there. I reloaded the page and then pretty much everything I did generated exceptions all over the GH pages. Needless to say I couldn't use GH for the rest of the planning game.

After some investigation we found that it was only my account that was affected and after looking in the catalina.out log, found the offending exception (full exception at end).
Code:

 [id,11105] (SQL Exception while executing the following:UPDATE propertytext SET propertyvalue=? WHERE ID=? (Data truncation: Data too long for column 'propertyvalue' at row 1))

The 'propertytext' table has the 'propertyvalue' column of type TEXT (MySQL 5). The text that it failed to store was 134744 chars.

Given that it couldn't store the value, but after quite a lot of other investigation, we tried deleting some context's and that seems to have fixed it. The remaining question though, is if there's a limit on the number of Contexts that you can create? I had about 10 defined, which I didn't think was really very many.

As a slight aside, we had also tried to delete my Jira user as we thought there might be corrupt state after failing to create so many contexts. We delete the user using the Jira admin options, then recreated the user with the same name, etc. However, when we logged in to GH with the new user, all the old contexts were still there! So when we deleted the Jira user, GH didn't delete its associated state.

We are using GH 3.6 on Jira 3.12.2 professional on a Linux server.

Code:

 [id,11105] (SQL Exception while executing the following:UPDATE propertytext SET propertyvalue=? WHERE ID=? (Data truncation: Data too long for column 'propertyvalue' at row 1))
 	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:185)
 	at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:570)
 	at com.opensymphony.module.propertyset.AbstractPropertySet.setText(AbstractPropertySet.java:380)
 	at com.atlassian.jira.propertyset.JiraCachingPropertySet.setText(JiraCachingPropertySet.java:337)
 	at com.pyxis.greenhopper.jira.configurations.UserBoardsPreferences.save(UserBoardsPreferences.java:660)
 	at com.pyxis.greenhopper.jira.actions.BoardAction.getSelectedBoardId(BoardAction.java:1059)
 	at com.pyxis.greenhopper.jira.actions.BoardAction.getSelectedBoard(BoardAction.java:336)
 	at com.pyxis.greenhopper.jira.actions.TaskBoardAction.doSuccess(TaskBoardAction.java:78)
 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 	at java.lang.reflect.Method.invoke(Method.java:585)
 	at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61)
 	at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
 	at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417)
 	at webwork.action.ActionSupport.execute(ActionSupport.java:146)
 	at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54)
 	at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
 	at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:211)
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 	at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73)
 	...
 	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 	at java.lang.Thread.run(Thread.java:595)