i2b2 Sponsored Project/s:
When writing to the PM user session log, the set login attempt needs to use the database timestamp instead of the calendar.getInstance().getTime(). This will prevent queries from generating an error when trying to write to the log at the same time.
Part of the problem is the PM user session log has a primary key in which two entries cannot have the same user and date-time. When a query runs it is the service account that is logged as the user. So if two or more people are running a query (ontology, setfinder, pdo, etc) and the crc is trying to write to the log at the exact same time, then only one entry will file and the other entries will error because the system thinks it is a duplicate.
Temporary work around is to delete the constraint on the log.
{"report":{"fcp":1809,"ttfb":1091.9000005722046,"pageVisibility":"visible","entityId":11071,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"e7cc58da-a8cc-4396-a34e-da32e2f09361","navigationType":0,"readyForUser":1858.2000007629395,"redirectCount":0,"resourceLoadedEnd":1911.1000003814697,"resourceLoadedStart":1097.2000007629395,"resourceTiming":[{"duration":121.79999923706055,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":1097.2000007629395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1097.2000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1219,"responseStart":0,"secureConnectionStart":0},{"duration":122.30000019073486,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/41b71ca9fb0eed92dc73e9510f2744ee/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true&whisper-enabled=true","startTime":1097.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1097.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1219.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":286,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":1097.7000007629395,"connectEnd":1300.2000007629395,"connectStart":1276.5,"domainLookupEnd":1276.5,"domainLookupStart":1276.5,"fetchStart":1097.7000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":1300.4000005722046,"responseEnd":1383.7000007629395,"responseStart":1318.2000007629395,"secureConnectionStart":1288.2000007629395},{"duration":302.9000005722046,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/41b71ca9fb0eed92dc73e9510f2744ee/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true&whisper-enabled=true","startTime":1098,"connectEnd":1321.6000003814697,"connectStart":1299.3000001907349,"domainLookupEnd":1299.3000001907349,"domainLookupStart":1299.3000001907349,"fetchStart":1098,"redirectEnd":0,"redirectStart":0,"requestStart":1322.7000007629395,"responseEnd":1400.9000005722046,"responseStart":1338.6000003814697,"secureConnectionStart":1311.2000007629395},{"duration":246.89999961853027,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":1098.1000003814697,"connectEnd":1331.8000001907349,"connectStart":1311.6000003814697,"domainLookupEnd":1311.6000003814697,"domainLookupStart":1311.6000003814697,"fetchStart":1098.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1331.9000005722046,"responseEnd":1345,"responseStart":1343.6000003814697,"secureConnectionStart":1321.3000001907349},{"duration":248.69999980926514,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":1098.3000001907349,"connectEnd":1331.9000005722046,"connectStart":1306.3000001907349,"domainLookupEnd":1306.3000001907349,"domainLookupStart":1306.3000001907349,"fetchStart":1098.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1332.1000003814697,"responseEnd":1347,"responseStart":1345.6000003814697,"secureConnectionStart":1319.3000001907349},{"duration":264,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":1098.5,"connectEnd":1346.9000005722046,"connectStart":1323,"domainLookupEnd":1323,"domainLookupStart":1323,"fetchStart":1098.5,"redirectEnd":0,"redirectStart":0,"requestStart":1347.6000003814697,"responseEnd":1362.5,"responseStart":1361.2000007629395,"secureConnectionStart":1334.5},{"duration":127.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":1098.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1098.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1226.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":274.80000019073486,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":1099,"connectEnd":1360.6000003814697,"connectStart":1341.2000007629395,"domainLookupEnd":1341.2000007629395,"domainLookupStart":1341.2000007629395,"fetchStart":1099,"redirectEnd":0,"redirectStart":0,"requestStart":1360.7000007629395,"responseEnd":1373.8000001907349,"responseStart":1372.3000001907349,"secureConnectionStart":1350.7000007629395},{"duration":490.29999923706055,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/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":1200.7000007629395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1200.7000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1691,"responseStart":0,"secureConnectionStart":0},{"duration":555.4000005722046,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/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":1201,"connectEnd":1741.4000005722046,"connectStart":1717.9000005722046,"domainLookupEnd":1717.9000005722046,"domainLookupStart":1717.9000005722046,"fetchStart":1201,"redirectEnd":0,"redirectStart":0,"requestStart":1741.4000005722046,"responseEnd":1756.4000005722046,"responseStart":1755,"secureConnectionStart":1729.5},{"duration":624.3000001907349,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":1223.4000005722046,"connectEnd":1831.4000005722046,"connectStart":1803.6000003814697,"domainLookupEnd":1803.6000003814697,"domainLookupStart":1803.6000003814697,"fetchStart":1223.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":1831.4000005722046,"responseEnd":1847.7000007629395,"responseStart":1846.2000007629395,"secureConnectionStart":1817.2000007629395},{"duration":668.3999996185303,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":1242.7000007629395,"connectEnd":1898.7000007629395,"connectStart":1878,"domainLookupEnd":1878,"domainLookupStart":1878,"fetchStart":1242.7000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":1898.8000001907349,"responseEnd":1911.1000003814697,"responseStart":1909.5,"secureConnectionStart":1888.6000003814697},{"duration":241.30000019073486,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1562,"connectEnd":1783.5,"connectStart":1763.9000005722046,"domainLookupEnd":1763.9000005722046,"domainLookupStart":1763.9000005722046,"fetchStart":1562,"redirectEnd":0,"redirectStart":0,"requestStart":1783.5,"responseEnd":1803.3000001907349,"responseStart":1801.2000007629395,"secureConnectionStart":1773.5}],"fetchStart":917,"domainLookupStart":920,"domainLookupEnd":1008,"connectStart":1008,"connectEnd":1042,"secureConnectionStart":1018,"requestStart":1042,"responseStart":1092,"responseEnd":1243,"domLoading":1096,"domInteractive":1979,"domContentLoadedEventStart":1979,"domContentLoadedEventEnd":2017,"domComplete":2268,"loadEventStart":2268,"loadEventEnd":2268,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1959.5},{"name":"bigPipe.sidebar-id.end","time":1960.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1960.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1961.3000001907349},{"name":"activityTabFullyLoaded","time":2032.1000003814697}],"measures":[],"correlationId":"da872c1a967f4d","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":189,"dbReadsTimeInMs":19,"dbConnsTimeInMs":42,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}