Clickhouse 22.3 Fresh Install Causes Otel Collector Startup Error

TLDR Romil experienced an error preventing the otel collector from starting after a fresh Clickhouse installation. vishal-signoz shared the fix from a previous thread.

Photo of Romil
Romil
Thu, 23 Feb 2023 16:34:35 UTC

noob question, i did a fresh install yesterday on clickhouse 22.3 using the helm chart and now the otel collector won't start, i see the following in logs: ```2023/02/23 07:54:28 application run finished with error: cannot build pipelines: failed to create "clickhousetraces" exporter, in pipeline "traces": code: 62, message: Syntax error: failed at position 2290 (')') (line 43, col 3): ) ENGINE MergeTree() PARTITION BY toDate(timestamp) ORDER BY (durationNano, timestamp) TTL toDateTime(timestamp) + INTERVAL 604800 SECOND DELETE SETTING. Expected one of: table property (column, index, constraint) declaration, INDEX, CONSTRAINT, PROJECTION, PRIMARY KEY, column declaration, identifier```

Photo of Prashant
Prashant
Fri, 24 Feb 2023 06:12:01 UTC

vishal-signoz can you look into this?

Photo of vishal-signoz
vishal-signoz
Fri, 24 Feb 2023 06:13:26 UTC

I think it is fixed:

Photo of Prashant
Prashant
Fri, 24 Feb 2023 07:12:46 UTC

got it

SigNoz Community Logo

SigNoz Community

Indexed 1060 threads

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

View in App

Similar Threads

Error Fetching Logs in SigNoz and Service Map Issue
Issues with Installing Signoz on Standalone VM with Two Additional Disks
Issues with SigNoz Setup and Data Persistence in AKS
Problems Encountered with ClickHouse After Fresh Install
Resolving Error on Clickhouse Client and Otel Collector