Type:
Status:
Closed
Priority:
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
Developer Notes:
Many CRC files were updated. Should not notice any difference when running queries, etc. Should help with long running issue of having too many connections open.
Ensure that ResultSets, PreparedStatements and Connecitons are properly closed.
{"report":{"fcp":4333.200000286102,"ttfb":479.7000002861023,"pageVisibility":"visible","entityId":11180,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"dffa7f40-90a1-4ac0-985d-5454d6d284a6","navigationType":0,"readyForUser":3177.1000003814697,"redirectCount":0,"resourceLoadedEnd":6144.400000095367,"resourceLoadedStart":752.6000003814697,"resourceTiming":[{"duration":1017.6999998092651,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/-elaeo6/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":752.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":752.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1770.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":1018.5,"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":752.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":752.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1771.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":1643.5999999046326,"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":753.1000003814697,"connectEnd":1794.7000002861023,"connectStart":1774.8000001907349,"domainLookupEnd":1774.8000001907349,"domainLookupStart":1774.8000001907349,"fetchStart":753.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1794.8000001907349,"responseEnd":2396.7000002861023,"responseStart":1811.5,"secureConnectionStart":1784.6000003814697},{"duration":1651.5,"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":753.2000002861023,"connectEnd":1795.8000001907349,"connectStart":1776,"domainLookupEnd":1776,"domainLookupStart":1776,"fetchStart":753.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1795.9000000953674,"responseEnd":2404.7000002861023,"responseStart":2022,"secureConnectionStart":1785.7000002861023},{"duration":1475.9000000953674,"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":753.4000000953674,"connectEnd":1804.3000001907349,"connectStart":1779.6000003814697,"domainLookupEnd":1779.6000003814697,"domainLookupStart":1779.6000003814697,"fetchStart":753.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1804.4000000953674,"responseEnd":2229.300000190735,"responseStart":2214.5,"secureConnectionStart":1792},{"duration":1477.5,"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":753.7000002861023,"connectEnd":1806,"connectStart":1785.1000003814697,"domainLookupEnd":1785.1000003814697,"domainLookupStart":1785,"fetchStart":753.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1806.1000003814697,"responseEnd":2231.2000002861023,"responseStart":2215.2000002861023,"secureConnectionStart":1795.3000001907349},{"duration":1029.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":753.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":753.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1783.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":1478,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/6e923b53f106eb58ccbc528d8fc61f4a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":754,"connectEnd":1807.8000001907349,"connectStart":1784.9000000953674,"domainLookupEnd":1784.9000000953674,"domainLookupStart":1784.9000000953674,"fetchStart":754,"redirectEnd":0,"redirectStart":0,"requestStart":1807.9000000953674,"responseEnd":2232,"responseStart":2215.800000190735,"secureConnectionStart":1795.5},{"duration":1030.0999999046326,"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":754.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":754.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1784.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":1478.9000000953674,"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":754.3000001907349,"connectEnd":1811.2000002861023,"connectStart":1787.5,"domainLookupEnd":1787.5,"domainLookupStart":1787.5,"fetchStart":754.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1811.3000001907349,"responseEnd":2233.2000002861023,"responseStart":2216.5,"secureConnectionStart":1798.9000000953674},{"duration":3262.800000190735,"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":925.8000001907349,"connectEnd":3996.4000000953674,"connectStart":3828,"domainLookupEnd":3828,"domainLookupStart":3828,"fetchStart":925.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":3998.6000003814697,"responseEnd":4188.60000038147,"responseStart":4184.400000095367,"secureConnectionStart":3839.9000000953674},{"duration":5218.400000095367,"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":926,"connectEnd":5650.10000038147,"connectStart":5372.5,"domainLookupEnd":5372.5,"domainLookupStart":5372.5,"fetchStart":926,"redirectEnd":0,"redirectStart":0,"requestStart":5655,"responseEnd":6144.400000095367,"responseStart":5859,"secureConnectionStart":5382.10000038147},{"duration":1473,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":2716.5,"connectEnd":3996.300000190735,"connectStart":3828.9000000953674,"domainLookupEnd":3828.9000000953674,"domainLookupStart":3828.9000000953674,"fetchStart":2716.5,"redirectEnd":0,"redirectStart":0,"requestStart":3998.4000000953674,"responseEnd":4189.5,"responseStart":4185.400000095367,"secureConnectionStart":3838.6000003814697}],"fetchStart":0,"domainLookupStart":336,"domainLookupEnd":407,"connectStart":407,"connectEnd":444,"secureConnectionStart":418,"requestStart":444,"responseStart":480,"responseEnd":1149,"domLoading":566,"domInteractive":6178,"domContentLoadedEventStart":6178,"domContentLoadedEventEnd":6226,"domComplete":9451,"loadEventStart":9451,"loadEventEnd":9453,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":6154.800000190735},{"name":"bigPipe.sidebar-id.end","time":6155.700000286102},{"name":"bigPipe.activity-panel-pipe-id.start","time":6155.900000095367},{"name":"bigPipe.activity-panel-pipe-id.end","time":6158.700000286102},{"name":"activityTabFullyLoaded","time":6230.400000095367}],"measures":[],"correlationId":"da9d9fedf91df4","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":197,"dbReadsTimeInMs":14,"dbConnsTimeInMs":25,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Improvement
Major