Type:
Improvement
Status:
Closed
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
i2b2 Sponsored Project/s:
Testing Notes:
Hide
This improvement was tested with the following scenarios.
1. Timeout set to -1.
2. Timeout set to 0.
3. Timeout set to 100 as well as the default settings of 14400 and 43200.
No issues were found during the testing.
Show
This improvement was tested with the following scenarios.
1. Timeout set to -1.
2. Timeout set to 0.
3. Timeout set to 100 as well as the default settings of 14400 and 43200.
No issues were found during the testing.
The amount of time a query will run before timing out is defined in the crc.properties file. There are three properties, one for each queue (small, medium, and large).
Currently, if the timeout settings for any of these queues was defined as 0 or -1, the CRC would attempt to run the query and then it would time out.
This improvement will change that process. When the timeout is set to anything less than or equal to 0 the CRC will no longer attempt to run the process. The query will be immediately moved to the next queue to begin the process of running the query in that queue.
{"report":{"fcp":1439.6999998092651,"ttfb":202.40000009536743,"pageVisibility":"visible","entityId":11065,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"a3a7fd06-f145-469d-ab5d-7ce055874b25","navigationType":0,"readyForUser":1497.5999999046326,"redirectCount":0,"resourceLoadedEnd":1795.5999999046326,"resourceLoadedStart":399,"resourceTiming":[{"duration":208,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/-elaeo6/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":399,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":399,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":607,"responseStart":0,"secureConnectionStart":0},{"duration":208.30000019073486,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/82f2fb30b5633c684844a0d68ad88dc3-CDN/-elaeo6/820011/16zrvj4/7155e23ca74fc11d9d92532ccfab76fb/_/download/contextbatch/css/project.issue.navigator,atl.general,atl.global,jira.view.issue,jira.global,-_super/batch.css?jira.create.linked.issue=true&richediton=true&whisper-enabled=true","startTime":399.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":399.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":607.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":548.1999998092651,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/781ab6b393dc602ff71cc36d4d8c1113-CDN/-elaeo6/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":399.5,"connectEnd":648.5,"connectStart":622.5,"domainLookupEnd":622.5,"domainLookupStart":622.5,"fetchStart":399.5,"redirectEnd":0,"redirectStart":0,"requestStart":648.5,"responseEnd":947.6999998092651,"responseStart":667.6999998092651,"secureConnectionStart":635.1999998092651},{"duration":551.4000000953674,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/dd973057e68d891a3527336301218ca4-CDN/-elaeo6/820011/16zrvj4/7155e23ca74fc11d9d92532ccfab76fb/_/download/contextbatch/js/project.issue.navigator,atl.general,atl.global,jira.view.issue,jira.global,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true&whisper-enabled=true","startTime":399.59999990463257,"connectEnd":651.2999997138977,"connectStart":627.7999997138977,"domainLookupEnd":627.7999997138977,"domainLookupStart":627.7999997138977,"fetchStart":399.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":652.0999999046326,"responseEnd":951,"responseStart":854,"secureConnectionStart":639.0999999046326},{"duration":456.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-elaeo6/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":399.90000009536743,"connectEnd":652,"connectStart":628.7999997138977,"domainLookupEnd":628.7999997138977,"domainLookupStart":628.7999997138977,"fetchStart":399.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":652.1999998092651,"responseEnd":856.4000000953674,"responseStart":760.4000000953674,"secureConnectionStart":640.1999998092651},{"duration":465,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-elaeo6/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":400.09999990463257,"connectEnd":656.1999998092651,"connectStart":630.1999998092651,"domainLookupEnd":630.1999998092651,"domainLookupStart":630.1999998092651,"fetchStart":400.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":656.2999997138977,"responseEnd":865.0999999046326,"responseStart":807.4000000953674,"secureConnectionStart":644.1999998092651},{"duration":250.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/-elaeo6/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":400.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":400.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":650.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":540.8000001907349,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/6e923b53f106eb58ccbc528d8fc61f4a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":400.2999997138977,"connectEnd":854.7999997138977,"connectStart":651.0999999046326,"domainLookupEnd":651.0999999046326,"domainLookupStart":651.0999999046326,"fetchStart":400.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":867.5,"responseEnd":941.0999999046326,"responseStart":885.7999997138977,"secureConnectionStart":662.5},{"duration":243.80000019073486,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/-elaeo6/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":410.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":410.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":654.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":865.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/f14169fffa5f44f0d2568634b30ee425-CDN/-elaeo6/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":410.90000009536743,"connectEnd":1056,"connectStart":1025.1999998092651,"domainLookupEnd":1025.1999998092651,"domainLookupStart":1025.1999998092651,"fetchStart":410.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":1069.2999997138977,"responseEnd":1276.4000000953674,"responseStart":1092.9000000953674,"secureConnectionStart":1038.0999999046326},{"duration":1235.1000003814697,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-elaeo6/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":411.7999997138977,"connectEnd":1627.1999998092651,"connectStart":1601.4000000953674,"domainLookupEnd":1601.4000000953674,"domainLookupStart":1601.4000000953674,"fetchStart":411.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1627.2999997138977,"responseEnd":1646.9000000953674,"responseStart":1643.4000000953674,"secureConnectionStart":1614.1999998092651},{"duration":1383.8000001907349,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-elaeo6/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":411.7999997138977,"connectEnd":1781.1999998092651,"connectStart":1757.9000000953674,"domainLookupEnd":1757.9000000953674,"domainLookupStart":1757.9000000953674,"fetchStart":411.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1781.2999997138977,"responseEnd":1795.5999999046326,"responseStart":1794.1999998092651,"secureConnectionStart":1769.4000000953674},{"duration":544.8000001907349,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1240.0999999046326,"connectEnd":1765.9000000953674,"connectStart":1743.5999999046326,"domainLookupEnd":1743.5999999046326,"domainLookupStart":1743.5999999046326,"fetchStart":1240.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1766.0999999046326,"responseEnd":1784.9000000953674,"responseStart":1784.0999999046326,"secureConnectionStart":1754}],"fetchStart":0,"domainLookupStart":51,"domainLookupEnd":111,"connectStart":111,"connectEnd":148,"secureConnectionStart":123,"requestStart":149,"responseStart":202,"responseEnd":489,"domLoading":282,"domInteractive":1818,"domContentLoadedEventStart":1818,"domContentLoadedEventEnd":1871,"domComplete":2306,"loadEventStart":2306,"loadEventEnd":2307,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1796.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1797.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1797.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1799.9000000953674},{"name":"activityTabFullyLoaded","time":1888.5999999046326}],"measures":[],"correlationId":"6d2a5b0425e22d","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":203,"dbReadsTimeInMs":36,"dbConnsTimeInMs":41,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}