Affects View/s:
Previous Queries , Query Tool
i2b2 Sponsored Project/s:
Some large queries are remaining in the medium queue and are never completing. The CRC continues to try and run the query but is not successful. This process is then creating random issues with queries run after it; they also will not complete the query process.
No work has yet been logged on this issue.
{"report":{"fcp":978.3999999999069,"ttfb":312.30000000004657,"pageVisibility":"visible","entityId":10792,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"3c2756d5-3fd1-4a58-952b-73d1f6de0206","navigationType":0,"readyForUser":1054.3999999999069,"redirectCount":0,"resourceLoadedEnd":997.8999999999069,"resourceLoadedStart":317,"resourceTiming":[{"duration":6.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":317,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":317,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":323.5,"responseStart":0,"secureConnectionStart":0},{"duration":6.7999999998137355,"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":317.30000000004657,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":317.30000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":324.0999999998603,"responseStart":0,"secureConnectionStart":0},{"duration":374.60000000009313,"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":317.39999999990687,"connectEnd":561.3000000000466,"connectStart":537.3000000000466,"domainLookupEnd":317.39999999990687,"domainLookupStart":317.39999999990687,"fetchStart":317.39999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":561.3999999999069,"responseEnd":692,"responseStart":580.3000000000466,"secureConnectionStart":549.5},{"duration":299.4000000001397,"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":317.5999999998603,"connectEnd":598.3000000000466,"connectStart":574.3000000000466,"domainLookupEnd":317.5999999998603,"domainLookupStart":317.5999999998603,"fetchStart":317.5999999998603,"redirectEnd":0,"redirectStart":0,"requestStart":598.5999999998603,"responseEnd":617,"responseStart":616.0999999998603,"secureConnectionStart":586.3999999999069},{"duration":477.4000000001397,"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":317.5999999998603,"connectEnd":581.3999999999069,"connectStart":555.6999999999534,"domainLookupEnd":317.5999999998603,"domainLookupStart":317.5999999998603,"fetchStart":317.5999999998603,"redirectEnd":0,"redirectStart":0,"requestStart":581.3999999999069,"responseEnd":795,"responseStart":614,"secureConnectionStart":569.1999999999534},{"duration":339.30000000004657,"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":317.69999999995343,"connectEnd":641.0999999998603,"connectStart":616.8999999999069,"domainLookupEnd":317.69999999995343,"domainLookupStart":317.69999999995343,"fetchStart":317.69999999995343,"redirectEnd":0,"redirectStart":0,"requestStart":641.0999999998603,"responseEnd":657,"responseStart":656.1999999999534,"secureConnectionStart":629},{"duration":358.30000000004657,"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":317.89999999990687,"connectEnd":657.8000000000466,"connectStart":633.6999999999534,"domainLookupEnd":317.89999999990687,"domainLookupStart":317.89999999990687,"fetchStart":317.89999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":657.8999999999069,"responseEnd":676.1999999999534,"responseStart":675.3000000000466,"secureConnectionStart":645.5},{"duration":11,"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":318,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":318,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":329,"responseStart":0,"secureConnectionStart":0},{"duration":360.5999999998603,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":318,"connectEnd":659.0999999998603,"connectStart":635.1999999999534,"domainLookupEnd":318,"domainLookupStart":318,"fetchStart":318,"redirectEnd":0,"redirectStart":0,"requestStart":659.1999999999534,"responseEnd":678.5999999998603,"responseStart":677.6999999999534,"secureConnectionStart":647.3000000000466},{"duration":2.300000000046566,"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":435,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":435,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":437.30000000004657,"responseStart":0,"secureConnectionStart":0},{"duration":467.69999999995343,"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":435.19999999995343,"connectEnd":884.1999999999534,"connectStart":854.1999999999534,"domainLookupEnd":435.19999999995343,"domainLookupStart":435.19999999995343,"fetchStart":435.19999999995343,"redirectEnd":0,"redirectStart":0,"requestStart":884.3999999999069,"responseEnd":902.8999999999069,"responseStart":902,"secureConnectionStart":868.1999999999534},{"duration":524.6999999999534,"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":468.80000000004657,"connectEnd":973.6999999999534,"connectStart":948.8999999999069,"domainLookupEnd":468.80000000004657,"domainLookupStart":468.80000000004657,"fetchStart":468.80000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":977.3999999999069,"responseEnd":993.5,"responseStart":992.0999999998603,"secureConnectionStart":960.8000000000466},{"duration":507.0999999998603,"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":490.80000000004657,"connectEnd":973.6999999999534,"connectStart":943.8000000000466,"domainLookupEnd":490.80000000004657,"domainLookupStart":490.80000000004657,"fetchStart":490.80000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":978.5,"responseEnd":997.8999999999069,"responseStart":996.5,"secureConnectionStart":959.3000000000466},{"duration":127.69999999995343,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":887.8999999999069,"connectEnd":992.0999999998603,"connectStart":987.3999999999069,"domainLookupEnd":887.8999999999069,"domainLookupStart":887.8999999999069,"fetchStart":887.8999999999069,"redirectEnd":0,"redirectStart":0,"requestStart":996.1999999999534,"responseEnd":1015.5999999998603,"responseStart":1014.8000000000466,"secureConnectionStart":987.3999999999069}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":64,"connectEnd":259,"secureConnectionStart":233,"requestStart":259,"responseStart":312,"responseEnd":491,"domLoading":316,"domInteractive":1156,"domContentLoadedEventStart":1156,"domContentLoadedEventEnd":1202,"domComplete":1387,"loadEventStart":1387,"loadEventEnd":1387,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1132.3999999999069},{"name":"bigPipe.sidebar-id.end","time":1133.0999999998603},{"name":"bigPipe.activity-panel-pipe-id.start","time":1133.3000000000466},{"name":"bigPipe.activity-panel-pipe-id.end","time":1133.8000000000466},{"name":"activityTabFullyLoaded","time":1211.5}],"measures":[],"correlationId":"4353d9d858eba0","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":216,"dbReadsTimeInMs":72,"dbConnsTimeInMs":77,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Major