Developer Notes:
Resolved in 1.7.08a
May be related to
CORE-238 .
Run a query that times out and goes into the MEDIUM_QUEUE. I test with a query that generates a patient set and encounter set. Let that query complete.
Repeat 2 more times with same query (other queries would likely suffice), allowing the query to complete before running it again.
Run the query again. The query seems to hang in the MEDIUM_QUEUE.
If wildfly is restarted, the query runs to completion.
I am running the 1.7.08 with the patches currently in github.
{"report":{"fcp":1260.5999999999767,"ttfb":418,"pageVisibility":"visible","entityId":11062,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"70ba1b36-f8b1-40e8-b2b8-65021475f486","navigationType":0,"readyForUser":1351,"redirectCount":0,"resourceLoadedEnd":1196.5,"resourceLoadedStart":425,"resourceTiming":[{"duration":87.69999999995343,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":425,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":425,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":512.6999999999534,"responseStart":0,"secureConnectionStart":0},{"duration":87.20000000001164,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":425.5999999999767,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":425.5999999999767,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":512.7999999999884,"responseStart":0,"secureConnectionStart":0},{"duration":517.5999999999767,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":425.79999999998836,"connectEnd":747.0999999999767,"connectStart":710.3999999999651,"domainLookupEnd":425.79999999998836,"domainLookupStart":425.79999999998836,"fetchStart":425.79999999998836,"redirectEnd":0,"redirectStart":0,"requestStart":747.2999999999884,"responseEnd":943.3999999999651,"responseStart":767.2999999999884,"secureConnectionStart":735.0999999999767},{"duration":532.7999999999884,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":425.8999999999651,"connectEnd":763.7999999999884,"connectStart":736.7999999999884,"domainLookupEnd":425.8999999999651,"domainLookupStart":425.8999999999651,"fetchStart":425.8999999999651,"redirectEnd":0,"redirectStart":0,"requestStart":763.8999999999651,"responseEnd":958.6999999999534,"responseStart":786.5999999999767,"secureConnectionStart":749},{"duration":357.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":426.5,"connectEnd":764.1999999999534,"connectStart":737.3999999999651,"domainLookupEnd":426.5,"domainLookupStart":426.5,"fetchStart":426.5,"redirectEnd":0,"redirectStart":0,"requestStart":764.1999999999534,"responseEnd":784,"responseStart":783.1999999999534,"secureConnectionStart":749.2999999999884},{"duration":572.9000000000233,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":426.5999999999767,"connectEnd":983.7999999999884,"connectStart":958.5,"domainLookupEnd":426.5999999999767,"domainLookupStart":426.5999999999767,"fetchStart":426.5999999999767,"redirectEnd":0,"redirectStart":0,"requestStart":984,"responseEnd":999.5,"responseStart":998.2999999999884,"secureConnectionStart":971.8999999999651},{"duration":575.7000000000116,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":426.69999999995343,"connectEnd":987.1999999999534,"connectStart":959.8999999999651,"domainLookupEnd":426.69999999995343,"domainLookupStart":426.69999999995343,"fetchStart":426.69999999995343,"redirectEnd":0,"redirectStart":0,"requestStart":988.1999999999534,"responseEnd":1002.3999999999651,"responseStart":1001.6999999999534,"secureConnectionStart":972.8999999999651},{"duration":96.09999999997672,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":426.79999999998836,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":426.79999999998836,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":522.8999999999651,"responseStart":0,"secureConnectionStart":0},{"duration":619.4000000000233,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":426.8999999999651,"connectEnd":1023.5,"connectStart":999.2999999999884,"domainLookupEnd":426.8999999999651,"domainLookupStart":426.8999999999651,"fetchStart":426.8999999999651,"redirectEnd":0,"redirectStart":0,"requestStart":1023.5,"responseEnd":1046.2999999999884,"responseStart":1040,"secureConnectionStart":1011.5},{"duration":67.40000000002328,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":586.1999999999534,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":586.1999999999534,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":653.5999999999767,"responseStart":0,"secureConnectionStart":0},{"duration":518.4000000000233,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":586.3999999999651,"connectEnd":1079.2999999999884,"connectStart":1050.7999999999884,"domainLookupEnd":586.3999999999651,"domainLookupStart":586.3999999999651,"fetchStart":586.3999999999651,"redirectEnd":0,"redirectStart":0,"requestStart":1080.399999999965,"responseEnd":1104.7999999999884,"responseStart":1097.1999999999534,"secureConnectionStart":1066.899999999965},{"duration":586.1000000000349,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":605.8999999999651,"connectEnd":1174.7999999999884,"connectStart":1146.0999999999767,"domainLookupEnd":605.8999999999651,"domainLookupStart":605.8999999999651,"fetchStart":605.8999999999651,"redirectEnd":0,"redirectStart":0,"requestStart":1175.5,"responseEnd":1192,"responseStart":1191,"secureConnectionStart":1161.1999999999534},{"duration":352.1000000000349,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":844.3999999999651,"connectEnd":1182.5,"connectStart":1156.7999999999884,"domainLookupEnd":844.3999999999651,"domainLookupStart":844.3999999999651,"fetchStart":844.3999999999651,"redirectEnd":0,"redirectStart":0,"requestStart":1182.6999999999534,"responseEnd":1196.5,"responseStart":1195.6999999999534,"secureConnectionStart":1170},{"duration":181.60000000003492,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1121.399999999965,"connectEnd":1285.399999999965,"connectStart":1261.2999999999884,"domainLookupEnd":1121.399999999965,"domainLookupStart":1121.399999999965,"fetchStart":1121.399999999965,"redirectEnd":0,"redirectStart":0,"requestStart":1285.399999999965,"responseEnd":1303,"responseStart":1302.5,"secureConnectionStart":1273.399999999965}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":332,"connectEnd":369,"secureConnectionStart":344,"requestStart":369,"responseStart":418,"responseEnd":844,"domLoading":424,"domInteractive":1438,"domContentLoadedEventStart":1439,"domContentLoadedEventEnd":1474,"domComplete":2730,"loadEventStart":2730,"loadEventEnd":2731,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1421.0999999999767},{"name":"bigPipe.sidebar-id.end","time":1421.7999999999884},{"name":"bigPipe.activity-panel-pipe-id.start","time":1422},{"name":"bigPipe.activity-panel-pipe-id.end","time":1424.5999999999767},{"name":"activityTabFullyLoaded","time":1486.5}],"measures":[],"correlationId":"db6d9b97d31e8d","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":449,"dbReadsTimeInMs":20,"dbConnsTimeInMs":91,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}