Long filter descriptions can affect upgrading from Jira 7.x to Jira Long Term Support release 8.5
The indexed filter descriptions that are longer than 32000 characters can affect the upgrade.
Before you upgrade, make sure that there are no filter descriptions in the
searchrequest table that are longer than 32766 characters.
Run the following query on your data base:
SELECT length(description) AS len, * FROM searchrequest WHERE description IS NOT NULL AND length(description) > 32766
Update the the
UPDATE searchrequest SET description=substr(description, 0, 32766) WHERE description IS NOT NULL AND length(description) > 32766