Details
-
Bug
-
Resolution: Timed out
-
Low
-
None
-
6.4.13, 7.3.1
-
6.04
-
5
-
Severity 3 - Minor
-
Description
Summary
When trying to view issues with Epic link from the pie chart gadget a very long JQL query may be created, causing a 500 error.
java.lang.IllegalArgumentException: Request header is too large
Steps to reproduce
- Have a large number of issues types.
- Have at least one issue assigned to at least one epic.
- Create a filter type != Epic
- Create a pie chart gadget with the filter and "Statistic Type" set to "Epic Link"
- Click on the epic's name
Environment
<database-statistics> <Attachments>412244</Attachments> <Comments>1697609</Comments> <Components>13192</Components> <Custom-Fields>1634</Custom-Fields> <Groups>2231</Groups> <Issue-Security-Levels>16</Issue-Security-Levels> <Issue-Types>423</Issue-Types> <Issues>1740555</Issues> <Priorities>21</Priorities> <Projects>3348</Projects> <Resolutions>26</Resolutions> <Screen-Schemes>2341</Screen-Schemes> <Screens>2769</Screens> <Statuses>1282</Statuses> <Users>23649</Users> <Versions>18934</Versions> <Workflows>1070</Workflows> </database-statistics>
Expected Results
The JQL is optimized and only extends to the relevant issue type.
Actual Results
JIRA goes through all the issue types from the pie chart gadget, causing 500 error if the instance has a large number of issue types.
An example URL generated by the gadget:
<Base-URL>/issues/?jql=project+in+%28%22CTG+MY+Product%22%29+AND+type+not+in+%28Epic%29+AND+status+not+in+%28Closed%29+AND+%28labels+is+EMPTY+OR+labels+%21%3D+ShellEpic%29+AND+project+in+%2816783%29+AND+issuetype+in+%28%2213804%22%2C+%2213805%22%2C+%2213803%22%2C+%2213806%22%2C+%2211500%22%2C+%2211501%22%2C+%2212605%22%2C+%221%22%2C+%2212606%22%2C+%222%22%2C+%2212603%22%2C+%223%22%2C+%2212604%22%2C+%224%22%2C+%2212609%22%2C+%226%22%2C+%2212607%22%2C+%227%22%2C+%2212608%22%2C+%228%22%2C+%229%22%2C+%2212601%22%2C+%2210301%22%2C+%2210300%22%2C+%2212602%22%2C+%2212600%22%2C+%2213903%22%2C+%2213904%22%2C+%2213907%22%2C+%2213908%22%2C+%2213905%22%2C+%2213906%22%2C+%2211600%22%2C+%2213909%22%2C+%2210403%22%2C+%2213912%22%2C+%2210406%22%2C+%2213910%22%2C+%2212700%22%2C+%2210400%22%2C+%2213911%22%2C+%2210402%22%2C+%2211701%22%2C+%2211700%22%2C+%2212801%22%2C+%2212800%22%2C+%2210501%22%2C+%2210500%22%2C+%2211801%22%2C+%2211800%22%2C+%2211802%22%2C+%2212902%22%2C+%2210601%22%2C+%2212903%22%2C+%2212900%22%2C+%2212901%22%2C+%2210600%22%2C+%2213408%22%2C+%2212318%22%2C+%2212317%22%2C+%2213409%22%2C+%2213406%22%2C+%2213407%22%2C+%2212319%22%2C+%2210011%22%2C+%2211100%22%2C+%2212310%22%2C+%2210013%22%2C+%2212312%22%2C+%2212311%22%2C+%2213404%22%2C+%2210015%22%2C+%2212314%22%2C+%2212313%22%2C+%2210014%22%2C+%2213405%22%2C+%2212316%22%2C+%2213403%22%2C+%2212315%22%2C+%2212208%22%2C+%2212329%22%2C+%2212328%22%2C+%2212207%22%2C+%2212209%22%2C+%2212200%22%2C+%2212321%22%2C+%2212320%22%2C+%2212323%22%2C+%2212202%22%2C+%2212201%22%2C+%2212322%22%2C+%2212204%22%2C+%2212325%22%2C+%2212324%22%2C+%2212203%22%2C+%2212327%22%2C+%2212206%22%2C+%2214503%22%2C+%2212205%22%2C+%2212326%22%2C+%2213505%22%2C+%2211201%22%2C+%2211200%22%2C+%2213503%22%2C+%2211203%22%2C+%2211202%22%2C+%2211204%22%2C+%2212307%22%2C+%2212306%22%2C+%2210007%22%2C+%2212309%22%2C+%2212308%22%2C+%2210002%22%2C+%2212301%22%2C+%2212300%22%2C+%2210001%22%2C+%2214603%22%2C+%2210004%22%2C+%2212303%22%2C+%2212302%22%2C+%2210003%22%2C+%2210006%22%2C+%2212305%22%2C+%2212304%22%2C+%2210005%22%2C+%2213604%22%2C+%2213605%22%2C+%2212630%22%2C+%2212631%22%2C+%2211300%22%2C+%2210211%22%2C+%2212634%22%2C+%2210212%22%2C+%2211301%22%2C+%2213603%22%2C+%2212632%22%2C+%2210215%22%2C+%2210214%22%2C+%2212633%22%2C+%2212400%22%2C+%2210101%22%2C+%2210100%22%2C+%2212401%22%2C+%2212616%22%2C+%2212617%22%2C+%2212614%22%2C+%2213703%22%2C+%2213704%22%2C+%2212615%22%2C+%2212618%22%2C+%2212619%22%2C+%2212612%22%2C+%2211401%22%2C+%2211400%22%2C+%2212613%22%2C+%2212610%22%2C+%2211403%22%2C+%2211402%22%2C+%2212611%22%2C+%2212627%22%2C+%2210206%22%2C+%2210205%22%2C+%2212628%22%2C+%2212625%22%2C+%2210208%22%2C+%2210207%22%2C+%2212626%22%2C+%2210209%22%2C+%2212629%22%2C+%2212620%22%2C+%2210200%22%2C+%2212623%22%2C+%2210202%22%2C+%2210201%22%2C+%2212624%22%2C+%2212621%22%2C+%2212500%22%2C+%2210204%22%2C+%2210203%22%2C+%2212622%22%2C+%2212271%22%2C+%2212270%22%2C+%2214210%22%2C+%2212273%22%2C+%2212272%22%2C+%2214211%22%2C+%2212275%22%2C+%2212274%22%2C+%2214214%22%2C+%2212277%22%2C+%2212276%22%2C+%2214215%22%2C+%2214212%22%2C+%2212279%22%2C+%2214213%22%2C+%2213003%22%2C+%2212278%22%2C+%2214218%22%2C+%2214219%22%2C+%2214216%22%2C+%2210%22%2C+%2214217%22%2C+%2211%22%2C+%2212280%22%2C+%2212%22%2C+%2213%22%2C+%2212282%22%2C+%2214%22%2C+%2212281%22%2C+%2215%22%2C+%2214221%22%2C+%2212284%22%2C+%2216%22%2C+%2214222%22%2C+%2212283%22%2C+%2217%22%2C+%2212286%22%2C+%2218%22%2C+%2214220%22%2C+%2212285%22%2C+%2219%22%2C+%2214104%22%2C+%2212288%22%2C+%2212287%22%2C+%2214105%22%2C+%2214103%22%2C+%2212289%22%2C+%2220%22%2C+%2214106%22%2C+%2221%22%2C+%2214107%22%2C+%2222%22%2C+%2223%22%2C+%2224%22%2C+%2225%22%2C+%2212251%22%2C+%2226%22%2C+%2212250%22%2C+%2227%22%2C+%2212253%22%2C+%2228%22%2C+%2212252%22%2C+%2229%22%2C+%2213103%22%2C+%2212255%22%2C+%2212254%22%2C+%2213104%22%2C+%2212257%22%2C+%2212256%22%2C+%2212259%22%2C+%2212258%22%2C+%2230%22%2C+%2213105%22%2C+%2231%22%2C+%2213106%22%2C+%2232%22%2C+%2233%22%2C+%2212260%22%2C+%2235%22%2C+%2236%22%2C+%2212262%22%2C+%2212261%22%2C+%2238%22%2C+%2239%22%2C+%2212264%22%2C+%2212263%22%2C+%2214209%22%2C+%2214203%22%2C+%2212266%22%2C+%2212265%22%2C+%2214204%22%2C+%2212268%22%2C+%2212267%22%2C+%2240%22%2C+%2214207%22%2C+%2241%22%2C+%2212269%22%2C+%2214208%22%2C+%2214205%22%2C+%2243%22%2C+%2214206%22%2C+%2244%22%2C+%2245%22%2C+%2246%22%2C+%2247%22%2C+%2212351%22%2C+%2248%22%2C+%2212352%22%2C+%2213320%22%2C+%2249%22%2C+%2212231%22%2C+%2212230%22%2C+%2212350%22%2C+%2212233%22%2C+%2212232%22%2C+%2213203%22%2C+%2212353%22%2C+%2212235%22%2C+%2212234%22%2C+%2212354%22%2C+%2250%22%2C+%2212237%22%2C+%2251%22%2C+%2212236%22%2C+%2212239%22%2C+%2253%22%2C+%2212238%22%2C+%2254%22%2C+%2212240%22%2C+%2212242%22%2C+%2212000%22%2C+%2212241%22%2C+%2212244%22%2C+%2212243%22%2C+%2214303%22%2C+%2212246%22%2C+%2212245%22%2C+%2212248%22%2C+%2212247%22%2C+%2212249%22%2C+%2212330%22%2C+%2213309%22%2C+%2211009%22%2C+%2212219%22%2C+%2212218%22%2C+%2211008%22%2C+%2212339%22%2C+%2213307%22%2C+%2213308%22%2C+%2212333%22%2C+%2212211%22%2C+%2211001%22%2C+%2212210%22%2C+%2211000%22%2C+%2212334%22%2C+%2212331%22%2C+%2212213%22%2C+%2211003%22%2C+%2212212%22%2C+%2211002%22%2C+%2212332%22%2C+%2213305%22%2C+%2212337%22%2C+%2212215%22%2C+%2211005%22%2C+%2212214%22%2C+%2211004%22%2C+%2212338%22%2C+%2213306%22%2C+%2212335%22%2C+%2213303%22%2C+%2212217%22%2C+%2211007%22%2C+%2213304%22%2C+%2212216%22%2C+%2211006%22%2C+%2212336%22%2C+%2212340%22%2C+%2212341%22%2C+%2212220%22%2C+%2211010%22%2C+%2212229%22%2C+%2213318%22%2C+%2213319%22%2C+%2213312%22%2C+%2212344%22%2C+%2212222%22%2C+%2212221%22%2C+%2212100%22%2C+%2212345%22%2C+%2213313%22%2C+%2212342%22%2C+%2213310%22%2C+%2212224%22%2C+%2213311%22%2C+%2212223%22%2C+%2212343%22%2C+%2213316%22%2C+%2212348%22%2C+%2212226%22%2C+%2212225%22%2C+%2212349%22%2C+%2213317%22%2C+%2212346%22%2C+%2214403%22%2C+%2213314%22%2C+%2212228%22%2C+%2213315%22%2C+%2212227%22%2C+%2212347%22%2C+%2210808%22%2C+%2210807%22%2C+%2211900%22%2C+%2210701%22%2C+%2210700%22%2C+%2210703%22%2C+%2210702%22%2C+%2210704%22%2C+%2210802%22%2C+%2210801%22%2C+%2210804%22%2C+%2210803%22%2C+%2210806%22%2C+%2210805%22%2C+%2210901%22%2C+%2210900%22%2C+%2210902%22%2C+%2212291%22%2C+%2212290%22%2C+%2212293%22%2C+%2212292%22%2C+%2212295%22%2C+%2212294%22%2C+%2212297%22%2C+%2212296%22%2C+%2212299%22%2C+%2212298%22%2C+%2214003%22%2C+%2214004%22%29+AND+cf%5B10383%5D+%3D+HRPD-9
Workaround
Increase maxHttpHeaderSize values to 32768 size via server.xml and restart JIRA