Problem

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

Diagnosis

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'));

Cause

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

Workaround

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

 Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

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