Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-238

JDBC calls to interrupted threads throw sqlexceptions - when queries are moved into the medium queue

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Working As Designed
    • 1.7.07, 1.7.08, 1.7.08a
    • None
    • CRC Cell
    • 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 to CORE-149.

      Attachments

        Activity

          People

            mem61 Mike Mendis
            huhickman Hubert Hickman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: