查询es外部表,报错:Operation timed out after 5002 milliseconds with 0 bytes received

【StarRocks版本】3.1.2
fe.log/fe.warn.log
2023-09-26 19:28:50,615 WARN (starrocks-mysql-nio-pool-35|50799) [Coordinator.getNext():1394] get next fail, need cancel. status errorCode INTERNAL_ERROR Operation timed out after 5002 milliseconds with 0 bytes received, query id: d9c775aa-5c5f-11ee-94c4-b496910e33be
2023-09-26 19:28:50,615 WARN (starrocks-mysql-nio-pool-35|50799) [Coordinator.updateStatus():1374] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: d9c775aa-5c5f-11ee-94c4-b496910e33be, instance id: NaN
2023-09-26 19:28:50,616 WARN (starrocks-mysql-nio-pool-35|50799) [Coordinator.getNext():1420] query failed: Operation timed out after 5002 milliseconds with 0 bytes received
2023-09-26 19:28:50,622 WARN (thrift-server-pool-50922|51252) [Coordinator.updateFragmentExecStatus():1571] exec state report failed status=errorCode INTERNAL_ERROR Operation timed out after 5002 milliseconds with 0 bytes received, query_id=d9c775aa-5c5f-11ee-94c4-b496910e33be, instance_id=d9c775aa-5c5f-11ee-94c4-b496910e33c5
2023-09-26 19:28:50,626 WARN (thrift-server-pool-50923|51253) [Coordinator.updateFragmentExecStatus():1571] exec state report failed status=errorCode INTERNAL_ERROR Operation timed out after 5002 milliseconds with 0 bytes received, query_id=d9c775aa-5c5f-11ee-94c4-b496910e33be, instance_id=d9c775aa-5c5f-11ee-94c4-b496910e33c4
2023-09-26 19:28:50,632 WARN (thrift-server-pool-50922|51252) [Coordinator.updateFragmentExecStatus():1571] exec state report failed status=errorCode INTERNAL_ERROR Operation timed out after 5002 milliseconds with 0 bytes received, query_id=d9c775aa-5c5f-11ee-94c4-b496910e33be, instance_id=d9c775aa-5c5f-11ee-94c4-b496910e33c1
2023-09-26 19:28:50,637 WARN (thrift-server-pool-50925|51255) [Coordinator.updateFragmentExecStatus():1571] exec state report failed status=errorCode CANCELLED InternalError, query_id=d9c775aa-5c5f-11ee-94c4-b496910e33be, instance_id=d9c775aa-5c5f-11ee-94c4-b496910e33c0
2023-09-26 19:28:50,640 WARN (thrift-server-pool-50924|51254) [Coordinator.updateFragmentExecStatus():1571] exec state report failed status=errorCode CANCELLED InternalError, query_id=d9c775aa-5c5f-11ee-94c4-b496910e33be, instance_id=d9c775aa-5c5f-11ee-94c4-b496910e33bf

1赞

可以把es_http_timeout_ms参数调大点再试试,be.conf配置es_http_timeout_ms=xxxx

1赞