查询一条sql，第一次查询可以成功，第二次查询be直接挂掉，内存无异常。
be.WARNING.log.20221025-075147 (3.0 KB)
be.out (2.7 KB)
f3effe28-64d0-11ed-9025-82c30e6d63df 到fe.audit.log里面搜索一下这个query id，然后发下sql文本。用的什么版本？
用的最新的2.4版本
好的，麻烦按上述方法找下sql发过来我们看看
好的我们跟进一下这个问题
又出现一条sql和这个情况一样，一查BE就挂了，同样的sql在mysql库里查无问题
发下sql文本，同类型的查询吗？堆栈一样吗？不一样的话发下be.out
https://github.com/StarRocks/starrocks/commit/260377ce0c520f1ee66fa9c248f44d45a27f8c47
已修复
2.4.2会有这个修复。
Java UDF Open Crash
*** SIGSEGV (@0x0) received by PID 1340 (TID 0x7f2266f5c700) from PID 0; stack trace: ***
@ 0x481e332 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7f22c7900d45 os::Linux::chained_handler()
@ 0x7f22c7905b61 JVM_handle_linux_signal
@ 0x7f22c78f8a48 signalHandler()
@ 0x7f22c6daf630 (unknown)
@ 0x7f22c7af43f0 (unknown)
@ 0x7f22c765d03b java_lang_String::create_from_str()
@ 0x7f22c765d0c1 java_lang_String::create_oop_from_str()
@ 0x7f22c76c1a52 jni_NewStringUTF
@ 0x3b9e524 starrocks::vectorized::ClassLoader::init()
@ 0x3a51c61 _ZZN9starrocks10vectorized20JavaFunctionCallExpr4openEPNS_12RuntimeStateEPNS_11ExprContextEN13starrocks_udf15FunctionContext18FunctionStateScopeEENKUlvE_clEv
@ 0x3a52e55 _ZNSt17_Function_handlerIFN9starrocks6StatusEvEZNS0_10vectorized20JavaFunctionCallExpr4openEPNS0_12RuntimeStateEPNS0_11ExprContextEN13starrocks_udf15FunctionContext18FunctionStateScopeEEUlvE_E9_M_invokeERKSt9_Any_data
@ 0x3b959f1 starrocks::call_function_in_pthread()
@ 0x3a54541 starrocks::vectorized::JavaFunctionCallExpr::open()
@ 0x3456240 starrocks::Expr::open()
@ 0x34552dc starrocks::ExprContext::clone()
@ 0x2258e39 starrocks::vectorized::ColumnExprPredicate::_add_expr_ctx()
@ 0x2258f43 starrocks::vectorized::ColumnExprPredicate::ColumnExprPredicate()
@ 0x226e3f5 starrocks::vectorized::PredicateParser::parse_expr_ctx()
@ 0x2bd8e35 starrocks::vectorized::OlapScanConjunctsManager::get_column_predicates()
@ 0x2f6ec41 starrocks::pipeline::OlapChunkSource::_init_reader_params()
@ 0x2f702cb starrocks::pipeline::OlapChunkSource::_init_olap_reader()
@ 0x2f70bb4 starrocks::pipeline::OlapChunkSource::prepare()
@ 0x2e3b8d9 starrocks::pipeline::ScanOperator::_pickup_morsel()
@ 0x2e3bb35 starrocks::pipeline::ScanOperator::_try_to_trigger_next_scan()
@ 0x2e3bd53 starrocks::pipeline::ScanOperator::pull_chunk()
@ 0x2e77eb3 starrocks::pipeline::PipelineDriver::process()
@ 0x2e6e5a3 starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x2680a05 starrocks::ThreadPool::dispatch_thread()
@ 0x267bf2a starrocks::Thread::supervise_thread()
@ 0x7f22c6da7ea5 start_thread
@ 0x7f22c63c296d __clone
- Github Issue: https://github.com/StarRocks/starrocks/issues/13787
- Github Fix PR: https://github.com/StarRocks/starrocks/pull/13788
- 问题版本:
- 2.3.0 ~ 2.3.4
- 2.4.0 ~ 2.4.1
- 修复版本:
- 2.3.5+
- 2.4.2+
- 临时规避方法:
- 方法1: set global enable_column_expr_predicate=false; (会影响查询性能）
- 问题原因:
- 见 issue 描述
这个临时规避方法没有效果，还是会挂
set global enable_column_expr_predicate=false 写错了，
。。。。。。。。。。