Doris JDBC Catalog sqlserver连接失败

Viewed 51

创建的时候,能够正常使用,过了几天后,就不能使用,需要重新创建

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = (10.8.101.9)[CANCELLED]JdbcExecutorException: Initialize datasource failed:
CAUSED BY: SQLTransientConnectionException: HikariPool-5 - Connection is not available, request timed out after 5000ms.

CREATE CATALOG mssql_packing PROPERTIES (
"user" = "用户",
"use_meta_cache" = "false",
"type" = "jdbc",
"password" = "密码",
"jdbc_url" = "jdbc:sqlserver://localhost:1438;databaseName=database;encrypt=false;useBulkCopyForBatchInsert=true",
"driver_url" = "mssql-jdbc-11.2.3.jre8.jar",
"driver_class" = "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"create_time" = "2024-08-26 00:13:43.113",
"checksum" = "8880baf15c70db407e1ae990e239a74b"
);

2 Answers

这个版本存在一个当查询异常关闭(如手动取消,或者读取错误)连接未关闭导致连接池计数异常的错误,会导致你遇到的报错,会在即将发布的 2.0.15 和 2.1.6进行修复

执行下面这个语句看看是否可以正常使用:

refresh catalog catalog_name