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-243 . 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-243 . The attached file is the full checklist of what was tested for release 1.7.08a.
Server Plug-in/s Modified:
Statuses are not being updated correctly when a query times out of the large queue or an error occurs. In the QT_QUERY_RESULT_INSTANCE and QT_QUERY_INSTANCE tables the STATUS_TYPE_ID is either INCOMPLETE, PROCESSING or QUEUED when it should be TIMEDOUT or ERROR.
{"report":{"fcp":1184.6999998092651,"ttfb":171.30000019073486,"pageVisibility":"visible","entityId":11068,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"c793b941-01d3-4202-b967-f1b47ecd67a5","navigationType":0,"readyForUser":1248.5,"redirectCount":0,"resourceLoadedEnd":1110.1999998092651,"resourceLoadedStart":176.40000009536743,"resourceTiming":[{"duration":599.7999997138977,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":176.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":176.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":776.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":601.2000002861023,"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":176.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":176.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":777.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":729.5,"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":176.80000019073486,"connectEnd":804,"connectStart":781.3000001907349,"domainLookupEnd":781.3000001907349,"domainLookupStart":781.3000001907349,"fetchStart":176.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":804.0999999046326,"responseEnd":906.3000001907349,"responseStart":826.1999998092651,"secureConnectionStart":792.4000000953674},{"duration":730.2999997138977,"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":176.80000019073486,"connectEnd":803.9000000953674,"connectStart":780.6999998092651,"domainLookupEnd":780.6999998092651,"domainLookupStart":780.6999998092651,"fetchStart":176.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":804.0999999046326,"responseEnd":907.0999999046326,"responseStart":826.8000001907349,"secureConnectionStart":792},{"duration":648.9000000953674,"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":176.90000009536743,"connectEnd":804.5,"connectStart":781.4000000953674,"domainLookupEnd":781.4000000953674,"domainLookupStart":781.4000000953674,"fetchStart":176.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":804.5999999046326,"responseEnd":825.8000001907349,"responseStart":823.3000001907349,"secureConnectionStart":792.8000001907349},{"duration":648.0999999046326,"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":177.09999990463257,"connectEnd":806.9000000953674,"connectStart":783.9000000953674,"domainLookupEnd":783.9000000953674,"domainLookupStart":783.9000000953674,"fetchStart":177.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":806.9000000953674,"responseEnd":825.1999998092651,"responseStart":822.6999998092651,"secureConnectionStart":795.1999998092651},{"duration":646.9000000953674,"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":177.09999990463257,"connectEnd":808.5,"connectStart":785.5999999046326,"domainLookupEnd":785.5999999046326,"domainLookupStart":785.5999999046326,"fetchStart":177.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":808.5999999046326,"responseEnd":824,"responseStart":822.0999999046326,"secureConnectionStart":796.8000001907349},{"duration":605.5,"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":177.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":177.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":782.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":650.2999997138977,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":177.40000009536743,"connectEnd":809.0999999046326,"connectStart":785.5,"domainLookupEnd":785.5,"domainLookupStart":785.5,"fetchStart":177.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":809.1999998092651,"responseEnd":827.6999998092651,"responseStart":824.3000001907349,"secureConnectionStart":796.3000001907349},{"duration":614.9000000953674,"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":243.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":243.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":858.5,"responseStart":0,"secureConnectionStart":0},{"duration":699.8999996185303,"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":243.80000019073486,"connectEnd":926.1999998092651,"connectStart":903,"domainLookupEnd":903,"domainLookupStart":903,"fetchStart":243.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":926.1999998092651,"responseEnd":943.6999998092651,"responseStart":942,"secureConnectionStart":914.4000000953674},{"duration":728,"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":254.30000019073486,"connectEnd":968.4000000953674,"connectStart":945.4000000953674,"domainLookupEnd":945.4000000953674,"domainLookupStart":945.4000000953674,"fetchStart":254.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":968.5,"responseEnd":982.3000001907349,"responseStart":981.4000000953674,"secureConnectionStart":956.5999999046326},{"duration":848,"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":262.19999980926514,"connectEnd":1095.6999998092651,"connectStart":1072.0999999046326,"domainLookupEnd":1072.0999999046326,"domainLookupStart":1072.0999999046326,"fetchStart":262.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":1095.8000001907349,"responseEnd":1110.1999998092651,"responseStart":1109,"secureConnectionStart":1083.6999998092651},{"duration":142.09999990463257,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1109.5,"connectEnd":1235.0999999046326,"connectStart":1212.1999998092651,"domainLookupEnd":1212.1999998092651,"domainLookupStart":1212.1999998092651,"fetchStart":1109.5,"redirectEnd":0,"redirectStart":0,"requestStart":1235.1999998092651,"responseEnd":1251.5999999046326,"responseStart":1250.9000000953674,"secureConnectionStart":1223.4000000953674}],"fetchStart":0,"domainLookupStart":3,"domainLookupEnd":104,"connectStart":104,"connectEnd":141,"secureConnectionStart":115,"requestStart":141,"responseStart":172,"responseEnd":262,"domLoading":175,"domInteractive":1307,"domContentLoadedEventStart":1308,"domContentLoadedEventEnd":1344,"domComplete":1429,"loadEventStart":1429,"loadEventEnd":1430,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1286},{"name":"bigPipe.sidebar-id.end","time":1286.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1286.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1287.8000001907349},{"name":"activityTabFullyLoaded","time":1355.8000001907349}],"measures":[],"correlationId":"bee4246eb47b69","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":109,"dbReadsTimeInMs":14,"dbConnsTimeInMs":31,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Major