Type:
Status:
Closed
Priority:
Resolution:
Working As Designed
Affects Version/s:
1.7.07 , 1.7.08 , 1.7.08a
Fix Version/s:
None
i2b2 Sponsored Project/s:
Developer Notes:
This is a expected error when the thread is interrupted.
This happens in both 1.7.07, 1.7.08, and 1.7.08 with the patches currently available on github.
Create a query that times out and moves into the medium queue. The following error occurs:
[INFO] Located DataSource for hiveId=[i2b2demo] projectId=[/Demo/]
[INFO] Using datasource java:/QueryToolDemoDS
[ERROR] Error while executing sql
java.sql.SQLException: IJ031013: Interrupted attempting lock:
org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@269d11d3
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.tryLock(BaseWrapperManagedConnection.java:402)
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:156)
at org.jboss.jca.adapters.jdbc.WrappedStatement.lock(WrappedStatement.java:138)
at org.jboss.jca.adapters.jdbc.WrappedResultSet.lock(WrappedResultSet.java:6022)
at org.jboss.jca.adapters.jdbc.WrappedResultSet.next(WrappedResultSet.java:2679)
at edu.harvard.i2b2.crc.dao.setfinder.QueryResultGenerator.generateResult(QueryResultGenerator.java:166)
at edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorHelperDao.runGenerator(QueryExecutorHelperDao.java:785)
at edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorHelperDao.callResultGenerator(QueryExecutorHelperDao.java:701)
at edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorHelperDao.executeQuery(QueryExecutorHelperDao.java:377)
at edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorDao.executeSQL(QueryExecutorDao.java:320)
at edu.harvard.i2b2.crc.ejb.ExecRunnable.processQueryRequest(ExecRunnable.java:492)
at edu.harvard.i2b2.crc.ejb.ExecRunnable.run(ExecRunnable.java:192)
at java.lang.Thread.run(Thread.java:745)
The initial (few) queries will finish once it is in the queue after this exception is raised.
This is a very similar bug to
CORE-149 .
made changes -
12/Dec/16 11:20 AM
Field
Original Value
New Value
Assignee
Mike Mendis
[ mem61
]
i2b2 Sponsored Project/s
i2b2 Core
[ 10196
]
Status
New
[ 10000
]
Open
[ 1
]
made changes -
30/Jan/17 10:00 AM
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
30/Jan/17 10:00 AM
Developer Notes
This is a expected error when the thread is interrupted.
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
made changes -
30/Jan/17 12:08 PM
Resolution
Working As Designed
[ 6
]
Status
Ready to Test
[ 10001
]
Resolved
[ 5
]
made changes -
08/Feb/17 12:49 PM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":1918.2000000011176,"ttfb":744,"pageVisibility":"visible","entityId":11061,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"46d6025d-894d-482b-8168-034c1a1802d2","navigationType":0,"readyForUser":1993.7000000011176,"redirectCount":0,"resourceLoadedEnd":2559.9000000003725,"resourceLoadedStart":749.5999999996275,"resourceTiming":[{"duration":721.6000000014901,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":749.5999999996275,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":749.5999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1471.2000000011176,"responseStart":0,"secureConnectionStart":0},{"duration":722.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":749.8000000007451,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":749.8000000007451,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1472.300000000745,"responseStart":0,"secureConnectionStart":0},{"duration":830.7000000011176,"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":750,"connectEnd":1500.2000000011176,"connectStart":1475.300000000745,"domainLookupEnd":750,"domainLookupStart":750,"fetchStart":750,"redirectEnd":0,"redirectStart":0,"requestStart":1500.4000000003725,"responseEnd":1580.7000000011176,"responseStart":1520,"secureConnectionStart":1487.800000000745},{"duration":833.6000000014901,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/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","startTime":750.0999999996275,"connectEnd":1500.9000000003725,"connectStart":1476.2000000011176,"domainLookupEnd":750.0999999996275,"domainLookupStart":750.0999999996275,"fetchStart":750.0999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":1501,"responseEnd":1583.7000000011176,"responseStart":1526.0999999996275,"secureConnectionStart":1488.5},{"duration":766.2999999988824,"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":750.2000000011176,"connectEnd":1501.7000000011176,"connectStart":1476.5,"domainLookupEnd":750.2000000011176,"domainLookupStart":750.2000000011176,"fetchStart":750.2000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":1501.800000000745,"responseEnd":1516.5,"responseStart":1515.5,"secureConnectionStart":1488.9000000003725},{"duration":775.4000000003725,"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":750.4000000003725,"connectEnd":1503.4000000003725,"connectStart":1479.2000000011176,"domainLookupEnd":750.4000000003725,"domainLookupStart":750.4000000003725,"fetchStart":750.4000000003725,"redirectEnd":0,"redirectStart":0,"requestStart":1503.5999999996275,"responseEnd":1525.800000000745,"responseStart":1524.5999999996275,"secureConnectionStart":1490.9000000003725},{"duration":776.4000000003725,"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":750.5,"connectEnd":1504.9000000003725,"connectStart":1479.0999999996275,"domainLookupEnd":750.5,"domainLookupStart":750.5,"fetchStart":750.5,"redirectEnd":0,"redirectStart":0,"requestStart":1505,"responseEnd":1526.9000000003725,"responseStart":1525.2000000011176,"secureConnectionStart":1490.2000000011176},{"duration":727.3999999985099,"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":750.7000000011176,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":750.7000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1478.0999999996275,"responseStart":0,"secureConnectionStart":0},{"duration":772,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":750.8000000007451,"connectEnd":1506.0999999996275,"connectStart":1481.5,"domainLookupEnd":750.8000000007451,"domainLookupStart":750.8000000007451,"fetchStart":750.8000000007451,"redirectEnd":0,"redirectStart":0,"requestStart":1506.0999999996275,"responseEnd":1522.800000000745,"responseStart":1522,"secureConnectionStart":1493.300000000745},{"duration":686.3000000007451,"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":797.4000000003725,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":797.4000000003725,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1483.7000000011176,"responseStart":0,"secureConnectionStart":0},{"duration":768.8000000007451,"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":797.5999999996275,"connectEnd":1548.800000000745,"connectStart":1516.4000000003725,"domainLookupEnd":797.5999999996275,"domainLookupStart":797.5999999996275,"fetchStart":797.5999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":1548.9000000003725,"responseEnd":1566.4000000003725,"responseStart":1565.4000000003725,"secureConnectionStart":1534.5},{"duration":1104.0999999996275,"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":806.9000000003725,"connectEnd":1895.800000000745,"connectStart":1870.5999999996275,"domainLookupEnd":806.9000000003725,"domainLookupStart":806.9000000003725,"fetchStart":806.9000000003725,"redirectEnd":0,"redirectStart":0,"requestStart":1895.9000000003725,"responseEnd":1911,"responseStart":1909.300000000745,"secureConnectionStart":1883.2000000011176},{"duration":1734.699999999255,"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":825.2000000011176,"connectEnd":2542.300000000745,"connectStart":2517,"domainLookupEnd":825.2000000011176,"domainLookupStart":825.2000000011176,"fetchStart":825.2000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":2542.300000000745,"responseEnd":2559.9000000003725,"responseStart":2558.5999999996275,"secureConnectionStart":2530.2000000011176},{"duration":743.5999999996275,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1816.4000000003725,"connectEnd":2541.800000000745,"connectStart":2517.4000000003725,"domainLookupEnd":1816.4000000003725,"domainLookupStart":1816.4000000003725,"fetchStart":1816.4000000003725,"redirectEnd":0,"redirectStart":0,"requestStart":2541.9000000003725,"responseEnd":2560,"responseStart":2559.300000000745,"secureConnectionStart":2529.7000000011176}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":692,"connectEnd":717,"secureConnectionStart":704,"requestStart":717,"responseStart":744,"responseEnd":825,"domLoading":748,"domInteractive":2596,"domContentLoadedEventStart":2596,"domContentLoadedEventEnd":2662,"domComplete":2982,"loadEventStart":2982,"loadEventEnd":2982,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2567.300000000745},{"name":"bigPipe.sidebar-id.end","time":2568.300000000745},{"name":"bigPipe.activity-panel-pipe-id.start","time":2568.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":2571.4000000003725},{"name":"activityTabFullyLoaded","time":2682.4000000003725}],"measures":[],"correlationId":"d082d19ebf68d","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":95,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Bug
Major