big-doudou opened a new issue, #23996: URL: https://github.com/apache/doris/issues/23996
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version Version : 1.1.3-rc02 ### What's Wrong? When I execute the sql, it returns an error: 1105 - RpcException, msg: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason, Time: 3.122000s (gdb) p (materialize_expr_ctxs._M_impl._M_start)[7] $25 = (doris::ExprContext *) 0x0 this is a null pointer exception? (gdb) bt #0 get_value (row=0x55ee3ea5a000, this=0x55ed81e96af0) at /mnt/disk2/ygl/code/github/apache-doris/be/src/exprs/expr.h:135 #1 doris::Tuple::materialize_exprs<false> (this=this@entry=0x55edc1d67070, row=row@entry=0x55ee3ea5a000, desc=..., materialize_expr_ctxs=..., pool=pool@entry=0x55f10354f6d0, non_null_var_len_values=non_null_var_len_values@entry=0x0, total_var_len=0x0) at /mnt/disk2/ygl/code/github/apache-doris/be/src/runtime/tuple.cpp:294 #2 0x000055ed28532f33 in doris::TopNNode::insert_tuple_row(doris::TupleRow*) () at /mnt/disk2/ygl/code/github/apache-doris/be/src/exec/sort_exec_exprs.h:57 #3 0x000055ed28535cff in doris::TopNNode::open(doris::RuntimeState*) () at /mnt/disk2/ygl/code/github/apache-doris/be/src/runtime/row_batch.h:177 #4 0x000055ed27ee8ce7 in doris::PlanFragmentExecutor::open_internal() () at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/bits/unique_ptr.h:421 #5 0x000055ed27eea0c5 in doris::PlanFragmentExecutor::open() () at /mnt/disk2/ygl/code/github/apache-doris/be/src/runtime/plan_fragment_executor.cpp:261 #6 0x000055ed27e59d2f in doris::FragmentExecState::execute() () at /mnt/disk2/ygl/code/github/apache-doris/be/src/runtime/fragment_mgr.cpp:248 #7 0x000055ed27e5e8ca in doris::FragmentMgr::_exec_actual(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>) () at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/bits/shared_ptr_base.h:1290 #8 0x000055ed27e67bbc in __invoke_impl<void, void (doris::FragmentMgr::*&)(std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>), doris::FragmentMgr*&, std::shared_ptr<doris::FragmentExecState>&, std::function<void(doris::PlanFragmentExecutor*)>&> (__f= @0x55edf82185a0: (void (doris::FragmentMgr::*)(doris::FragmentMgr * const, std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>)) 0x55ed27e5e380 <doris::FragmentMgr::_exec_actual(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>)>, __t=@0x55edf82185e0: 0x55ed2f2d0000, __f= @0x55edf82185a0: (void (doris::FragmentMgr::*)(doris::FragmentMgr * const, std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>)) 0x55ed27e5e380 <doris::FragmentMgr::_exec_actual(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>)>, __t=@0x55edf82185e0: 0x55ed2f2d0000) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/ext/atomicity.h:109 #9 __invoke_r<void, void (doris::FragmentMgr::*&)(std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>), doris::FragmentMgr*&, std::shared_ptr<doris::FragmentExecState>&, std::function<void(doris::PlanFragmentExecutor*)>&> (__fn= @0x55edf82185a0: (void (doris::FragmentMgr::*)(doris::FragmentMgr * const, std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>)) 0x55ed27e5e380 <doris::FragmentMgr::_exec_actual(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>)>) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/bits/invoke.h:111 #10 __call<void, 0, 1, 2> (__args=<optimized out>, this=0x55edf82185a0) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/functional:570 #11 operator()<> (this=0x55edf82185a0) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/functional:629 #12 __invoke_impl<void, std::_Bind_result<void, void (doris::FragmentMgr::*(doris::FragmentMgr*, std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>))(std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>)>&> (__f=...) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/bits/invoke.h:61 #13 __invoke_r<void, std::_Bind_result<void, void (doris::FragmentMgr::*(doris::FragmentMgr*, std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>))(std::shared_ptr<doris::FragmentExecState>, std::function<void(doris::PlanFragmentExecutor*)>)>&> (__fn=...) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/bits/invoke.h:111 #14 std::_Function_handler<void (), std::_Bind_result<void, void (doris::FragmentMgr::*(doris::FragmentMgr*, std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>))(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>)> >::_M_invoke(std::_Any_data const&) (__functor=...) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/bits/std_function.h:291 #15 0x000055ed280201fb in operator() (this=0x55f070cb2418) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/bits/std_function.h:556 #16 run (this=0x55f070cb2410) at /mnt/disk2/ygl/code/github/apache-doris/be/src/util/threadpool.cpp:42 #17 doris::ThreadPool::dispatch_thread() () at /mnt/disk2/ygl/code/github/apache-doris/be/src/util/threadpool.cpp:570 #18 0x000055ed280197ff in operator() (this=0x55ee06757a58) at /mnt/disk2/ygl/installs/ldbtools/include/c++/11/bits/std_function.h:556 #19 doris::Thread::supervise_thread(void*) () at /mnt/disk2/ygl/code/github/apache-doris/be/src/util/thread.cpp:406 #20 0x00007fc531d5aea5 in start_thread () from /lib64/libpthread.so.0 #21 0x00007fc53206db0d in clone () from /lib64/libc.so.6 (gdb) f 0 #0 get_value (row=0x55ee3ea5a000, this=0x55ed81e96af0) at /mnt/disk2/ygl/code/github/apache-doris/be/src/exprs/expr.h:135 135 /mnt/disk2/ygl/code/github/apache-doris/be/src/exprs/expr.h: No such file or directory. (gdb) f 1 #1 doris::Tuple::materialize_exprs<false> (this=this@entry=0x55edc1d67070, row=row@entry=0x55ee3ea5a000, desc=..., materialize_expr_ctxs=..., pool=pool@entry=0x55f10354f6d0, non_null_var_len_values=non_null_var_len_values@entry=0x0, total_var_len=0x0) at /mnt/disk2/ygl/code/github/apache-doris/be/src/runtime/tuple.cpp:294 294 /mnt/disk2/ygl/code/github/apache-doris/be/src/runtime/tuple.cpp: No such file or directory. (gdb) p (materialize_expr_ctxs._M_impl._M_start)[0] $24 = (doris::ExprContext *) 0x55ee31731880 (gdb) p (materialize_expr_ctxs._M_impl._M_start)[7] $25 = (doris::ExprContext *) 0x0 (gdb) p (materialize_expr_ctxs._M_impl._M_start)[8] $26 = (doris::ExprContext *) 0x55ed00000000 (gdb) p (materialize_expr_ctxs._M_impl._M_start)[1] $27 = (doris::ExprContext *) 0x55ee317317a0 ### What You Expected? why null point? ### How to Reproduce? When I execute the online cluster, the error comes up 100% of the time. error clustering： 9 BE 3 replication But I've built a new cluster using the same release. 1 BE 1 replication imported partial data.The mistake didn't happen. SELECT t1.a, t1.c, t1.d, t1.e FROM ( SELECT a AS a, b AS b, IFNULL(sum(c), 0) AS c, IFNULL(sum(d), 0) AS d, IFNULL(sum(e), 0) AS e FROM ( SELECT a, b, sum(c), sum(d), sum(e) FROM tableA WHERE create_date = '2023-09-06' GROUP BY a, b ) today FULL OUTER JOIN ( SELECT a, b, sum(c), sum(d), sum(e) FROM tableA WHERE create_date = '2023-09-06' GROUP BY a, b, sum(c), sum(d), sum(e) ) yesday ON today.a = yesday.a AND today.b = yesday.b FULL OUTER JOIN ( SELECT a, b FROM tableA WHERE create_date = '2023-09-06' GROUP BY a, b ) lasday ON today.a = lasday.a AND today.b = lasday.b GROUP BY a ORDER BY GREATEST(abs(c - d), abs(c - e)) DESC LIMIT 100 ) t1 LEFT JOIN ( SELECT * FROM tableB ) t2 ON t1.a = t2.a ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
