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.


  1. Run the following query on your data base:

    SELECT length(description) AS len, * FROM searchrequest WHERE description IS NOT NULL AND length(description) > 32766



  2. Update the the searchrequest table.

    UPDATE searchrequest SET description=substr(description, 0, 32766) WHERE description IS NOT NULL AND length(description) > 32766


最終更新日 2020 年 5 月 14 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.