Vaibhavi
03/17/2023, 12:07 PMSrikanth Chekuri
03/17/2023, 1:34 PMVaibhavi
03/17/2023, 2:02 PMSrikanth Chekuri
03/17/2023, 2:54 PM22.8
Vaibhavi
03/18/2023, 1:13 AMSrikanth Chekuri
03/18/2023, 2:27 AMVaibhavi
03/18/2023, 10:04 AMSrikanth Chekuri
03/18/2023, 10:09 AMv0.17.0
it is 22.8
and you are using a lower version we no longer support. Look at the tag here https://github.com/SigNoz/charts/blob/7bf7768df013dd5968c0b80de06ca3c3ab651f70/charts/signoz/values.yaml#L109Vaibhavi
03/18/2023, 2:18 PMSrikanth Chekuri
03/18/2023, 2:18 PM22.8.8
or later and it should work.Vaibhavi
03/18/2023, 2:19 PMSrikanth Chekuri
03/19/2023, 7:35 AMVaibhavi
03/19/2023, 7:36 AMSrikanth Chekuri
03/19/2023, 7:39 AMSELECT version()
for ClickHouse. Also when you are using external ClickHouse there should be cluster called cluster
.Vaibhavi
03/19/2023, 7:40 AMSrikanth Chekuri
03/20/2023, 2:16 AMsignoz_metrics.samples_v2
doesn’t exist, but the line above says otherwise, and I can’t reproduce this locally. We don’t officially support Windows yet if you are running using Windows.Vaibhavi
03/20/2023, 4:12 AMSrikanth Chekuri
03/20/2023, 6:40 AM\n
because it is a log message. The actual query runs fine. It will look like this.
CREATE TABLE IF NOT EXISTS signoz_metrics.samples_v2 ON CLUSTER cluster (
metric_name LowCardinality(String),
fingerprint UInt64 Codec(DoubleDelta, LZ4),
timestamp_ms Int64 Codec(DoubleDelta, LZ4),
value Float64 Codec(Gorilla, LZ4)
)
ENGINE = MergeTree
PARTITION BY toDate(timestamp_ms / 1000)
ORDER BY (metric_name, fingerprint, timestamp_ms)
TTL toDateTime(timestamp_ms/1000) + INTERVAL 2592000 SECOND DELETE;
Which is a valid ClickHouse query. You can see the code here https://github.com/SigNoz/signoz-otel-collector/blob/dcf11134a7db5d3f3e55dd14d34d1b1decb77e65/exporter/clickhousemetricsexporter/clickhouse.go#L[…]6Vaibhavi
03/20/2023, 6:41 AMSrikanth Chekuri
03/20/2023, 6:45 AMtime="2023-03-20T01:12:45Z" level=info msg="Executing:\nCREATE TABLE IF NOT EXISTS signoz_metrics.samples_v2 ON CLUSTER cluster (\n\t\t\tmetric_name LowCardinality(String),\n\t\t\tfingerprint UInt64 Codec(DoubleDelta, LZ4),\n\t\t\ttimestamp_ms Int64 Codec(DoubleDelta, LZ4),\n\t\t\tvalue Float64 Codec(Gorilla, LZ4)\n\t\t)\n\t\tENGINE = MergeTree\n\t\t\tPARTITION BY toDate(timestamp_ms / 1000)\n\t\t\tORDER BY (metric_name, fingerprint, timestamp_ms)\n\t\t\tTTL toDateTime(timestamp_ms/1000) + INTERVAL 2592000 SECOND DELETE;\n" component=clickhouse
And proceeds to the next one and throw error signoz_metrics.samples_v2
doesn’t exist. The prev step didn’t result in an error. Does your clickhouse set up to support the distributed engines and the cluster named cluster
exist?Vaibhavi
03/20/2023, 9:13 AMsignoz_metrics
.samples_v2
from metadata file /var/lib/clickhouse/store/90f/90fde3c5-a131-4fd9-a85a-51a5cab5517e/samples_v2.sql from query ATTACH TABLE signoz_metrics.samples_v2 UUID '01c3f5a7-9d8b-45dc-9903-c11b8ae3bdd2' (metric_name
LowCardinality(String), fingerprint
UInt64 CODEC(DoubleDelta, LZ4), timestamp_ms
Int64 CODEC(DoubleDelta, LZ4), value
Float64 CODEC(Gorilla, LZ4)) ENGINE = MergeTree PARTITION BY toDate(timestamp_ms / 1000) ORDER BY (metric_name, fingerprint, timestamp_ms) TTL toDateTime(timestamp_ms / 1000) + toIntervalSecond(2592000) SETTINGS index_granularity = 8192, ttl_only_drop_parts = 1
when looked for this error i could find fixes in VM setup but how to fix in kubernetes please suggest at priority as we are conducting load tests.Srikanth Chekuri
04/05/2023, 7:38 AMVaibhavi
04/05/2023, 7:41 AMSrikanth Chekuri
04/05/2023, 7:42 AMVaibhavi
04/05/2023, 7:52 AMSrikanth Chekuri
04/05/2023, 8:03 AMVaibhavi
04/05/2023, 8:05 AMSrikanth Chekuri
04/05/2023, 8:46 AMVaibhavi
04/06/2023, 5:18 AMSrikanth Chekuri
04/17/2023, 1:57 PMVaibhavi
04/17/2023, 1:58 PMSrikanth Chekuri
04/17/2023, 1:58 PMVaibhavi
04/18/2023, 4:47 AMSrikanth Chekuri
04/18/2023, 4:57 AMVaibhavi
04/18/2023, 4:59 AMSrikanth Chekuri
04/18/2023, 7:35 AMVaibhavi
04/18/2023, 8:55 AMSrikanth Chekuri
04/18/2023, 12:26 PMthere are 30 applications where logs are being written to signoz otel collectorWhat is the volume of the logs emitted by these applications?
but i’m sometimes able to see 3 components or sometimes 4 and it variesWhat component are you referring here?
Vaibhavi
04/18/2023, 12:28 PMSrikanth Chekuri
04/18/2023, 12:52 PMServices
tab data comes from the traces. If services it not sending data for the period it will not show up in the list. The items on the list are complete set but the services that sent the data in the selected time range (top-right corner).Vaibhavi
04/18/2023, 12:57 PM