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

Duration of completed queries is continuously increasing

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.13.0
    • Fix Version/s: 1.13.0
    • Component/s: None
    • Labels:

      Description

      Steps:
      1. Execute some query (for example "select * from sys.version")
      2. Go to the profiles page: http://node1:8047/profiles
      3. Open the details page for the query
      4. Expand the duration section

      Expected result:
      The duration should be adequate and shouldn't be changed after the page reload

      Actual result:
      The duration is continuously increasing (You should reload page to notice that)

      Planning Queued Execution Total
      0.092 sec 0.012 sec 59 min 36.487 sec 59 min 36.591 sec

      Workaround: none

      Note:
      The issue introduced after the following fix:
      https://issues.apache.org/jira/browse/DRILL-5963

      ROOT CAUSE
      After refactoring made in DRILL-5963 making query start / queue / end time was moved to another abstraction queryStateProcessor. On Foreman close queryStateProcessor was closed after final query profile was stored thus query end time was never updated. To fix this issue we need to close queryStateProcessor before writing query final profile.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                angozhiy Anton Gozhiy
                Reviewer:
                Paul Rogers
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: