为了更快的定位您的问题,请提供以下信息,谢谢
【详述】
【背景】
-
创建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”
); -
创建成功后做查询,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::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和内存使用率截图
- 查询报错:
- query_dump,怎么获取query_dump文件
- be crash
- be.out
- 外表查询报错
- be.out和fe.warn.log