2.1.6 新建catalog 查表出现 No remote table found for table: xxxxx. Please refresh this catalog.

Viewed 70

selectdb-doris-2.1.6

2.1.5升级2.1.6 后catalog 使用正常且配置 metadata_refresh_interval_sec
在2.1.6 新建catalog 后频繁出现 找不到表或者库

No remote table found for table: xxxxx. Please refresh this catalog.

或者修改正在使用的catalog后也会出现此现象

CATALOG 创建语句

CREATE CATALOG TEST_SQLSERVER PROPERTIES (
    "type"="jdbc",
    "user"="sa",
    "password"="XXXXX",
    "jdbc_url" = "jdbc:sqlserver://XXX.XXX.XX.XX:1433;databaseName=tech;encrypt=false",
    "driver_url" = "mssql-jdbc-12.4.2.jre8.jar",
    "driver_class" = "com.microsoft.sqlserver.jdbc.SQLServerDriver",
    "connection_pool_max_size" = "200",
    "connection_pool_max_wait_time" = "30000"
);
2 Answers

这个问题已经修了,https://github.com/apache/doris/pull/40891 预计2.1.7合入
你可以先把这个改下 metadata_refresh_interval_sec 改成更大的时间,比如一个小时,或者删除了