Issue Summary

REST API request /rest/ical/1.0/ical/config/query/options is taking a long time to return the full set of data that cause the "Saved filter" query option in Jira Event Type dialog in Confluence Team Calendar to fail to load.

Environment

Large Jira instance with

• 2000+ projects, or
• 30000+ search filters

Steps to Reproduce

1. Configure 2000 projects and 30,000 filters in Jira
2. Go to Confluence, create a Calendar event that pulls in Jira projects

Expected Results

• The "Saved filter" query option loads and allows user to select one as a search query.

Actual Results

• The "Saved filter" query option does not load.
• The below exception is thrown in the atlassian-confluence.log file:

2019-07-24 04:37:44,960 ERROR [http-nio-8080-exec-1] [calendar3.rest.ExceptionMappers.GeneralExceptionMapper] getResponseError General exception happen on calendar resources
 -- referer: https://confluence/display/ZTEST/calendar/xxxxxxx-9b64-44c5-8a93-810942e14566?calendarName=Release%20Calendar | url: /rest/calendar-services/1.0/calendar/jira/xxxxxxx-cefa-3cdd-9508-4a4945627d9a/query/options.json | userName: admin
com.atlassian.sal.api.net.ResponseException: java.net.SocketTimeoutException: Read timed out

access_log of Jira show:

10.0.0.111 252x3288526x4 admin [15/Aug/2019:04:17:18 +0000] http-nio-8080-exec-1 admin "GET /rest/ical/1.0/ical/config/query/options?_=1111111111&xoauth_requestor_id=admin HTTP/1.1" 200 511689 293768 "-" "Apache-HttpClient/4.5.5 (Java/1.8.0)" "xxxxx"

293768 = 4 minutes 54 seconds

Notes

/rest/ical/1.0/ical/config/query/options contains the following data

• List of projects
• List of Search filters
• Names of viewable fields

Workaround

• Use "JQL" query option with `filter` keyword instead
• Increase the timeout for the calendar connection as mentioned in the KB article JIRA Calendar Read Timed Out.