阿里云首页

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."

问题描述

QuickBI中数据集打开查询加速的开关之后,抽取数据失败,查看日志报错" 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,必须确保公网环境的QuickBI可以通过VPC通道能正常访问该数据源。

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

解决方案

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

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

139.224.92.0/24
106.15.145.0/24

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

适用于

  • QuickBI

 

首页 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."