Quick BI数据集加速抽取报错：canceling statement due to workload manager exception.statement running timeout, thread that sends the signal is 140446866245376.

【问题描述】

Quick BI数据集加速抽取报错：canceling statement due to workload manager exception.statement running timeout, thread that sends the signal is 140446866245376.

具体问题如下：

2024-08-07 14:29:44 [INFO] manual start retry job...

2024-08-07 14:29:44 [INFO] [manual] initialize job context, jobHistoryId:a2677328-86be-413c-837e-56da00ef0232

2024-08-07 14:29:44 [INFO] start execute job.

2024-08-07 14:29:44 [INFO] sync begin. datasetId-[c91a762c-15f0-45a2-9503-ac9746453e9e] syncId-[b6ea6444efc94c7a8e50e71279e93ac2]

2024-08-07 14:29:44 [INFO] current data rows:0

2024-08-07 14:29:54 [INFO] check rows limit.

2024-08-07 14:35:16 [ERROR] execute job failure.error message:

[QE5206002] sync error. org.postgresql.util.PSQLException: ERROR: canceling statement due to workload manager exception.statement running timeout, thread that sends the signal is 140446866245376.

【解答】

数据集抽取加速的时候，数据库运行超时了哈。当前数据集抽取的是全表抽取。全量抽取数据量太大，可能会导致数据读取数据超时，会话自动取消。可以修改为按天增量抽取，减少每次抽取的数据量，降低数据库查询的数据量，从而减少抽取时间。

【适用于】

Quick BI