-
Bug
-
Resolution: Fixed
-
Medium
-
6.3.11, 6.4.14
-
6.03
-
14
-
Severity 2 - Major
-
5
-
-
Summary
From investigating PS-7804 JIRA hits OOME because user create board with empty filter that load all issues in the instance and dump into the memory. JIRA eventually hit OOME when user accesses this board repeatedly.
Environment
- Large instance with > 1M issues
Steps to Reproduce
- generate 1M issues
- create Agile board with empty board filter
- load this board repeatedly
Expected Results
- there should be a limit of issues can be loaded in a single board
- there should be a validation check for creating board with empty filter
Actual Results
- JIRA hits OOME
Note
- For this fix to work you need to set "Disable empty JQL queries set" to ON.
- Please note that fix in
JRASERVER-65602would partially fix the current problem. This is due to the fact that when Agile executes the board's JQL it adds additional parameters to query so, JQL becomes "not empty" (see JRASERVER-67409).
Workaround
- Use the following SQL to list boards with empty filter
SELECT * FROM "AO_60DB71_RAPIDVIEW" WHERE "SAVED_FILTER_ID" IN (SELECT id FROM searchrequest WHERE reqcontent = '');
- To avoid loading the board directly, modify the ID in the request call below to bring you to its configuration page where you can modify the JQL in use:
https://yourdomain.com/secure/RapidView.jspa?rapidView=5791&tab=filter|
- is duplicated by
-
JRASERVER-67409 Agile board based on JQL filters with empty WhereClause returns all issues even with 'Disable empty JQL queries' set to ON.
- Gathering Impact
- is related to
-
JRASERVER-66390 It is extremely easy to save empty JQL filter
- Closed
-
JRASERVER-39542 Issue Navigator should default to no results for "New Filter"
- Closed
- relates to
-
JRASERVER-65602 As an JIRA Administrator I want to make empty JQL return no data
- Closed
-
JSWSERVER-16546 As an JIRA Software Administrator I want to limit number of issues per board to prevent resource overuse
- Gathering Interest
-
HL-171 Loading...
- causes
-
PSR-57 Loading...
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...