AlenZhai opened a new issue, #33815: URL: https://github.com/apache/doris/issues/33815
### 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 2.0.0 ### What's Wrong? 当我通过doris查询Hive的一张表时没有查询出数据,be并且自动退出了 ### What You Expected? 找到自动退出的原因 ### How to Reproduce? 两台FE 三台BE 当使用doris查询外部署Hive表时其中一个be自动退出 查询语句如下 `select * from hive.stg_xx.stg_his_xx_d where day='2024-04-15' and mradm_adm_dr='23635747'` ### be.INF.log I0417 13:34:33.770972 3291 merger.cpp:343] Start to do vertical compaction, tablet_id: 3642020 I0417 13:34:33.786772 3291 compaction.cpp:475] succeed to do cumulative compaction is_vertical=1. tablet=3642020.1099949211.594fd11d3b2202d9-f75392ab524e8ab7, output_version=[36077-37077], current_max_version=37077, disk=/data/data/be, segments=3, input_row_num=110, output_row_num=110. elapsed time=0.015946s. cumulative_compaction_policy=size_based, compact_row_per_second=6892 I0417 13:34:34.726950 3434 task_worker_pool.cpp:1044] successfully report TASK|host=10.107.130.27|port=9020 I0417 13:34:35.652838 3605 internal_service.cpp:488] cancel fragment, fragment_instance_id=82e223247f2e45ff-8d76244558e77bb0, reason: USER_CANCEL W0417 13:34:35.652974 3605 status.h:365] meet error status: [CANCELLED] 0. /root/src/doris/be/src/common/stack_trace.cpp:298: StackTrace::tryCapture() @ 0x000000000b36ece7 in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 1. /root/src/doris/be/src/common/stack_trace.h:0: doris::get_stack_trace[abi:cxx11]() @ 0x000000000b36d2bd in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 2. /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:187: doris::Status doris::Status::Error<true>(int, std::basic_string_view<char, std::char_traits<char> >) @ 0x000000000a86c54b in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 3. /root/src/doris/be/src/common/status.h:0: doris::RuntimeState::set_is_cancelled(bool) @ 0x000000000b1e097e in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 4. /root/src/doris/be/src/pipeline/pipeline_fragment_context.cpp:158: doris::pipeline::PipelineFragmentContext::cancel(doris::PPlanFragmentCancelReason const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) @ 0x0000000011aba86a in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 5. /root/src/doris/be/src/runtime/fragment_mgr.cpp:0: doris::FragmentMgr::cancel(doris::TUniqueId const&, doris::PPlanFragmentCancelReason const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) @ 0x000000000b16efe8 in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 6. /root/src/doris/be/src/service/internal_service.cpp:0: std::_Function_handler<void (), doris::PInternalServiceImpl::cancel_plan_fragment(google::protobuf::RpcController*, doris::PCancelPlanFragmentRequest const*, doris::PCancelPlanFragmentResult*, google::protobuf::Closure*)::$_0>::_M_invoke(std::_Any_data const&) @ 0x000000000b2b60d1 in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 7. /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/atomic_base.h:646: doris::WorkThreadPool<false>::work_thread(int) @ 0x000000000b2c6a4b in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 8. /data/gcc-11.1.0/build/x86_64-pc-linux-gnu/libstdc++-v3/include/bits/unique_ptr.h:85: execute_native_thread_routine @ 0x0000000014a24c10 in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 9. start_thread @ 0x0000000000007ea5 in /usr/lib64/libpthread-2.17.so 10. clone @ 0x00000000000fe96d in /usr/lib64/libc-2.17.so I0417 13:34:35.652900 3605 runtime_state.h:167] task is cancelled, st = [CANCELLED] 0. /root/src/doris/be/src/common/stack_trace.cpp:298: StackTrace::tryCapture() @ 0x000000000b36ece7 in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 1. /root/src/doris/be/src/common/stack_trace.h:0: doris::get_stack_trace[abi:cxx11]() @ 0x000000000b36d2bd in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 2. /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:187: doris::Status doris::Status::Error<true>(int, std::basic_string_view<char, std::char_traits<char> >) @ 0x000000000a86c54b in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 3. /root/src/doris/be/src/common/status.h:0: doris::RuntimeState::set_is_cancelled(bool) @ 0x000000000b1e097e in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 4. /root/src/doris/be/src/pipeline/pipeline_fragment_context.cpp:158: doris::pipeline::PipelineFragmentContext::cancel(doris::PPlanFragmentCancelReason const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) @ 0x0000000011aba86a in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 5. /root/src/doris/be/src/runtime/fragment_mgr.cpp:0: doris::FragmentMgr::cancel(doris::TUniqueId const&, doris::PPlanFragmentCancelReason const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) @ 0x000000000b16efe8 in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 6. /root/src/doris/be/src/service/internal_service.cpp:0: std::_Function_handler<void (), doris::PInternalServiceImpl::cancel_plan_fragment(google::protobuf::RpcController*, doris::PCancelPlanFragmentRequest const*, doris::PCancelPlanFragmentResult*, google::protobuf::Closure*)::$_0>::_M_invoke(std::_Any_data const&) @ 0x000000000b2b60d1 in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 7. /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/atomic_base.h:646: doris::WorkThreadPool<false>::work_thread(int) @ 0x000000000b2c6a4b in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 8. /data/gcc-11.1.0/build/x86_64-pc-linux-gnu/libstdc++-v3/include/bits/unique_ptr.h:85: execute_native_thread_routine @ 0x0000000014a24c10 in /data/doris/apache-doris-2.0.0-bin-x64/be/lib/doris_be 9. start_thread @ 0x0000000000007ea5 in /usr/lib64/libpthread-2.17.so 10. clone @ 0x00000000000fe96d in /usr/lib64/libc-2.17.so W0417 13:34:35.653069 3605 pipeline_fragment_context.cpp:158] PipelineFragmentContext Canceled. reason= I0417 13:34:38.405711 3335 lru_cache_policy.h:69] PKIndexPageCache prune stale 0 entries, 0 bytes, 38371 times prune ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] 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]
