查询sql导致be挂了

💬 StarRocks 用户问答 功能使用相关
#1

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】
查询sql：SELECT CONCAT(query_data_file_csv.string_01, ‘test’) AS re FROM dte_hive_catalog._default.ry_data_file_csv_173404fd070550f1f9ea435d36d98ec2 AS query_data_file_csv WHERE query_data_file_csv.string_01 = ‘string00’
导致be挂了，'test’是个常量，string_01是个varchar类型的字段

【背景】做过哪些操作？
【业务影响】
【是否存算分离】
【StarRocks版本】3.2.0
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】

  • fe.log/beINFO/相应截图

  • 慢查询：

    • Profile信息
    • 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
    • pipeline是否开启：show variables like ‘%pipeline%’;
    • be节点cpu和内存使用率截图

  • 查询报错：

  • be crash

    • be.out

  • 外表查询报错

    • be.out和fe.warn.log
#2

tracker:page_cache consumption: 6752614656
tracker:update consumption: 362900259
tracker:chunk_allocator consumption: 537050736
tracker:clone consumption: 0
tracker:consistency consumption: 0
*** Aborted at 1736489706 (unix time) try “date -d 1736489706” if you are using GNU date ***
PC: 0x55208d5 (unknown)
*** SIGSEGV (0x7f21e63d8000) received by PID 2299939 (TID 0x7f249e581640) from PID 18446744073277374464; stack trace: ***
0x5b84f22 (unknown)
0x7f252e499bad os::Linux::chained_handler()
0x7f252e4a1d0e JVM_handle_linux_signal
0x7f252e490867 signalHandler()
0x7f252d7180b0 (unknown)
0x55208d5 (unknown)
0x555952f starrocks::string_func_const<>()
0x554151d starrocks::StringFunctions::concat()
0x47ccd74 starrocks::VectorizedFunctionCallExpr::evaluate_checked()
0x3f5e3f3 starrocks::ExprContext::evaluate()
0x3f5e73f starrocks::ExprContext::evaluate()
0x323b264 starrocks::pipeline::ProjectOperator::push_chunk()
0x32e0c68 starrocks::pipeline::PipelineDriver::process()
0x32d1b2e starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
0x2926752 starrocks::ThreadPool::dispatch_thread()
0x292130a starrocks::thread::supervise_thread()
0x7f252d76281a (unknown)
0x7f252d7e5110 (unknown)
0x0 (unknown)
Backend process 2299939 is not running. Removing pidfile.
start time: Fri Jan 10 02:18:39 PM CST 2025
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/oss/rtsp/NdpStarRocksComponent-25.450.407-euler_amd64/be/lib/jni-packages/starrocks-jdbc-bridge-jar-with-dependencies.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/oss/rtsp/NdpStarRocksComponent-25.450.407-euler_amd64/be/lib/hadoop/common/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
OpenJDK 64-Bit Server VM warning: You have loaded library /opt/oss/rtsp/NdpStarRocksComponent-25.450.407-euler_amd64/be/lib/hadoop/native/libhadoop.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It’s highly recommended that you fix the library with 'execstack -c ', or link it with ‘-z noexecstack’.

#3

可以考虑升级到3.2.11+

#4

这个物化视图导致的字段错位的问题，有相关的PR修复吗？

京ICP备2022026421号-1