huiwenhan opened a new issue, #20925: URL: https://github.com/apache/doris/issues/20925
### 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 1.2.4 ### What's Wrong? BE crash. the log as following : start time: Fri Jun 16 19:32:29 CST 2023 *** Query id: b3836b4533e24ef0-8de055b50eca017e *** *** Aborted at 1686915321 (unix time) try "date -d @1686915321" if you are using GNU date *** *** Current BE git commitID: Unknown *** *** SIGSEGV address not mapped to object (@0x55df90d99c) received by PID 97290 (TID 0x7ff741fca700) from PID 18446744073165396380; 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 /opt/jdk8/jre/lib/amd64/server/libjvm.so 2# JVM_handle_linux_signal in /opt/jdk8/jre/lib/amd64/server/libjvm.so 3# signalHandler(int, siginfo*, void*) in /opt/jdk8/jre/lib/amd64/server/libjvm.so 4# 0x00007FF83C1EC400 in /lib64/libc.so.6 5# doris::vectorized::ColumnNullable::compare_at(unsigned long, unsigned long, doris::vectorized::IColumn const&, int) const at /root/doris/be/src/vec/columns/column_nullable.cpp:340 6# doris::vectorized::GenericComparisonImpl<doris::vectorized::GreaterOp<int, int> >::vector_constant(doris::vectorized::IColumn const&, doris::vectorized::IColumn const&, doris::vectorized::PODArray<unsigned char, 4096ul, Allocator<false, false>, 15ul, 16ul>&) at /root/doris/be/src/vec/functions/functions_comparison.h:117 7# doris::vectorized::FunctionComparison<doris::vectorized::GreaterOp, doris::vectorized::NameGreater>::execute_impl(doris_udf::FunctionContext*, doris::vectorized::Block&, std::vector<unsigned long, std::allocator<unsigned long> > const&, unsigned long, unsigned long) at /root/doris/be/src/vec/functions/functions_comparison.h:423 8# doris::vectorized::PreparedFunctionImpl::execute_without_low_cardinality_columns(doris_udf::FunctionContext*, doris::vectorized::Block&, std::vector<unsigned long, std::allocator<unsigned long> > const&, unsigned long, unsigned long, bool) at /root/doris/be/src/vec/functions/function.cpp:244 9# doris::vectorized::PreparedFunctionImpl::execute(doris_udf::FunctionContext*, doris::vectorized::Block&, std::vector<unsigned long, std::allocator<unsigned long> > const&, unsigned long, unsigned long, bool) at /root/doris/be/src/vec/functions/function.cpp:267 10# doris::vectorized::IFunctionBase::execute(doris_udf::FunctionContext*, doris::vectorized::Block&, std::vector<unsigned long, std::allocator<unsigned long> > const&, unsigned long, unsigned long, bool) at /root/doris/be/src/vec/functions/function.h:154 11# doris::vectorized::VectorizedFnCall::execute(doris::vectorized::VExprContext*, doris::vectorized::Block*, int*) at /root/doris/be/src/vec/exprs/vectorized_fn_call.cpp:109 12# doris::vectorized::VExprContext::filter_block(doris::vectorized::VExprContext*, doris::vectorized::Block*, int) at /root/doris/be/src/vec/exprs/vexpr_context.cpp:126 13# doris::vectorized::VScanner::get_block(doris::RuntimeState*, doris::vectorized::Block*, bool*) at /root/doris/be/src/vec/exec/scan/vscanner.cpp:68 14# doris::vectorized::ScannerScheduler::_scanner_scan(doris::vectorized::ScannerScheduler*, doris::vectorized::ScannerContext*, doris::vectorized::VScanner*) at /root/doris/be/src/vec/exec/scan/scanner_scheduler.cpp:247 15# doris::PriorityWorkStealingThreadPool::work_thread(int) at /root/doris/be/src/util/priority_work_stealing_thread_pool.hpp:136 16# execute_native_thread_routine in /opt/doris/lib/doris_be 17# start_thread in /lib64/libpthread.so.0 18# clone in /lib64/libc.so.6 ### What You Expected? Fixed the issue or given suggestion ### How to Reproduce? SELECT sap_ord, ecc_sap_ord, address, update_date, max(UPDATE_DATE) over(PARTITION BY sap_ord, ecc_sap_ord) AS latest_update ^M FROM sci_idl.idp_transtatus_qcly^M where multi_match_any(ecc_sap_ord,['*1009505988*' , '*1009506066*' , '*1009506075*' , '*1009505974*' , '*1009506080*' ,'*1009505996*' , '*1009506076*' , '*1009506057*' , '*1009506064*' , '*1009505965*' , '*1009506061*']) > 0 LIMIT 0, 200 run the above SQL ### 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
