Developer Notes:
Queuing has been updated. Now the queries themselves can only run for the time determined by the timeout.
All queries had hard coded timeouts of 7200 seconds which meant that any query (including interactive queries) were allowed to run for 7200 seconds. Even if a large query had a configured time out greater than 7200 sec, it would only run for 7200.
Changed the code so that the actual query on the db stops (timeout or cancel) after 1. the request time out for an interactive query or 2 the configured timeout for medium or large queues. The only way to truly test that the queries stop is to log onto the db server and see how long they run for. Barring that you can look in the log for Query has timed out; Query has been cancelled messages.
This fix triggered bamboo issue #1100 (VerifyStatus failing) A subsequent fix was added to fix the VerifyStatus issue. (Basically even though the query was complete the response was showing queryInstance status = error -- you have to dig into the message to see the problem)
{"report":{"fcp":473,"ttfb":67.30000001192093,"pageVisibility":"visible","entityId":11169,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"16658000-bd77-45fc-8230-8238edde0a37","navigationType":0,"readyForUser":535.0999999940395,"redirectCount":0,"resourceLoadedEnd":293.40000000596046,"resourceLoadedStart":72.90000000596046,"resourceTiming":[{"duration":7.0999999940395355,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":72.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":72.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":80,"responseStart":0,"secureConnectionStart":0},{"duration":8,"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":73.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":73.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":81.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":116.30000001192093,"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":73.59999999403954,"connectEnd":108.80000001192093,"connectStart":85,"domainLookupEnd":73.59999999403954,"domainLookupStart":73.59999999403954,"fetchStart":73.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":109.09999999403954,"responseEnd":189.90000000596046,"responseStart":127.59999999403954,"secureConnectionStart":96.90000000596046},{"duration":133.90000000596046,"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":73.59999999403954,"connectEnd":107.80000001192093,"connectStart":83.80000001192093,"domainLookupEnd":73.59999999403954,"domainLookupStart":73.59999999403954,"fetchStart":73.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":107.90000000596046,"responseEnd":207.5,"responseStart":125.59999999403954,"secureConnectionStart":95.7000000178814},{"duration":157.69999998807907,"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":73.7000000178814,"connectEnd":215.09999999403954,"connectStart":189.7000000178814,"domainLookupEnd":73.7000000178814,"domainLookupStart":73.7000000178814,"fetchStart":73.7000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":215.30000001192093,"responseEnd":231.40000000596046,"responseStart":230.2000000178814,"secureConnectionStart":202.59999999403954},{"duration":175.7999999821186,"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":73.80000001192093,"connectEnd":231.90000000596046,"connectStart":206.90000000596046,"domainLookupEnd":73.80000001192093,"domainLookupStart":73.80000001192093,"fetchStart":73.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":233.09999999403954,"responseEnd":249.59999999403954,"responseStart":248.2000000178814,"secureConnectionStart":219.09999999403954},{"duration":175.19999998807907,"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":73.90000000596046,"connectEnd":231.80000001192093,"connectStart":207.5,"domainLookupEnd":73.90000000596046,"domainLookupStart":73.90000000596046,"fetchStart":73.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":233,"responseEnd":249.09999999403954,"responseStart":247.40000000596046,"secureConnectionStart":219.30000001192093},{"duration":13.800000011920929,"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":74,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":74,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":87.80000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":182.7000000178814,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/5c69e534a30b62def7b98bda0f001346/shortcuts.js?context=issuenavigation&context=issueaction","startTime":74.09999999403954,"connectEnd":242.09999999403954,"connectStart":214.5,"domainLookupEnd":74.09999999403954,"domainLookupStart":74.09999999403954,"fetchStart":74.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":242.2000000178814,"responseEnd":256.80000001192093,"responseStart":256,"secureConnectionStart":229.90000000596046},{"duration":9.300000011920929,"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":98,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":98,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":107.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":173.80000001192093,"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":98.40000000596046,"connectEnd":255.80000001192093,"connectStart":231.2000000178814,"domainLookupEnd":98.40000000596046,"domainLookupStart":98.40000000596046,"fetchStart":98.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":256.90000000596046,"responseEnd":272.2000000178814,"responseStart":271.09999999403954,"secureConnectionStart":243.7000000178814},{"duration":180.19999998807907,"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":107.80000001192093,"connectEnd":272.80000001192093,"connectStart":249,"domainLookupEnd":107.80000001192093,"domainLookupStart":107.80000001192093,"fetchStart":107.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":272.80000001192093,"responseEnd":288,"responseStart":286.2000000178814,"secureConnectionStart":261},{"duration":78.69999998807907,"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":214.7000000178814,"connectEnd":278.5,"connectStart":254.59999999403954,"domainLookupEnd":214.7000000178814,"domainLookupStart":214.7000000178814,"fetchStart":214.7000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":278.59999999403954,"responseEnd":293.40000000596046,"responseStart":291.5,"secureConnectionStart":266.59999999403954},{"duration":143.09999999403954,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":380.2000000178814,"connectEnd":505.90000000596046,"connectStart":480.5,"domainLookupEnd":380.2000000178814,"domainLookupStart":380.2000000178814,"fetchStart":380.2000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":506,"responseEnd":523.3000000119209,"responseStart":522.5,"secureConnectionStart":492.90000000596046}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":11,"connectEnd":40,"secureConnectionStart":25,"requestStart":40,"responseStart":68,"responseEnd":215,"domLoading":72,"domInteractive":579,"domContentLoadedEventStart":579,"domContentLoadedEventEnd":614,"domComplete":1322,"loadEventStart":1322,"loadEventEnd":1325,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":562.4000000059605},{"name":"bigPipe.sidebar-id.end","time":563.2000000178814},{"name":"bigPipe.activity-panel-pipe-id.start","time":563.4000000059605},{"name":"bigPipe.activity-panel-pipe-id.end","time":565.5999999940395},{"name":"activityTabFullyLoaded","time":623.5999999940395}],"measures":[],"correlationId":"c8fd1ebbd2fd8f","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":160,"dbReadsTimeInMs":6,"dbConnsTimeInMs":9,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}