i2b2 Sponsored Project/s:
Developer Notes:
Fixed by Mike Mendis and is included in Release 1.7.08a
Testing Notes:
Hide
In summary, the testing involved verifying queries were stopping and the thread was ending correctly when a query times out of any queue.
NOTE: This issue was tested in conjunction with
CORE-236 ,
CORE-241 ,
CORE-242 and
CORE-244 . The attached file is the full checklist of what was tested for release 1.7.08a.
Show
In summary, the testing involved verifying queries were stopping and the thread was ending correctly when a query times out of any queue.
NOTE: This issue was tested in conjunction with CORE-236 , CORE-241 , CORE-242 and CORE-244 . The attached file is the full checklist of what was tested for release 1.7.08a.
Server Plug-in/s Modified:
When a query times out of the large queue the statuses are updated to reflect that it has timed out and is no longer running. However it appears the thread is not ending correctly and the query is continuing to run. Since the query has timed out of the large queue, the next query in the queue will run. This has the potential of numerous queries running for an extensive amount of time. It is not clear what affect this would have on space issues and response time for other queries.
{"report":{"fcp":1220.5,"ttfb":433.40000000037253,"pageVisibility":"visible","entityId":11067,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"9726790d-2831-4309-9fda-19b829fdf006","navigationType":0,"readyForUser":1333,"redirectCount":0,"resourceLoadedEnd":1455,"resourceLoadedStart":441.90000000037253,"resourceTiming":[{"duration":100.40000000037253,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":441.90000000037253,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":441.90000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":542.3000000007451,"responseStart":0,"secureConnectionStart":0},{"duration":104.69999999925494,"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":442.2000000011176,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":442.2000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":546.9000000003725,"responseStart":0,"secureConnectionStart":0},{"duration":428.90000000037253,"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":442.30000000074506,"connectEnd":711.9000000003725,"connectStart":683.4000000003725,"domainLookupEnd":442.30000000074506,"domainLookupStart":442.30000000074506,"fetchStart":442.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":717.9000000003725,"responseEnd":871.2000000011176,"responseStart":742.5,"secureConnectionStart":697.3000000007451},{"duration":449.40000000037253,"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":442.30000000074506,"connectEnd":742.4000000003725,"connectStart":704.8000000007451,"domainLookupEnd":442.30000000074506,"domainLookupStart":442.30000000074506,"fetchStart":442.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":744.4000000003725,"responseEnd":891.7000000011176,"responseStart":766,"secureConnectionStart":724.6000000014901},{"duration":322.40000000037253,"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":442.5,"connectEnd":742.4000000003725,"connectStart":701.9000000003725,"domainLookupEnd":442.5,"domainLookupStart":442.5,"fetchStart":442.5,"redirectEnd":0,"redirectStart":0,"requestStart":744.3000000007451,"responseEnd":764.9000000003725,"responseStart":762.8000000007451,"secureConnectionStart":722.5},{"duration":346.1000000014901,"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":442.5,"connectEnd":767.7000000011176,"connectStart":728.1000000014901,"domainLookupEnd":442.5,"domainLookupStart":442.5,"fetchStart":442.5,"redirectEnd":0,"redirectStart":0,"requestStart":768.2000000011176,"responseEnd":788.6000000014901,"responseStart":784.1000000014901,"secureConnectionStart":753.5},{"duration":107.29999999888241,"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":442.7000000011176,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":442.7000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":550,"responseStart":0,"secureConnectionStart":0},{"duration":348.59999999962747,"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":442.7000000011176,"connectEnd":768.1000000014901,"connectStart":741.9000000003725,"domainLookupEnd":442.7000000011176,"domainLookupStart":442.7000000011176,"fetchStart":442.7000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":768.3000000007451,"responseEnd":791.3000000007451,"responseStart":786.6000000014901,"secureConnectionStart":755.7000000011176},{"duration":440,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":442.80000000074506,"connectEnd":861.1000000014901,"connectStart":836.1000000014901,"domainLookupEnd":442.80000000074506,"domainLookupStart":442.80000000074506,"fetchStart":442.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":861.1000000014901,"responseEnd":882.8000000007451,"responseStart":877.5,"secureConnectionStart":848.6000000014901},{"duration":186,"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":535.3000000007451,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":535.3000000007451,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":721.3000000007451,"responseStart":0,"secureConnectionStart":0},{"duration":412.7000000011176,"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":535.5,"connectEnd":931.4000000003725,"connectStart":906.5,"domainLookupEnd":535.5,"domainLookupStart":535.5,"fetchStart":535.5,"redirectEnd":0,"redirectStart":0,"requestStart":932.1000000014901,"responseEnd":948.2000000011176,"responseStart":946.9000000003725,"secureConnectionStart":918.5},{"duration":528.3000000007451,"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":546.4000000003725,"connectEnd":1059.300000000745,"connectStart":1034.5,"domainLookupEnd":546.4000000003725,"domainLookupStart":546.4000000003725,"fetchStart":546.4000000003725,"redirectEnd":0,"redirectStart":0,"requestStart":1059.6000000014901,"responseEnd":1074.7000000011176,"responseStart":1073.7000000011176,"secureConnectionStart":1047.2000000011176},{"duration":749.5999999996275,"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":705.4000000003725,"connectEnd":1439.800000000745,"connectStart":1411.9000000003725,"domainLookupEnd":705.4000000003725,"domainLookupStart":705.4000000003725,"fetchStart":705.4000000003725,"redirectEnd":0,"redirectStart":0,"requestStart":1439.800000000745,"responseEnd":1455,"responseStart":1454.2000000011176,"secureConnectionStart":1426.7000000011176},{"duration":465.5,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1110.7000000011176,"connectEnd":1556.800000000745,"connectStart":1532.1000000014901,"domainLookupEnd":1110.7000000011176,"domainLookupStart":1110.7000000011176,"fetchStart":1110.7000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":1557,"responseEnd":1576.2000000011176,"responseStart":1575.6000000014901,"secureConnectionStart":1544.4000000003725}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":211,"connectEnd":315,"secureConnectionStart":286,"requestStart":315,"responseStart":433,"responseEnd":705,"domLoading":440,"domInteractive":1488,"domContentLoadedEventStart":1488,"domContentLoadedEventEnd":1595,"domComplete":2203,"loadEventStart":2203,"loadEventEnd":2203,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1458.7000000011176},{"name":"bigPipe.sidebar-id.end","time":1459.9000000003725},{"name":"bigPipe.activity-panel-pipe-id.start","time":1460},{"name":"bigPipe.activity-panel-pipe-id.end","time":1462.4000000003725},{"name":"activityTabFullyLoaded","time":1614.7000000011176}],"measures":[],"correlationId":"46c29206e0c93a","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":372,"dbReadsTimeInMs":97,"dbConnsTimeInMs":108,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Major