JDBC Catalog 连接超时 HikariPool-102 - Connection is not available, request timed out

Viewed 38

版本:Doris 2.1.7

安装:K8s 集群 Operator 安装

已经做的修改(修改后还出现下面的报错):
1、jdbc_url 后面添加:&connectTimeout=30000&socketTimeout=60000
2、添加以下参数:
alter catalog fae_mysql_catalog_lb set properties('connection_pool_max_life_time' = '14400000');
alter catalog fae_mysql_catalog_lb set properties('connection_pool_max_size' = '50');
alter catalog fae_mysql_catalog_lb set properties('connection_pool_max_wait_time' = '20000'); # 后面改成 30000

另外:mysql 的 wait_timeout 或 interactive_timeout 都是 8h

连接信息:
JDBC:jdbc:mysql://124.71.71.74:3306?yearIsDateType=false&tinyInt1isBit=false&useUnicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8&connectTimeout=30000&socketTimeout=60000&autoReconnect=true
image.png

报错日志:

pymysql.err.OperationalError: (1105, 'errCode = 2, detailMessage = (doriscluster-be-5.doriscluster-be-internal.doris-2-1.svc.cluster.local)[CANCELLED]JdbcExecutorException: Initialize datasource failed: \nCAUSED BY: SQLTransientConnectionException: HikariPool-102 - Connection is not available, request timed out after 20101ms.\nCAUSED BY: CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 5,226,179 milliseconds ago. The last packet sent successfully to the server was 5,226,189 milliseconds ago.\nCAUSED BY: CJCommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 5,226,179 milliseconds ago. The last packet sent successfully to the server was 5,226,189 milliseconds ago.\nCAUSED BY: SocketTimeoutException: Read timed out')

2 Answers

请问我还可以做哪些修改或者需要提供什么参数