Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6693

When a query is started from Drill Web Console, the UI becomes inaccessible until the query is completed

    XMLWordPrintableJSON

    Details

    • 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:

      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.

        Attachments

        1. jstack.txt
          114 kB
          Anton Gozhiy

          Issue Links

            Activity

              People

              • Assignee:
                vrozov Vlad Rozov
                Reporter:
                angozhiy Anton Gozhiy
                Reviewer:
                Arina Ielchiieva
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: