[CORE-252] Remove hard-coded timeout setting for medium and large queues Created: 08/Mar/17  Updated: 23/Aug/19  Resolved: 14/Jun/17

Status: Closed
Project: i2b2 Core Software
Component/s: None
Affects Version/s: 1.7.08b
Fix Version/s: 1.7.09

Type: Bug Priority: Major
Reporter: Janice Donahoe Assignee: Janice Donahoe
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i003bb:
Developer Notes: Queuing has been updated. Now the queries themselves can only run for the time determined by the timeout.

All queries had hard coded timeouts of 7200 seconds which meant that any query (including interactive queries) were allowed to run for 7200 seconds. Even if a large query had a configured time out greater than 7200 sec, it would only run for 7200.

Changed the code so that the actual query on the db stops (timeout or cancel) after 1. the request time out for an interactive query or 2 the configured timeout for medium or large queues. The only way to truly test that the queries stop is to log onto the db server and see how long they run for. Barring that you can look in the log for Query has timed out; Query has been cancelled messages.

This fix triggered bamboo issue #1100 (VerifyStatus failing) A subsequent fix was added to fix the VerifyStatus issue. (Basically even though the query was complete the response was showing queryInstance status = error -- you have to dig into the message to see the problem)

Comment by Janice Donahoe [ 14/Jun/17 ]
This issue has been fixed and will be included in release 1.7.09.
Generated at Mon Apr 06 09:56:03 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.