Hi Clickhouse cpu consumption is high with the bel...
# support
d
Hi Clickhouse cpu consumption is high with the below error logs
Copy code
2024.08.06 07:43:09.878690 [ 10272 ] {d6987e94-891b-4711-b2d2-c237c112bd24} <Warning> TCPHandler: Client has gone away.
2024.08.06 07:43:09.992561 [ 10213 ] {649b9905-b057-453a-b3c2-5816aa655237} <Error> executeQuery: Code: 210. DB::NetException: I/O error: Broken pipe, while writing to socket (172.18.0.3:9000 -> 172.18.0.5:33828). (NETWORK_ERROR) (version 24.1.2.5 (official build)) (from 172.18.0.5:33828) (in query: INSERT INTO signoz_metrics.distributed_time_series_v4 (env, temporality, metric_name, description, unit, type, is_monotonic, fingerprint, unix_milli, labels) VALUES), Stack trace (when copying this message, always include the lines below):

0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c800f1b in /usr/bin/clickhouse
1. DB::NetException::NetException<String, String, String>(int, FormatStringHelperImpl<std::type_identity<String>::type, std::type_identity<String>::type, std::type_identity<String>::type>, String&&, String&&, String&&) @ 0x000000000caa69a1 in /usr/bin/clickhouse
2. DB::WriteBufferFromPocoSocket::nextImpl() @ 0x000000000caa733e in /usr/bin/clickhouse
3. DB::TCPHandler::runImpl() @ 0x000000001292120f in /usr/bin/clickhouse
4. DB::TCPHandler::run() @ 0x0000000012933eb9 in /usr/bin/clickhouse
5. Poco::Net::TCPServerConnection::start() @ 0x00000000153a5a72 in /usr/bin/clickhouse
6. Poco::Net::TCPServerDispatcher::run() @ 0x00000000153a6871 in /usr/bin/clickhouse
7. Poco::PooledThread::run() @ 0x000000001549f047 in /usr/bin/clickhouse
8. Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001549d67d in /usr/bin/clickhouse
9. ? @ 0x00007f1d8f8f7609
10. ? @ 0x00007f1d8f81c353

2024.08.06 07:43:09.992735 [ 10213 ] {6
image.png
current conf of the vm: 4 core 16gb only one other service is running apart from signoz containers
s
how much data are you ingesting?
d
per day around 9m spans