liuxinwang opened a new issue, #27856: URL: https://github.com/apache/doris/issues/27856
### 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 v1.2.1 ### What's Wrong? be异常退出， be.out日志 `*** Query id: 6929f2537a9843f2-8954dafc08e790af *** *** Aborted at 1701349026 (unix time) try "date -d @1701349026" if you are using GNU date *** *** Current BE git commitID: Unknown *** *** SIGSEGV address not mapped to object (@0x0) received by PID 11741 (TID 0x7fa11f9da700) from PID 0; stack trace: *** 0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /root/doris/be/src/common/signal_handler.h:420 1# os::Linux::chained_handler(int, siginfo*, void*) in /usr/local/jdk/jre/lib/amd64/server/libjvm.so 2# JVM_handle_linux_signal in /usr/local/jdk/jre/lib/amd64/server/libjvm.so 3# signalHandler(int, siginfo*, void*) in /usr/local/jdk/jre/lib/amd64/server/libjvm.so 4# 0x00007FA1B43F9400 in /lib64/libc.so.6 5# je_arena_dalloc_promoted at ../src/arena.c:1604 6# __pthread_create_2_1 in /lib64/libpthread.so.0 7# std::thread::_M_start_thread(std::unique_ptr<std::thread::_State, std::default_delete<std::thread::_State> >, void (*)()) in /home/doris/apache-doris-be-1.2.1-bin-x86_64/lib/doris_be 8# doris::vectorized::VJoinNodeBase::open(doris::RuntimeState*) at /root/doris/be/src/vec/exec/join/vjoin_node_base.cpp:179 9# doris::vectorized::HashJoinNode::open(doris::RuntimeState*) at /root/doris/be/src/vec/exec/join/vhash_join_node.cpp:637 10# doris::vectorized::VJoinNodeBase::_probe_side_open_thread(doris::RuntimeState*, std::promise<doris::Status>*) at /root/doris/be/src/vec/exec/join/vjoin_node_base.cpp:213 11# std::thread::_State_impl<std::thread::_Invoker<std::tuple<doris::vectorized::VJoinNodeBase::open(doris::RuntimeState*)::{lambda()#1}> > >::_M_run() at /var/local/ldb-toolchain/include/c++/11/bits/std_thread.h:211 12# execute_native_thread_routine in /home/doris/apache-doris-be-1.2.1-bin-x86_64/lib/doris_be 13# start_thread in /lib64/libpthread.so.0 14# clone in /lib64/libc.so.6` fe.audit.log中的query id 的sql： `2023-11-30 20:57:22,150 [query] |Client=172.22.244.2:44091|User=program|Db=ab_report|State=ERR|Time=16277|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=618931|QueryId=6929f2537a9843f2-8954dafc08e790af|IsQuery=true|feIp=172.22.244.1|Stmt=select t1.id, t1.order_no, t1.salesperson_name, t1.created_time as dateTime, t1.sale_type, t1.type, t1.relate_order_id, t1.relate_order_no, t1.relate_order_type, t1.store_id, t2.province_name, concat(t2.province_name, t2.city_name) as cityName, t1.buyer_id, t1.buyer_name, t1.buyer_type, t1.buyer_mobile, if(t1.sale_type = 1, -t1.sell_amount, t1.sell_amount) as sellAmount, t4.origin_type from bi_analyze t1 left join re_info t2 on t1.store_id = t2.id left joinuser t3 on t1.buyer_type = 1 and t1.buyer_id = t3.member_id left join customer_origin t4 on t3.customer_origin_id = t4.id WHERE t1.type in ('016', '018', '1', '2', '5') and t1.store_id in ( 1663840423645138946 ) and t1.created_time <= '2023-11-30 23:59:59.0' and t1.created_time >= '2023-11-30 00:00:00.0' order by t1.created_time desc LIMIT 20 |CpuTimeMS=0|SqlHash=7fda722a02afdbe66f984810da4b3b7b|peakMemoryBytes=0|SqlDigest=|TraceId= 2023-11-30 20:57:22,150 [slow_query] |Client=172.22.244.2:44091|User=program|Db=ab_report|State=ERR|Time=16277|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=618931|QueryId=6929f2537a9843f2-8954dafc08e790af|IsQuery=true|feIp=172.22.244.1|Stmt=select t1.id, t1.order_no, t1.salesperson_name, t1.created_time as dateTime, t1.sale_type, t1.type, t1.relate_order_id, t1.relate_order_no, t1.relate_order_type, t1.store_id, t2.province_name, concat(t2.province_name, t2.city_name) as cityName, t1.buyer_id, t1.buyer_name, t1.buyer_type, t1.buyer_mobile, if(t1.sale_type = 1, -t1.sell_amount, t1.sell_amount) as sellAmount, t4.origin_type from bi_analyze t1 left join re_info t2 on t1.store_id = t2.id left join user t3 on t1.buyer_type = 1 and t1.buyer_id = t3.member_id left join customer_origin t4 on t3.customer_origin_id = t4 .id WHERE t1.type in ('016', '018', '1', '2', '5') and t1.store_id in ( 1663840423645138946 ) and t1.created_time <= '2023-11-30 23:59:59.0' and t1.created_time >= '2023-11-30 00:00:00.0' order by t1.created_time desc LIMIT 20 |CpuTimeMS=0|SqlHash=7fda722a02afdbe66f984810da4b3b7b|peakMemoryBytes=0|SqlDigest=|TraceId=` ### What You Expected? be 异常退出的具体原因和解决办法 ### How to Reproduce? _No response_ ### 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]
