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.
made changes -
20/Apr/17 4:20 PM
Field
Original Value
New Value
Assignee
Lori Phillips
[ lcp5
]
made changes -
20/Apr/17 4:21 PM
Status
New
[ 10000
]
Open
[ 1
]
made changes -
20/Apr/17 4:21 PM
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
20/Apr/17 4:22 PM
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.
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
made changes -
26/Apr/17 2:43 PM
Assignee
Lori Phillips
[ lcp5
]
Janice Donahoe
[ jmd86
]
made changes -
02/May/17 2:11 PM
Fix Version/s
1.7.09
[ 10306
]
made changes -
10/May/17 10:46 AM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
made changes -
13/Jun/17 10:27 AM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
made changes -
29/Jun/17 9:15 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":1321.0999999046326,"ttfb":412.2000002861023,"pageVisibility":"visible","entityId":11180,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"c44ca2ff-fe49-4502-9d55-d60fa5bb9a47","navigationType":0,"readyForUser":1372.2000002861023,"redirectCount":0,"resourceLoadedEnd":1616.8000001907349,"resourceLoadedStart":439.30000019073486,"resourceTiming":[{"duration":179.19999980926514,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/-elaeo6/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":439.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":439.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":618.5,"responseStart":0,"secureConnectionStart":0},{"duration":179,"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":439.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":439.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":618.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":548.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":440,"connectEnd":893.5,"connectStart":868.4000000953674,"domainLookupEnd":868.4000000953674,"domainLookupStart":868.4000000953674,"fetchStart":440,"redirectEnd":0,"redirectStart":0,"requestStart":894.4000000953674,"responseEnd":988.5999999046326,"responseStart":911.3000001907349,"secureConnectionStart":881.4000000953674},{"duration":595.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":441.40000009536743,"connectEnd":883.8000001907349,"connectStart":859.5999999046326,"domainLookupEnd":859.5999999046326,"domainLookupStart":859.5999999046326,"fetchStart":441.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":884.2000002861023,"responseEnd":1036.8000001907349,"responseStart":904.4000000953674,"secureConnectionStart":871.5},{"duration":496.2000002861023,"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":441.59999990463257,"connectEnd":909.3000001907349,"connectStart":882.3000001907349,"domainLookupEnd":882.3000001907349,"domainLookupStart":882.3000001907349,"fetchStart":441.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":913.3000001907349,"responseEnd":937.8000001907349,"responseStart":927.0999999046326,"secureConnectionStart":893.9000000953674},{"duration":497.09999990463257,"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":441.80000019073486,"connectEnd":910.3000001907349,"connectStart":876.5999999046326,"domainLookupEnd":876.5999999046326,"domainLookupStart":876.5999999046326,"fetchStart":441.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":913.4000000953674,"responseEnd":938.9000000953674,"responseStart":931.2000002861023,"secureConnectionStart":893.2000002861023},{"duration":180.59999990463257,"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":442,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":442,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":622.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":540.6000003814697,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/6e923b53f106eb58ccbc528d8fc61f4a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":442.09999990463257,"connectEnd":926.5999999046326,"connectStart":906.0999999046326,"domainLookupEnd":906.0999999046326,"domainLookupStart":906.0999999046326,"fetchStart":442.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":938.4000000953674,"responseEnd":982.7000002861023,"responseStart":951.0999999046326,"secureConnectionStart":915.8000001907349},{"duration":210,"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":557.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":557.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":767.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":527.0999999046326,"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":557.8000001907349,"connectEnd":1064.7000002861023,"connectStart":1034.0999999046326,"domainLookupEnd":1034.0999999046326,"domainLookupStart":1034.0999999046326,"fetchStart":557.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1066.7000002861023,"responseEnd":1084.9000000953674,"responseStart":1082.3000001907349,"secureConnectionStart":1046.8000001907349},{"duration":1019.4000000953674,"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":597.0999999046326,"connectEnd":1595.8000001907349,"connectStart":1566.7000002861023,"domainLookupEnd":1566.7000002861023,"domainLookupStart":1566.7000002861023,"fetchStart":597.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1595.8000001907349,"responseEnd":1616.5,"responseStart":1614.9000000953674,"secureConnectionStart":1583.7000002861023},{"duration":972.2000002861023,"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":644.5999999046326,"connectEnd":1596.0999999046326,"connectStart":1570.3000001907349,"domainLookupEnd":1570.3000001907349,"domainLookupStart":1570.3000001907349,"fetchStart":644.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1596.0999999046326,"responseEnd":1616.8000001907349,"responseStart":1615.5,"secureConnectionStart":1584},{"duration":349,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1215.9000000953674,"connectEnd":1545.0999999046326,"connectStart":1513.2000002861023,"domainLookupEnd":1513.2000002861023,"domainLookupStart":1513.2000002861023,"fetchStart":1215.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1545.5,"responseEnd":1564.9000000953674,"responseStart":1563.4000000953674,"secureConnectionStart":1531.7000002861023}],"fetchStart":0,"domainLookupStart":244,"domainLookupEnd":324,"connectStart":324,"connectEnd":364,"secureConnectionStart":337,"requestStart":364,"responseStart":413,"responseEnd":645,"domLoading":417,"domInteractive":1655,"domContentLoadedEventStart":1655,"domContentLoadedEventEnd":1705,"domComplete":1927,"loadEventStart":1927,"loadEventEnd":1928,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1629.5999999046326},{"name":"bigPipe.sidebar-id.end","time":1630.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1630.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1633.0999999046326},{"name":"activityTabFullyLoaded","time":1747}],"measures":[],"correlationId":"d5bfa022219c25","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":263,"dbReadsTimeInMs":54,"dbConnsTimeInMs":88,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Improvement
Major