ClickHouse jdbc-bridge连接MariaDB报NamedDataSource不存在错误

故障场景 #

Docker环境部署的ClickHouse服务端，通过clickhouse-jdbc-bridge访问同环境Docker部署的MariaDB服务数据时，触发报错：NamedDataSource [jmdb-1] does not exist!

当前环境状态 #

• 已参照官方jdbc-bridge配置指引完成基础配置，经检查jdbc-bridge进程运行正常，进程查询结果如下：

root@c3410b41cd87:/# ps -aux | grep jdbc
root         251  0.3  1.3 6349608 108076 ?      Sl   13:28   0:17 java -jar /clickhouse-jdbc-bridge/clickhouse-jdbc-bridge-2.0.7-shaded.jar
root         529  0.0  0.0   6300   716 pts/0    S+   14:59   0:00 grep --color=auto jdbc

• 命名为jmdb-1的数据源配置文件存放路径为/clickhouse-jdbc-bridge/config/datasources/jmdb-1.json，文件内容如下：

root@c3410b41cd87:/clickhouse-jdbc-bridge/config/datasources# cat jmdb-1.json 
{
  "jmdb-1": {
  "driverUrls": [
    "https://dlm.mariadb.com/2325871/Connectors/java/connector-java-3.0.5/mariadb-java-client-3.0.5.jar"
  ],
  "jdbcUrl": "jdbc:mariadb://10.5.1.11:13306",
  "username": "mariadb",
  "password": "maria1234"
  }
}

• 执行跨源查询语句及返回报错如下：
  查询语句：

SELECT * FROM jdbc('jmdb-1', 'mdb', 'mdb_sf1_region');

报错内容：

Received exception from server (version 22.5.1):
Code: 86. DB::Exception: Received from 10.5.1.31:9000. DB::Exception: Received error from remote server /columns_info?connection_string=jmdb-1&schema=mdb&table=mdb_sf1_region&external_table_functions_use_nulls=true. HTTP status code: 500 Internal Server Error, body: NamedDataSource [jmdb-1] does not exist!. 

初步排查结论 #

目前确认ClickHouse与jdbc-bridge网络连通正常（已收到桥接服务返回的500错误响应），但无法定位jdbc-bridge无法识别已配置的jmdb-1数据源的原因，需要对应排查思路与解决方案。

内容的提问来源于stack exchange，提问作者Hyrikan