TimonKK / clickhouse

NodeJS client for ClickHouse
Apache License 2.0
220 stars 122 forks source link

Always socket hang up after 60 seconds #117

Open Walter-meng opened 2 years ago

Walter-meng commented 2 years ago

when perform some long time query, it will show after 60 seconds Error: socket hang up at connResetException (internal/errors.js:612:14) at Socket.socketOnEnd (_http_client.js:493:23) at Socket.emit (events.js:326:22) at Socket.EventEmitter.emit (domain.js:486:12) at endReadableNT (_stream_readable.js:1252:12) at processTicksAndRejections (internal/process/task_queues.js:80:21) { code: 'ECONNRESET' }

even i set session timeout to 120 s and isSessionPerQuery:true

TimonKK commented 2 years ago

Do you sure what timeout is in nodejs? Maybe http-session is droped by web server like nginx?

mike-luabase commented 2 years ago

@Walter-meng did you find a way around this?

mike-luabase commented 2 years ago

@TimonKK we are hitting this too.

The python clickhouse-connect client has a send_receive_timeout, is there a similar one we can set here?