Skip to content
This repository was archived by the owner on Oct 10, 2025. It is now read-only.
This repository was archived by the owner on Oct 10, 2025. It is now read-only.

jdbc 外部表 配置之后 查询 pgsql 报错 #183

Description

@JasonFang1993
[root@hadoop114 ~]# clickhouse-jdbc-bridge
[/etc/clickhouse-jdbc-bridge/set-env.sh] is not found, will use default environment variables
Work directory is set to [/etc/clickhouse-jdbc-bridge]
Bad level value for property: .level
Bad level value for property: java.util.logging.ConsoleHandler.level
Can't set level for java.util.logging.ConsoleHandler
[2023-12-21 14:34:03] [信息     ] Loading JSON from file [config/vertx.json]... 
[2023-12-21 14:34:04] [信息     ] Loading JSON from file [config/server.json]... 
[2023-12-21 14:34:04] [信息     ] Start to monitor configuration file(s) at [config/datasources] 
[2023-12-21 14:34:04] [信息     ] Start to monitor configuration file(s) at [config/schemas] 
[2023-12-21 14:34:04] [信息     ] Start to monitor configuration file(s) at [config/queries] 
[2023-12-21 14:34:04] [信息     ] Registering new type of NamedDataSource: [jdbc] -> [com.clickhouse.jdbcbridge.impl.JdbcDataSource] 
[2023-12-21 14:34:04] [信息     ] Default type of NamedDataSource is set to [jdbc] 
[2023-12-21 14:34:04] [信息     ] Registering new type of NamedDataSource: [script] -> [com.clickhouse.jdbcbridge.impl.ScriptDataSource] 
[2023-12-21 14:34:04] [信息     ] Loading JSON from file [config/httpd.json]... 
[2023-12-21 14:34:04] [信息     ] Starting web server... 
[2023-12-21 14:34:04] [信息     ] No NamedSchema configuration found 
[2023-12-21 14:34:04] [信息     ] No NamedQuery configuration found 
[2023-12-21 14:34:04] [信息     ] Server http://0.0.0.0:9019 started in 370 ms 
[2023-12-21 14:34:04] [信息     ] Loading NamedDataSource configuration... 
[2023-12-21 14:34:04] [信息     ] Adding NamedDataSource(id=pgsql10)... 
[2023-12-21 14:34:04] [信息     ] pgsql10 - Starting... 
[2023-12-21 14:34:04] [警告     ] Registered driver with driverClassName=org.postgresql.Driver was not found, trying direct instantiation. 
[2023-12-21 14:34:08] [信息     ] pgsql10 - Start completed. 
[2023-12-21 14:34:08] [信息     ] Adding NamedDataSource(id=script)... 
[2023-12-21 14:47:33] [信息     ] Raw query:
t_ais_entity_cfg 
[2023-12-21 14:47:48] [警告     ] Thread Thread[vert.x-eventloop-thread-0,5,main]=Thread[vert.x-eventloop-thread-0,5,main] has been blocked for 15103 ms, time limit is 15000 ms 
[2023-12-21 14:47:49] [警告     ] Thread Thread[vert.x-eventloop-thread-0,5,main]=Thread[vert.x-eventloop-thread-0,5,main] has been blocked for 16105 ms, time limit is 15000 ms 
[2023-12-21 14:47:50] [警告     ] Thread Thread[vert.x-eventloop-thread-0,5,main]=Thread[vert.x-eventloop-thread-0,5,main] has been blocked for 17106 ms, time limit is 15000 ms 
[2023-12-21 14:47:51] [警告     ] Thread Thread[vert.x-eventloop-thread-0,5,main]=Thread[vert.x-eventloop-thread-0,5,main] has been blocked for 18111 ms, time limit is 15000 ms 

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions