[DRILL-6693] When a query is started from Drill Web Console, the UI becomes inaccessible until the query is completed

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0, 1.14.0
• Fix Version/s: 1.15.0
• Component/s: Web Server
• Labels: ready-to-commit
• Assignee: Vlad Rozov
• Reporter: Anton Gozhiy
• Reviewer: Arina Ielchiieva
• Created: 16/Aug/18 16:58
• Updated: 27/Aug/18 08:33
• Resolved: 27/Aug/18 08:33

Description

Steps:

1. From Web UI, run the following query:

   select * 
   from (
       select employee_id, full_name, first_name, last_name, position_id, position_title, store_id, department_id, birth_date, hire_date, salary, supervisor_id, education_level, marital_status, gender, management_role 
       from cp.`employee.json` 
       union
       select employee_id, full_name, first_name, last_name, position_id, position_title, store_id, department_id, birth_date, hire_date, salary, supervisor_id, education_level, marital_status, gender, management_role 
       from cp.`employee.json` 
       union
       select employee_id, full_name, first_name, last_name, position_id, position_title, store_id, department_id, birth_date, hire_date, salary, supervisor_id, education_level, marital_status, gender, management_role
       from cp.`employee.json`)
   where last_name = 'Blumberg'
   

1. While query is running, try open the Profiles page (or any other). If It completes too fast, add some unions to the query above.

Expected result:
Profiles page should be opened. The running query should be listed.

Actual result:
The Web UI hangs until the query completes.

Notes:

• If you open another tab with Web Console, it also stuck when the query is running.
• If the query is started from sqlline, everything is fine.

Issue Links

• is caused by: DRILL-5994 enable configuring number of Jetty acceptors and selectors
• links to: GitHub Pull Request #1440