【详述】使用3.0版本的StarRocks中的JDBC Catalog，从一个StarRocks集群（本地集群）连接另外一个StarRocks集群（远程集群），在查询远程集群的表数据时，本地集群的BE节点挂掉，BE日志报错：
W0509 17:00:20.409588 12654 exec_state_reporter.cpp:142] Retrying ReportExecStatus: No more data to read.
W0509 17:00:23.504143 12654 exec_state_reporter.cpp:142] Retrying ReportExecStatus: No more data to read.
W0509 17:00:28.954043 12654 exec_state_reporter.cpp:142] Retrying ReportExecStatus: No more data to read.
W0509 17:00:28.964571 12673 pipeline_driver.cpp:272] pull_chunk returns not ok status Runtime error: env ‘JAVA_HOME’ is not set
/build/starrocks/be/src/exec/jdbc_scanner.cpp:43 detect_java_runtime()
/build/starrocks/be/src/connector/jdbc_connector.cpp:146 _scanner->open(state)
/build/starrocks/be/src/connector/jdbc_connector.cpp:80 _create_scanner(state)
/build/starrocks/be/src/exec/pipeline/scan/connector_scan_operator.cpp:202 _data_source->open(state)
/build/starrocks/be/src/exec/pipeline/scan/scan_operator.cpp:216 _get_scan_status()
W0509 17:00:28.964637 12673 pipeline_driver_executor.cpp:165] [Driver] Process error, query_id=f204c1f1-ee47-11ed-a768-4669f2d9efad, instance_id=f204c1f1-ee47-11ed-a768-4669f2d9efae, status=Runtime error: env ‘JAVA_HOME’ is not set
/build/starrocks/be/src/exec/jdbc_scanner.cpp:43 detect_java_runtime()
/build/starrocks/be/src/connector/jdbc_connector.cpp:146 _scanner->open(state)
/build/starrocks/be/src/connector/jdbc_connector.cpp:80 _create_scanner(state)
/build/starrocks/be/src/exec/pipeline/scan/connector_scan_operator.cpp:202 _data_source->open(state)
/build/starrocks/be/src/exec/pipeline/scan/scan_operator.cpp:216 _get_scan_status()
【操作】
建立Catalog：
CREATE EXTERNAL CATALOG sr344
PROPERTIES
(
“type”=“jdbc”,
“user”=“root”,
“password”=“密码”,
“jdbc_uri”=“jdbc:mysql://IP:9030”,
“driver_url”=“file:///opt/StarRocks-3.0.0/fe/lib/mysql-connector-java-8.0.28.jar”,
“driver_class”=“com.mysql.cj.jdbc.Driver”
);
select COUNT(*) from sr344.DB.ORDER;
【业务影响】集群挂掉，无法继续业务
【StarRocks版本】3.0.0
【联系方式】社区群1-数据小黑