nikepan / clickhouse-bulk

Collects many small inserts to ClickHouse and send in big inserts
Apache License 2.0
474 stars 87 forks source link

ERROR 502: No working clickhouse servers #7

Closed dvska closed 5 years ago

dvska commented 6 years ago
{
  "listen": ":8123",
  "flush_count": 10000,
  "flush_interval": 3000,
  "debug": true,
  "dump_dir": "dumps",

  "clickhouse": {
    "down_timeout": 300,
    "servers": [
      "http://0.0.0.0:8070"
    ]
  }
}
2018/07/11 09:15:27 query query=Insert+into+Log_buffer+FORMAT+JSONEachRow&input_format_skip_unknown_fields=1 {"ts":"2018-07-11 09:15:27","level":"DEBUG","logger":"plugins.base_core","pid":19847,"procname":"wkr:1","file":"base_core.py:352","body":"Action start for '***********'","node":"US-2","jobid":"51399907","uid":"2","type":"monitor","plug":"*****"}
2018/07/11 09:15:27 Send ERROR 502: No working clickhouse servers

while direct insert into CH works fine -

$ curl 0.0.0.0:8087
Ok.

🙏

PS Не выдерживает нагрузки?

nikepan commented 6 years ago

why you use 0.0.0.0?

dvska commented 6 years ago

the same with 127.0.0.1

nikepan commented 6 years ago

may be not same) i will check at evening. thank you!

sneakythr0ws commented 6 years ago

Any progress? I have same issue.

nikepan commented 5 years ago

0.0.0.0 - is all ip addresses of localhost, you need to use a specific address (127.0.0.1 or any other) macos:

ping 0.0.0.0
PING 0.0.0.0 (0.0.0.0): 56 data bytes
ping: sendto: No route to host
ping: sendto: No route to host