search

ClickHouse / clickhouse-jdbc-bridge

A JDBC proxy from ClickHouse to external databases
Apache License 2.0
167 stars 60 forks source link

DB::Exception: jdbc-bridge is not running. Please, start it manually. #111

Open vleyong opened 3 years ago

vleyong commented 3 years ago

Recently I executed the "insert into from " on Click House client，it showed that jdbc-bridge is not running.In fact ,I already ran it.

vleyong commented 3 years ago

Recently I executed the "insert into from " on Click House client，it showed that jdbc-bridge is not running.In fact ,I already ran it.

My ClickHouse client Version is 20.4.5.36,server is 20.8.17

vleyong commented 3 years ago

Loading JSON from file [config/vertx.json]... 2021-08-17 15:47:12.012 [main] [WARN ] {Utils:949} - Failed to load JSON from file config/vertx.json 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {Utils:940} - Loading JSON from file [config/server.json]... 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [WARN ] {Utils:949} - Failed to load JSON from file config/server.json 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {JdbcBridgeVerticle:573} - Start to monitor configuration file(s) at [config/datasources] 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {JdbcBridgeVerticle:573} - Start to monitor configuration file(s) at [config/schemas] 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {JdbcBridgeVerticle:573} - Start to monitor configuration file(s) at [config/queries] 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {BaseRepository:275} - Registering new type of NamedDataSource: [jdbc] -> [ru.yandex.clickhouse.jdbcbridge.impl.JdbcDataSource] 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {BaseRepository:278} - Default type of NamedDataSource is set to [jdbc] 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {BaseRepository:275} - Registering new type of NamedDataSource: [script] -> [ru.yandex.clickhouse.jdbcbridge.impl.ScriptDataSource] 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {Utils:940} - Loading JSON from file [config/httpd.json]... 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [WARN ] {Utils:949} - Failed to load JSON from file config/httpd.json 2021-08-17 15:47:13.013 [vert.x-eventloop-thread-0] [INFO ] {JdbcBridgeVerticle:270} - Starting web server... 2021-08-17 15:47:14.014 [vert.x-worker-thread-1] [INFO ] {JsonFileRepository:75} - No NamedSchema configuration found 2021-08-17 15:47:14.014 [vert.x-worker-thread-1] [INFO ] {JsonFileRepository:75} - No NamedQuery configuration found 2021-08-17 15:47:14.014 [vert.x-eventloop-thread-0] [INFO ] {JdbcBridgeVerticle:274} - Server http://0.0.0.0:9019 started in 1138 ms 2021-08-17 15:47:14.014 [vert.x-worker-thread-2] [INFO ] {JsonFileRepository:87} - Loading NamedDataSource configuration... 2021-08-17 15:47:14.014 [vert.x-worker-thread-2] [INFO ] {BaseRepository:206} - Adding NamedDataSource(id=msjdbc)... 2021-08-17 15:47:14.014 [vert.x-worker-thread-2] [WARN ] {DriverDataSource:70} - Registered driver with driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver was not found, trying direct instantiation.

zhicwu commented 3 years ago

Can you access jdbc-bridge from your ClickHouse server/container? Try curl -v http://<jdbc-birdge>:9019/ping.

Moreover, you may want to revisit configuration on ClickHouse server, check /etc/clickhouse-server/config.xml and/or other configuration files under /etc/clickhouse-server/config.d for something like below:

<yandex>
...
<jdbc_bridge>
  <host>jdbc-bridge</host>
  <port>9019</port>
</jdbc_bridge>
...
</yandex>
theseusyang commented 3 years ago

I has encounter the some problem, how to solve it.pls?

theseusyang commented 3 years ago

I has encounter the some problem, how to solve it.pls?