問題

After upgrading JIRA many users are reporting their default 'Page Size' is now set to 0.

診断

Run this query to find the global setting for number of Issues displayed per Issue Navigator page

select propertyvalue from propertystring where id = (select id from propertyentry where property_key = 'user.issues.per.page' and entity_name = 'jira.properties');

You can check the value against the user's preferences, substituting xxx with the username.

select propertyvalue from propertynumber where id = (select id from propertyentry where property_key = 'user.issues.per.page' and entity_name = 'ApplicationUser' and entity_id = (select id from cwd_user where lower_user_name = 'xxx'));

原因

Currently, the cause is unknown but observed upgrading from JIRA 5.2.5 to 7.9.1

回避策

Workarounds are ways to temporally circumvent a problem, although it still exists in the application.

 データベースを変更する前に、データのバックアップを必ず行いましょう。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除のテストを行うことをご検討ください。

Please do not run the following steps without backing up your database first!
1. Backup database
2. Shutdown Jira
3. Run the following statements:

delete from propertynumber where id = (select id from propertyentry where property_key = 'user.issues.per.page' and entity_name = 'ApplicationUser');

delete from propertyentry where property_key = 'user.issues.per.page' and entity_name = 'ApplicationUser';

4. Start Jira
5. Configure the 'Number of Issues displayed per Issue Navigator page' in the Jira administration >> System >> Default user preferences