版本: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
报错日志:
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')