QucikBI中数据集打开查询加速的开关之后，抽取数据时查询日志报错" Communications link failure.The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."

问题描述

Quick BI中数据集打开查询加速的开关之后，抽取数据失败，查看日志报错" Communications link failure.The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."。完整的日志信息如下：

021-11-09 17:14:48 [INFO] initialize job context, jobHistoryId:071c20af-0988-4ee9-9092-dc70fbb6e5f5
2021-11-09 17:14:48 [INFO] start execute job.
2021-11-09 17:14:48 [INFO] sync begin. datasetId-[caf1dcda-1c71-424f-89d2-63f2a6fecd88] syncId-[7ea94cf9056e4a68b0a5f7f19142115a]
2021-11-09 17:15:18 [INFO] check rows.
2021-11-09 17:15:18 [INFO] current data rows:0
2021-11-09 17:15:33 [ERROR] sync error.Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2021-11-09 17:15:33 [ERROR] execute job failure.

问题原因

加速引擎这里出现该问题的原因有两点： 

1.确保数据源能够测试连接通过，如果勾选了VPC，必须确保公网环境的Quick BI可以通过VPC通道能正常访问该数据源。

2.数据库白名单中未配置抽取服务的IP，需要将抽取服务的IP配置到数据库的白名单中。

解决方案

1.如果数据源测试连接不通时，就配置了加速引擎。修改数据源的相关配置，数据源能正常连接之后，需要关闭加速引擎的开关，并重新打开才会生效。

2.数据源能正常连接的基础上，将抽取服务的IP配置到数据库白名单中，抽取服务IP如下：

139.224.92.0/24
106.15.145.0/24

3.生成数据集的SQL语句不能包含占位符、参数等。

适用于

• Quick BI