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

Crash: impala::BufferedTupleStream::rows_returned

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Duplicate
    • Impala 2.3.0
    • None
    • None

    Description

      Query:

      use random_nested_db_0;
      SELECT
      COALESCE(LEAD(COALESCE(-948, -836), 43) OVER (ORDER BY COALESCE(t9.int_col_t4, t10.field_10.field_13, t11.field_16) DESC), LAG(202, 59) OVER (ORDER BY COALESCE(t9.int_col_t4, t10.field_10.field_13, t11.field_16)), COALESCE(479, NULL, 651)) AS int_col,
      COALESCE(t9.int_col_t4, t10.field_10.field_13, t11.field_16) AS int_col_t12
      FROM (
      SELECT DISTINCT
      COALESCE(t1.pos, t2.value, t1.pos) AS int_col,
      COALESCE(t2.value, t1.pos, t1.pos) AS int_col_t4
      FROM table_3.field_88.value t1
      LEFT JOIN table_3.field_90.field_92.value t2 ON ((t2.value) = (t1.pos)) AND ((t2.value) = (t1.pos))
      LEFT JOIN t1.item t3
      UNION ALL
      SELECT
      (673.207169409) / (t5.pos) AS float_col,
      ABS(836.211809943) AS float_col_t6
      FROM table_1.field_19.value t5
      UNION ALL
      SELECT
      LAG(((-371.351014454) / (761)) * (-604), 45) OVER (ORDER BY t8.pos DESC, t7.pos) AS float_col,
      COALESCE(-940, -382, COALESCE(LEAST(COALESCE(LAG(821, 77) OVER (ORDER BY t8.item ASC, t8.pos DESC), 497), -903), 986)) AS int_col
      FROM table_3.field_88.value t7
      LEFT JOIN table_1.field_19.value.item.field_21.item t8 ON ((t8.pos) = (t7.pos)) AND ((t8.pos) = (t7.pos))
      WHERE
      (t8.pos) = (t7.pos)
      ) t9
      LEFT JOIN table_0 t10 ON ((t10.field_10.field_13) = (t9.int_col_t4)) AND ((t10.field_5) = (t9.int_col))
      INNER JOIN table_0 t11 ON ((t11.field_16) = (t9.int_col_t4)) AND ((t11.field_5) = (t9.int_col_t4))
      

      Stack Trace:

      #0  0x00007fc539d95cc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
      #1  0x00007fc539d990d8 in __GI_abort () at abort.c:89
      #2  0x00007fc53b9a89c5 in os::abort(bool) () from /usr/lib/jvm/java-7-oracle/jre/lib/amd64/server/libjvm.so
      #3  0x00007fc53bb29607 in VMError::report_and_die() () from /usr/lib/jvm/java-7-oracle/jre/lib/amd64/server/libjvm.so
      #4  0x00007fc53b9ad8af in JVM_handle_linux_signal () from /usr/lib/jvm/java-7-oracle/jre/lib/amd64/server/libjvm.so
      #5  <signal handler called>
      #6  0x00000000016cf380 in impala::BufferedTupleStream::rows_returned (this=0x0) at /home/dev/Impala/be/src/runtime/buffered-tuple-stream.h:234
      #7  0x00000000016fc1e2 in impala::AnalyticEvalNode::GetNext (this=0xe63a700, state=0xcb7cd00, row_batch=0x7fc480e9bd10, eos=0x7fc480e9bcff) at /home/dev/Impala/be/src/exec/analytic-eval-node.cc:752
      #8  0x00000000016e0e73 in impala::SortNode::SortInput (this=0xf04bc00, state=0xcb7cd00) at /home/dev/Impala/be/src/exec/sort-node.cc:155
      #9  0x00000000016e034c in impala::SortNode::Open (this=0xf04bc00, state=0xcb7cd00) at /home/dev/Impala/be/src/exec/sort-node.cc:76
      #10 0x00000000016f8740 in impala::AnalyticEvalNode::Open (this=0xe63a380, state=0xcb7cd00) at /home/dev/Impala/be/src/exec/analytic-eval-node.cc:180
      #11 0x000000000159d3a8 in impala::PlanFragmentExecutor::OpenInternal (this=0xcb7bd28) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:334
      #12 0x000000000159d1a8 in impala::PlanFragmentExecutor::Open (this=0xcb7bd28) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:320
      #13 0x00000000013814fc in impala::FragmentMgr::FragmentExecState::Exec (this=0xcb7bb00) at /home/dev/Impala/be/src/service/fragment-exec-state.cc:50
      #14 0x000000000137a03b in impala::FragmentMgr::FragmentExecThread (this=0xda61020, exec_state=0xcb7bb00) at /home/dev/Impala/be/src/service/fragment-mgr.cc:83
      #15 0x000000000137d846 in boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>::operator() (this=0xe6322c0, p=0xda61020, a1=0xcb7bb00) at /usr/include/boost/bind/mem_fn_template.hpp:165
      #16 0x000000000137d609 in boost::_bi::list2<boost::_bi::value<impala::FragmentMgr*>, boost::_bi::value<impala::FragmentMgr::FragmentExecState*> >::operator()<boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>, boost::_bi::list0> (this=0xe6322d0, f=..., a=...) at /usr/include/boost/bind/bind.hpp:313
      #17 0x000000000137cf23 in boost::_bi::bind_t<void, boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>, boost::_bi::list2<boost::_bi::value<impala::FragmentMgr*>, boost::_bi::value<impala::FragmentMgr::FragmentExecState*> > >::operator() (this=0xe6322c0) at /usr/include/boost/bind/bind_template.hpp:20
      #18 0x000000000137c878 in boost::detail::function::void_function_obj_invoker0<boost::_bi::bind_t<void, boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>, boost::_bi::list2<boost::_bi::value<impala::FragmentMgr*>, boost::_bi::value<impala::FragmentMgr::FragmentExecState*> > >, void>::invoke (function_obj_ptr=...) at /usr/include/boost/function/function_template.hpp:153
      #19 0x000000000124a744 in boost::function0<void>::operator() (this=0x7fc480e9ce00) at /usr/include/boost/function/function_template.hpp:767
      #20 0x000000000145ba8d in impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*) (name=..., category=..., functor=..., thread_started=0x7fc485f25dd0) at /home/dev/Impala/be/src/util/thread.cc:314
      #21 0x0000000001464cc3 in boost::_bi::list4<boost::_bi::value<std::string>, boost::_bi::value<std::string>, boost::_bi::value<boost::function<void ()> >, boost::_bi::value<impala::Promise<long>*> >::operator()<void (*)(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*), boost::_bi::list0>(boost::_bi::type<void>, void (*&)(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*), boost::_bi::list0&, int) (this=0xf04b3c0, f=@0xf04b3b8: 0x145b784 <impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*)>, a=...) at /usr/include/boost/bind/bind.hpp:457
      #22 0x0000000001464c0d in boost::_bi::bind_t<void, void (*)(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*), boost::_bi::list4<boost::_bi::value<std::string>, boost::_bi::value<std::string>, boost::_bi::value<boost::function<void ()> >, boost::_bi::value<impala::Promise<long>*> > >::operator()() (this=0xf04b3b8) at /usr/include/boost/bind/bind_template.hpp:20
      #23 0x0000000001464bd2 in boost::detail::thread_data<boost::_bi::bind_t<void, void (*)(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*), boost::_bi::list4<boost::_bi::value<std::string>, boost::_bi::value<std::string>, boost::_bi::value<boost::function<void ()> >, boost::_bi::value<impala::Promise<long>*> > > >::run() (this=0xf04b200) at /usr/include/boost/thread/detail/thread.hpp:117
      #24 0x00007fc53cd5fa4a in ?? () from /usr/lib/x86_64-linux-gnu/libboost_thread.so.1.54.0
      #25 0x00007fc53c20c182 in start_thread (arg=0x7fc480e9d700) at pthread_create.c:312
      #26 0x00007fc539e5947d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      To access the machine with loaded data:

      ssh vd0206.halxg.cloudera.com
      ssh dev@192.168.123.64   # pw = cloudera
      cd Impala  # proceed as usual
      

      Attachments

        Activity

          People

            alex.behm Alexander Behm
            tarasbob Taras Bobrovytsky
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: