创建EXTERNAL CATALOG成功,但是做简单查询后BE宕机

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】

【背景】

  1. 创建EXTERNAL CATALOG:
    CREATE EXTERNAL CATALOG jdbc_catalog_test
    PROPERTIES
    (
    “type”=“jdbc”,
    “user”=“root”,
    “password”=“xxxxxx”,
    “jdbc_uri”=“jdbc:mysql://127.0.0.1:3607”,
    “driver_url”=“file:///home/xxx/repository/com/mysql/mysql-connector-j/8.0.33/mysql-connector-j-8.0.33.jar”,
    “driver_class”=“com.mysql.cj.jdbc.Driver”
    );

  2. 创建成功后做查询,BE直接挂掉:


    【业务影响】
    【是否存算分离】否
    【StarRocks版本】3.1.10
    【集群规模】单机
    【机器信息】
    【联系方式】
    【附件】
    be.out:
    *** SIGSEGV (@0x0) received by PID 2441867 (TID 0x7f28410b8700) from PID 0; stack trace: ***
    @ 0x62b81e2 google::(anonymous namespace)::FailureSignalHandler()
    @ 0x7f294e57b711 PosixSignals::chained_handler()
    @ 0x7f294e57c2ce JVM_handle_linux_signal
    @ 0x7f294d6235a0 (unknown)
    @ 0x7f294d8d9205 AccessInternal::PostRuntimeDispatch<>::oop_access_barrier()
    @ 0x7f294e042041 jni_RegisterNatives
    @ 0x575c8fa starrocks::JVMFunctionHelper::_init()
    @ 0x575d727 starrocks::JVMFunctionHelper::getInstance()
    @ 0x59beedf starrocks::JDBCScanner::_init_jdbc_bridge()
    @ 0x59c0b48 starrocks::JDBCScanner::open()
    @ 0x594e4cd starrocks::connector::JDBCDataSource::_create_scanner()
    @ 0x594f07f starrocks::connector::JDBCDataSource::open()
    @ 0x34b66d1 starrocks::pipeline::ConnectorChunkSource::_open_data_source()
    @ 0x34b7748 starrocks::pipeline::ConnectorChunkSource::_read_chunk()
    @ 0x37e2627 starrocks::pipeline::ChunkSource::buffer_next_batch_chunks_blocking()
    @ 0x34a968d _ZZN9starrocks8pipeline12ScanOperator18_trigger_next_scanEPNS_12RuntimeStateEiENKUlvE_clEv
    @ 0x35b90f1 starrocks::workgroup::ScanExecutor::worker_thread()
    @ 0x2bb0b8c starrocks::ThreadPool::dispatch_thread()
    @ 0x2baa71a starrocks::thread::supervise_thread()
    @ 0x7f294d618f3b (unknown)
    @ 0x7f294d3a2840 clone
    @ 0x0 (unknown)

  • 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

兄弟,请问你解决了吗