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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.08
    • 1.7.08a
    • CRC Cell
    • None
    • Rank:
      0|i00387:
    • Release 1.7.08a Sprint
    • Queries
    • i2b2 Core
    • All databases
    • All Web Browsers
    • Fixed by Mike Mendis and is included in Release 1.7.08a
    • 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.
    • 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

          clone of

          Bug - A problem which impairs or prevents the functions of the product. CORE-236 Error returned when query times out

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CORE-244 Statuses are not updated when query times out or an error occurs

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CORE-243 Queries do not stop running when they time out of the large queue

          • Major - Major loss of function.
          • Closed

          Activity

            People

              jmd86 Janice Donahoe
              jmd86 Janice Donahoe
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: