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.
No work has yet been logged on this issue.
{"report":{"fcp":747.4000000003725,"ttfb":208,"pageVisibility":"visible","entityId":11065,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"da97c3e2-d143-4e98-a648-44d4551cbceb","navigationType":0,"readyForUser":809.7000000011176,"redirectCount":0,"resourceLoadedEnd":733,"resourceLoadedStart":212.90000000037253,"resourceTiming":[{"duration":24.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/-elaeo6/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":212.90000000037253,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":212.90000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":237.40000000037253,"responseStart":0,"secureConnectionStart":0},{"duration":28.800000000745058,"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":213.09999999962747,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":213.09999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":241.90000000037253,"responseStart":0,"secureConnectionStart":0},{"duration":201.40000000037253,"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":213.40000000037253,"connectEnd":336.40000000037253,"connectStart":313,"domainLookupEnd":313,"domainLookupStart":313,"fetchStart":213.40000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":336.59999999962747,"responseEnd":414.80000000074506,"responseStart":360.30000000074506,"secureConnectionStart":324.40000000037253},{"duration":284.2000000011176,"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":213.59999999962747,"connectEnd":336.90000000037253,"connectStart":312.7000000011176,"domainLookupEnd":312.7000000011176,"domainLookupStart":312.7000000011176,"fetchStart":213.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":336.90000000037253,"responseEnd":497.80000000074506,"responseStart":361.5,"secureConnectionStart":323.90000000037253},{"duration":166.69999999925494,"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":213.7000000011176,"connectEnd":365.90000000037253,"connectStart":342.7000000011176,"domainLookupEnd":342.7000000011176,"domainLookupStart":342.7000000011176,"fetchStart":213.7000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":366,"responseEnd":380.40000000037253,"responseStart":379.40000000037253,"secureConnectionStart":354.09999999962747},{"duration":174.09999999962747,"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":213.90000000037253,"connectEnd":371.40000000037253,"connectStart":348,"domainLookupEnd":348,"domainLookupStart":347.90000000037253,"fetchStart":213.90000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":372.2000000011176,"responseEnd":388,"responseStart":386.40000000037253,"secureConnectionStart":359.30000000074506},{"duration":100.10000000149012,"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":214.09999999962747,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":214.09999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":314.2000000011176,"responseStart":0,"secureConnectionStart":0},{"duration":183.40000000037253,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/6e923b53f106eb58ccbc528d8fc61f4a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":214.30000000074506,"connectEnd":381.09999999962747,"connectStart":357.7000000011176,"domainLookupEnd":357.7000000011176,"domainLookupStart":357.7000000011176,"fetchStart":214.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":381.40000000037253,"responseEnd":397.7000000011176,"responseStart":395.80000000074506,"secureConnectionStart":369.2000000011176},{"duration":45.59999999962747,"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":315.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":315.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":361.09999999962747,"responseStart":0,"secureConnectionStart":0},{"duration":383.7999999988824,"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":315.7000000011176,"connectEnd":683.2000000011176,"connectStart":656,"domainLookupEnd":656,"domainLookupStart":656,"fetchStart":315.7000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":683.3000000007451,"responseEnd":699.5,"responseStart":698.5,"secureConnectionStart":668.7000000011176},{"duration":390.7000000011176,"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":337.59999999962747,"connectEnd":709.9000000003725,"connectStart":686.7000000011176,"domainLookupEnd":686.7000000011176,"domainLookupStart":686.7000000011176,"fetchStart":337.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":710,"responseEnd":728.3000000007451,"responseStart":726.7000000011176,"secureConnectionStart":698},{"duration":390,"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":343,"connectEnd":718.4000000003725,"connectStart":694.5999999996275,"domainLookupEnd":694.5999999996275,"domainLookupStart":694.5,"fetchStart":343,"redirectEnd":0,"redirectStart":0,"requestStart":718.4000000003725,"responseEnd":733,"responseStart":731.4000000003725,"secureConnectionStart":706.3000000007451},{"duration":111.40000000037253,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":615.0999999996275,"connectEnd":708.2000000011176,"connectStart":695.0999999996275,"domainLookupEnd":695.0999999996275,"domainLookupStart":695.0999999996275,"fetchStart":615.0999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":708.3000000007451,"responseEnd":726.5,"responseStart":725.4000000003725,"secureConnectionStart":696.3000000007451},{"duration":129.30000000074506,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-elaeo6/820011/16zrvj4/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-atl.general/batch.js?whisper-enabled=true","startTime":746.5999999996275,"connectEnd":856.8000000007451,"connectStart":831.5,"domainLookupEnd":831.5,"domainLookupStart":831.5,"fetchStart":746.5999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":856.8000000007451,"responseEnd":875.9000000003725,"responseStart":873.3000000007451,"secureConnectionStart":844.9000000003725}],"fetchStart":0,"domainLookupStart":16,"domainLookupEnd":114,"connectStart":114,"connectEnd":156,"secureConnectionStart":127,"requestStart":156,"responseStart":208,"responseEnd":342,"domLoading":211,"domInteractive":862,"domContentLoadedEventStart":862,"domContentLoadedEventEnd":906,"domComplete":1057,"loadEventStart":1058,"loadEventEnd":1058,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":844.5999999996275},{"name":"bigPipe.sidebar-id.end","time":845.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":845.7000000011176},{"name":"bigPipe.activity-panel-pipe-id.end","time":846.4000000003725},{"name":"activityTabFullyLoaded","time":913}],"measures":[],"correlationId":"56792bea60c307","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":170,"dbReadsTimeInMs":16,"dbConnsTimeInMs":28,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}