Denny [DBA at Innervate]
Denny [DBA at Innervate]
>We have multiple low-end severs 1 vCPU and 1-2 GB RAM for testing purposes >Please don't tell me it's a normal thing :). By default Clickhouse is tuned for beefy...
>Sure, but why would I need beefy machines for 0 load? Would you personally use 32 vCPU + 128 GB for 0 load? I doubt that. I use 96CPU /...
I also have my own opinion about internal telemetry; I advise those who do not use it to turn it off. https://github.com/ClickHouse/ClickHouse/issues?q=is%3Aissue+asynchronous_metrics_update_period_s+is%3Aclosed
It's not enough information to understand what is going on. You need to share related fragments from **clickhouse-server.log** from **ALL REPLICAS.** --- >ALTER TABLE default.users ON CLUSTER '{cluster}' REPLACE PARTITION...
Clickhouse is unable to deduce a type of an empty array. You need to use explicit cast `[]::Array(Int32)` ``` CREATE OR REPLACE VIEW pview AS SELECT {a:Array(Int32)} = []::Array(Int32); SELECT...
You can leave it open. It can be improved.
``` SELECT map() from remote('127.0.0.{1,2}', system,one) SETTINGS allow_experimental_analyzer=0 {} {} SELECT map() from remote('127.0.0.{1,2}', system,one) SETTINGS allow_experimental_analyzer=1 DB::Exception: CAST AS Map from array requires nested tuple of 2 elements. ```...
Do you have something like a proxy or a loadbalancer in between Clickhouse and your application? This looks like a loadbalancer is probing Clickhouse http port for an availability.
>Why does it seem to happen only during inserts? How do you know this? Do you use jdbc (http/8123) for other queries as well? Can you share more logs? With...
>What more logs do you need? This is a log of the insert: ``` [ 295306 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::ffff:10.252.126.143]:53950, User-Agent: Vector/0.33.0 (x86_64-unknown-linux-gnu...