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

Queries are stuck in queue when previous query results in an error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.08
    • Fix Version/s: 1.7.08a
    • Component/s: CRC Cell
    • Labels:
      None
    • Rank:
      0|i00387:
    • Sprint:
      Release 1.7.08a Sprint
    • i2b2 Feature/s:
      Queries
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Affects Database/s:
      All databases
    • Affects Web Browser/s:
      All Web Browsers
    • Developer Notes:
      Fixed by Mike Mendis and is included in Release 1.7.08a
    • Testing Notes:
      Hide
      In summary, the testing involved verifying the next query in a queue would run when a query generates an error.

      NOTE: This issue was tested in conjunction with CORE-236. The attached file is the full checklist of what was tested for release 1.7.08a.
      Show
      In summary, the testing involved verifying the next query in a queue would run when a query generates an error. NOTE: This issue was tested in conjunction with CORE-236 . The attached file is the full checklist of what was tested for release 1.7.08a.
    • Server Plug-in/s Modified:
      edu.harvard.i2b2.crc

      Description

      When a query errors out in the medium or large queue it is locking up or dropping the queue thread so no other queries are being run. The only way to free up the queue is to restart WildFly.

      What Should Happen
      If a query generates an error while running in any of the queues the following should occur.

      * The statuses are updated in the QT_QUERY_INSTANCE and QT_QUERY_RESULT_INSTANCE tables.
      * The END_DATE in the tables is updated to indicate the query is done running.
      * The queue should be free to begin running the next query.



        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jmd86 Janice Donahoe
                Reporter:
                jmd86 Janice Donahoe
                Participant/s:
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code