Details
Description
When a query times out of the large queue the statuses are updated to reflect that it has timed out and is no longer running. However it appears the thread is not ending correctly and the query is continuing to run. Since the query has timed out of the large queue, the next query in the queue will run. This has the potential of numerous queries running for an extensive amount of time. It is not clear what affect this would have on space issues and response time for other queries.
Attachments
Issue Links
Activity
Developer Notes | Fixed by Mike Mendis and is included in Release 1.7.08a | |
Server Plug-in/s Modified | edu.harvard.i2b2.crc [ 10114 ] | |
Testing Notes |
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 |
In summary, the testing involved verifying queries were stopping and the thread was ending correctly when a query times out of any queue.
NOTE: This issue was tested in conjunction with |
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. |
When a query times out of the large queue the statuses are updated to reflect that it has timed out and is no longer running. However it appears the thread is not ending correctly and the query is continuing to run. Since the query has timed out of the large queue, the next query in the queue will run. This has the potential of numerous queries running for an extensive amount of time. It is not clear what affect this would have on space issues and response time for other queries.
|
Summary | Queries do not stop running when timed out of the large queue | Queries do not stop running when they time out of the large queue |
i2b2 Feature/s | Queries [ 10081 ] | |
Status | New [ 10000 ] | Open [ 1 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Status | Resolved [ 5 ] | Closed [ 6 ] |