use clickhouse handler but got 404 Not Found

[hantmac]

Hi there,

I run vector -c vector.toml to trans nginx log into clickhouse, but got the next error:

2022-06-14T06:51:57.391239Z ERROR vector::topology::builder: msg="Healthcheck: Failed Reason." error=Unexpected status: 404 Not Found component_kind="sink" component_type="clickhouse" component_id=nginx_access_log_to_databend component_name=nginx_access_log_to_databend

[StephenWakely]

This sounds very much like Vector isn't able to access Clickhouse at the endpoint you have configured. Are you sure the address and port are configured correctly?

Sometimes it can just be the healthcheck endpoint isn't working. What happens if you disable healthchecks? Is it then able to send data into Clickhouse?

healthcheck.enabled = false

[hantmac]

Thanks for your reply, I checked and make sure the endpoint of Clickhouse is ok.
healthcheck.enabled = false works for me! But why the healthcheck endpoint isn't working?🤔

[spencergilbert]

Databend may not be the same as how we expect Clickhouse to respond to our healthcheck. Though we do just appear to be running a basic query: https://github.com/vectordotdev/vector/blob/master/src/sinks/clickhouse.rs#L174

[hantmac]

Got it . Thank you very much