Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Working As Designed
-
None
-
None
-
i2b2 server v1.7.09c on CentOS 7.5, Java 1.8, Wildfly 10.0.0.
Database is SQL Server 2016 on Windows 2012.
Webclient v1.7.09c is hosted in Apache on same CentOS machine as the i2b2 server.
Browser is Firefox on macOS 10.12.
Description
Hello, i2b2 Engineers,
We ran into an issue back in January and submitted a ticket to the ACT HelpDesk (ACT-177). This is essentially a copy of that ticket.
Here is our problem... Any query that takes longer than 60 seconds is "cancelled" by the webclient with the message "QUERY CANCELLED".
But the query continues to run on the i2b2 server, and I do not believe that it is moved out of the default queue. It is simply running longer than one minute, but eventually completes.
Risk: The risk is that most users will believe that their query is cancelled. And some will re-try their queries, overtaxing the system. Others will forget about their queries, and this will give our service a black eye.
Analysis: I can't tell if the server is returning some flag to the weblicent, and that is why the webclient is presenting the Query Cancelled message in the Query Status panel, or if the webclient is just "timing out" because it has not received a reply within 60 seconds. But my hunch is that this is a webclient issue; I'm not an expert.
We also find that if we wait long enough, the query results will show up in the Previous Queries panel.
We are unable to locate any remedy for this in the i2b2 documentation or configuration files.
Two questions:
1. Is there a setting we can change in our i2b2 web client or CRC cell so that queries do not time out like this in 60 seconds?
2. Is there a bug in our web client or in the CRC cell, where it reports the query was cancelled, even though it finally goes through to completion?
Please note: This issue was also raised on the i2b2 Install Help Google group with this topic "Problem with CANCELLED queries with web client v 1.7.11" on August 2nd by a 3rd party.
Kind regards, Mark Abajian
We ran into an issue back in January and submitted a ticket to the ACT HelpDesk (ACT-177). This is essentially a copy of that ticket.
Here is our problem... Any query that takes longer than 60 seconds is "cancelled" by the webclient with the message "QUERY CANCELLED".
But the query continues to run on the i2b2 server, and I do not believe that it is moved out of the default queue. It is simply running longer than one minute, but eventually completes.
Risk: The risk is that most users will believe that their query is cancelled. And some will re-try their queries, overtaxing the system. Others will forget about their queries, and this will give our service a black eye.
Analysis: I can't tell if the server is returning some flag to the weblicent, and that is why the webclient is presenting the Query Cancelled message in the Query Status panel, or if the webclient is just "timing out" because it has not received a reply within 60 seconds. But my hunch is that this is a webclient issue; I'm not an expert.
We also find that if we wait long enough, the query results will show up in the Previous Queries panel.
We are unable to locate any remedy for this in the i2b2 documentation or configuration files.
Two questions:
1. Is there a setting we can change in our i2b2 web client or CRC cell so that queries do not time out like this in 60 seconds?
2. Is there a bug in our web client or in the CRC cell, where it reports the query was cancelled, even though it finally goes through to completion?
Please note: This issue was also raised on the i2b2 Install Help Google group with this topic "Problem with CANCELLED queries with web client v 1.7.11" on August 2nd by a 3rd party.
Kind regards, Mark Abajian
