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.
Janice Donahoe
made changes -
23/Nov/16 11:40 AM
Field
Original Value
New Value
Fix Version/s
1.7.08a
[ 10500
]
Assignee
Janice Donahoe
[ jmd86
]
i2b2 Sponsored Project/s
i2b2 Core
[ 10196
]
Status
New
[ 10000
]
Open
[ 1
]
Janice Donahoe
made changes -
23/Nov/16 11:41 AM
Status
Open
[ 1
]
In Progress
[ 3
]
Janice Donahoe
made changes -
23/Nov/16 11:41 AM
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Janice Donahoe
made changes -
23/Nov/16 11:51 AM
Sprint
Release 1.7.08a Sprint
[ 13
]
Janice Donahoe
made changes -
23/Nov/16 11:51 AM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Janice Donahoe
made changes -
23/Nov/16 11:53 AM
Testing Notes
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.
Status
Testing
[ 10002
]
Testing
[ 10002
]
Janice Donahoe
made changes -
23/Nov/16 11:55 AM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
Janice Donahoe
made changes -
09/Dec/16 10:47 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":1071,"ttfb":339,"pageVisibility":"visible","entityId":11065,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"188f2eaa-71c7-4903-9d85-2102e8af789c","navigationType":0,"readyForUser":1125.7000002861023,"redirectCount":0,"resourceLoadedEnd":1523.7000002861023,"resourceLoadedStart":352.80000019073486,"resourceTiming":[{"duration":172.40000009536743,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/-elaeo6/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":352.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":352.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":525.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":173,"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":353.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":353.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":526.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":354,"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":353.7000002861023,"connectEnd":585,"connectStart":561,"domainLookupEnd":561,"domainLookupStart":561,"fetchStart":353.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":585.1000003814697,"responseEnd":707.7000002861023,"responseStart":603.5,"secureConnectionStart":572.8000001907349},{"duration":349.7999997138977,"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":354.2000002861023,"connectEnd":548.3000001907349,"connectStart":528.4000000953674,"domainLookupEnd":528.4000000953674,"domainLookupStart":528.4000000953674,"fetchStart":354.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":548.5,"responseEnd":704,"responseStart":566.7000002861023,"secureConnectionStart":538.1000003814697},{"duration":261.40000009536743,"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":354.40000009536743,"connectEnd":601,"connectStart":575.9000000953674,"domainLookupEnd":575.9000000953674,"domainLookupStart":575.8000001907349,"fetchStart":354.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":601.3000001907349,"responseEnd":615.8000001907349,"responseStart":614.7000002861023,"secureConnectionStart":587.3000001907349},{"duration":270.69999980926514,"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":354.7000002861023,"connectEnd":611,"connectStart":589.9000000953674,"domainLookupEnd":589.9000000953674,"domainLookupStart":589.9000000953674,"fetchStart":354.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":611.1000003814697,"responseEnd":625.4000000953674,"responseStart":622.4000000953674,"secureConnectionStart":601.1000003814697},{"duration":181.90000009536743,"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":354.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":354.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":536.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":302.19999980926514,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/6e923b53f106eb58ccbc528d8fc61f4a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":355.1000003814697,"connectEnd":638.7000002861023,"connectStart":615.7000002861023,"domainLookupEnd":615.7000002861023,"domainLookupStart":615.6000003814697,"fetchStart":355.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":639.8000001907349,"responseEnd":657.3000001907349,"responseStart":656.3000001907349,"secureConnectionStart":625.7000002861023},{"duration":199.69999980926514,"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":471.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":471.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":671,"responseStart":0,"secureConnectionStart":0},{"duration":544.3000001907349,"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":471.5,"connectEnd":996.1000003814697,"connectStart":964.3000001907349,"domainLookupEnd":964.3000001907349,"domainLookupStart":964.3000001907349,"fetchStart":471.5,"redirectEnd":0,"redirectStart":0,"requestStart":998.1000003814697,"responseEnd":1015.8000001907349,"responseStart":1012.6000003814697,"secureConnectionStart":976.9000000953674},{"duration":976.5,"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":524.2000002861023,"connectEnd":1478.2000002861023,"connectStart":1435.7000002861023,"domainLookupEnd":1435.7000002861023,"domainLookupStart":1435.7000002861023,"fetchStart":524.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1478.3000001907349,"responseEnd":1500.7000002861023,"responseStart":1497.3000001907349,"secureConnectionStart":1463.3000001907349},{"duration":933.5999999046326,"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":590.1000003814697,"connectEnd":1490.6000003814697,"connectStart":1470.6000003814697,"domainLookupEnd":1470.6000003814697,"domainLookupStart":1470.6000003814697,"fetchStart":590.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1490.7000002861023,"responseEnd":1523.7000002861023,"responseStart":1512.9000000953674,"secureConnectionStart":1480.4000000953674},{"duration":564.5,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":906.1000003814697,"connectEnd":1437.3000001907349,"connectStart":1411.8000001907349,"domainLookupEnd":1411.8000001907349,"domainLookupStart":1411.8000001907349,"fetchStart":906.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1439.6000003814697,"responseEnd":1470.6000003814697,"responseStart":1463.7000002861023,"secureConnectionStart":1411.8000001907349},{"duration":229.19999980926514,"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":1474.7000002861023,"connectEnd":1672.9000000953674,"connectStart":1648.9000000953674,"domainLookupEnd":1648.9000000953674,"domainLookupStart":1648.9000000953674,"fetchStart":1474.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1673,"responseEnd":1703.9000000953674,"responseStart":1688,"secureConnectionStart":1660.6000003814697}],"fetchStart":0,"domainLookupStart":224,"domainLookupEnd":255,"connectStart":255,"connectEnd":294,"secureConnectionStart":268,"requestStart":294,"responseStart":339,"responseEnd":590,"domLoading":344,"domInteractive":1565,"domContentLoadedEventStart":1565,"domContentLoadedEventEnd":1648,"domComplete":1748,"loadEventStart":1748,"loadEventEnd":1748,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1528.3000001907349},{"name":"bigPipe.sidebar-id.end","time":1529.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1530.2000002861023},{"name":"bigPipe.activity-panel-pipe-id.end","time":1533.2000002861023},{"name":"activityTabFullyLoaded","time":1726.8000001907349}],"measures":[],"correlationId":"7382560cdd5e59","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":279,"dbReadsTimeInMs":49,"dbConnsTimeInMs":95,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}