Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-4604

Hung query for several hours during end-to-end testing on ubuntu1404 cluster

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Duplicate
    • Impala 2.7.0
    • None
    • Backend

    Description

      From the impalad log, the last entry is:

      09:51:25.582063 25017 coordinator.cc:1410] CancelFragmentInstances() query_id=db409a1bfe8222f4:6afdcdc400000000, tried to cancel 0 fragment instances
      

      The time stamp corresponds to the last time stamp in the jenkins log where this test was being run:

      09:51:25 [gw3] PASSED query_test/test_tpch_queries.py::TestTpchQuery::test_tpch[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: parquet/none-TPC-H: Q18]
      

      From the Query Details page on the CM host, the actual query is:

      select id, cnt
      from functional_parquet.complextypestbl t,
        (select count(item) cnt from t.int_array) v
      order by id
      limit 10
      

      Attaching impalads log, stack traces, and minidump.

      Attachments

        1. 6fee562e-d663-5aac-6e1eea3f-77fd4358.dmp
          2.63 MB
          David Knupp
        2. log.tar.gz
          5.14 MB
          David Knupp
        3. impalad-stacks-full.out
          601 kB
          David Knupp

        Activity

          People

            sailesh Sailesh Mukil
            dknupp David Knupp
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: