Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Working As Designed
-
1.7.07, 1.7.08, 1.7.08a
-
None
-
None
-
Rank:0|i0037b:
-
Query Tool
-
Queries
-
i2b2 Core
-
Oracle
-
This is a expected error when the thread is interrupted.
Description
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 toCORE-149.
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