任务执行偶发超时，复制到DBeaver执行不到一秒就成功

wq557520 · 2025年05月15日 02:52

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】任务执行偶发超时，复制到DBeaver执行不到一秒就成功，不知道要怎么排查
【背景】无
【业务影响】
【是否存算分离】否
【StarRocks版本】3.3.13
【集群规模】例如：3fe（2follower）+4be（fe与be分开部署）
【机器信息】CPU虚拟核/内存/网卡，例如：32C/64G/万兆
【联系方式】社区群26-顽强
【附件】

fe.log/beINFO/相应截图

image3044×1178 306 KB
慢查询：
- 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
- pipeline是否开启：show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
  
  image1914×1804 375 KB
查询报错：
- query_dump，怎么获取query_dump文件

wq557520 · 2025年05月15日 03:28

[ERROR] 2025-05-15 11:25:56.965 +0800 - execute sql error: [E1008]Reached timeout=300000ms @192.168.10.144:8060: be:192.168.10.144

[ERROR] 2025-05-15 11:25:56.968 +0800 - sql task error

java.sql.SQLException: [E1008]Reached timeout=300000ms @192.168.10.144:8060: be:192.168.10.144

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1350)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025)

at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeUpdate(SqlTask.java:316)

at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:212)

at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.handle(SqlTask.java:163)

at org.apache.dolphinscheduler.server.worker.runner.DefaultWorkerDelayTaskExecuteRunnable.executeTask(DefaultWorkerDelayTaskExecuteRunnable.java:49)

at org.apache.dolphinscheduler.server.worker.runner.WorkerTaskExecuteRunnable.run(WorkerTaskExecuteRunnable.java:174)

at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)

at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)

at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:74)

at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

at java.base/java.lang.Thread.run(Thread.java:834)

[ERROR] 2025-05-15 11:25:56.969 +0800 - Task execute failed, due to meet an exception

org.apache.dolphinscheduler.plugin.task.api.TaskException: Execute sql task failed

at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.handle(SqlTask.java:170)