search

ClickHouse / clickhouse-jdbc-bridge

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

error when i connect to AS400 server #173

Open haiwei1991 opened 1 year ago

haiwei1991 commented 1 year ago

when i connect to my AS400 server, there is an error , I can not solve it ,please help me . see the log bellow:

2023.03.11 18:50:05.698990 [ 13433 ] {646bc397-3168-45f7-a12e-6df38e4ff5b7} <Error> ReadWriteBufferFromHTTP: HTTP request tohttp://127.0.0.1:9019/columns_info?version=1&connection_string=as400&table=select%20%2A%20from%20PGR05LB.MHL59P&external_table_functions_use_nulls=1failed at try 1/1 with bytes read: 0/unknown. Error: DB::Exception: Received error from remote server /columns_info?version=1&connection_string=as400&table=select%20%2A%20from%20PGR05LB.MHL59P&external_table_functions_use_nulls=1. HTTP status code: 500 Internal Server Error, body: Failed to infer schema from [as400] due to: Failed to access [as400] due to: as400 - Connection is not available, request timed out after 30000ms.. (Current backoff wait is 100/1600 ms) 2023.03.11 18:50:05.799663 [ 13433 ] {646bc397-3168-45f7-a12e-6df38e4ff5b7} <Error> executeQuery: Code: 86. DB::Exception: Received error from remote server /columns_info?version=1&connection_string=as400&table=select%20%2A%20from%20PGR05LB.MHL59P&external_table_functions_use_nulls=1. HTTP status code: 500 Internal Server Error, body: Failed to infer schema from [as400] due to: Failed to access [as400] due to: as400 - Connection is not available, request timed out after 30000ms. (RECEIVED_ERROR_FROM_REMOTE_IO_SERVER) (version 22.9.4.32 (official build)) (from [::ffff:172.31.76.22]:60177) (in query: select * from jdbc('as400', 'select * from PGR05LB.MHL59P') FORMAT TabSeparatedWithNamesAndTypes;), Stack trace (when copying this message, always include the lines below):

haiwei1991 commented 1 year ago

my version

clickhouse-server-22.9.4.32-1.x86_64 clickhouse-client-22.9.4.32-1.x86_64 clickhouse-common-static-dbg-22.9.4.32-1.x86_64 clickhouse-jdbc-bridge-2.1.0-1.noarch clickhouse-common-static-22.9.4.32-1.x86_64

haiwei1991 commented 1 year ago

@zhicwu

zhicwu commented 1 year ago

as400 - Connection is not available, request timed out after 30000ms.

Hi @haiwei1991, have you validated the datasource configuration on JDBC bridge servder? It seems not working.

haiwei1991 commented 1 year ago

as400 - Connection is not available, request timed out after 30000ms.

Hi @haiwei1991, have you validated the datasource configuration on JDBC bridge servder? It seems not working.

I executed select * from jdbc('', 'show datasources') and I can see the datasource of AS400 。 I‘m not sure if it is the validation you said. are there any other way to validate the datasource configuration.