housepower / ClickHouse-Native-JDBC

ClickHouse Native Protocol JDBC implementation
https://housepower.github.io/ClickHouse-Native-JDBC/
Apache License 2.0
527 stars 145 forks source link

TCPHandlerFactory creating TCPHandle is slow. Takes 6 sec within intranet #423

Closed daggerin3 closed 2 years ago

daggerin3 commented 2 years ago

Environment

Error logs

2022.07.25 17:26:07.621819 [ 7644 ] {} TCPHandlerFactory: TCP Request. Address: [::ffff:172.22.254.xxx]:57314 2022.07.25 17:26:13.661146 [ 7644 ] {} TCPHandler: Connected ClickHouse client version 1.1.0, revision: 54380, database: xxx, user: xxx.

paste your error logs here JDBC return the correct results but slow.

Steps to reproduce

Everytime using that service

Other descriptions

  1. Ping is ok, stable and fast
  2. Tried to stop firewall on both machines
  3. No error logs found in /var/log/clickhouse-server/clickhouse-server.err.log

Any suggestions will be grateful.

Warm Regards,

daggerin3 commented 2 years ago

Thanks a lot. Problem solved. 1st DNS server is unreachable.

Issue can be closed.