This message was deleted.
# support
s
This message was deleted.
a
try restarting otel-collector..as they apply schema changes to clickhouse. The schema changes might not have propagated to the new clickhouse node.
also, compare your values.yaml to the updated one from the upstream chart. You might have missed some changes to
values.yaml
that were published in latest release
a
try restarting otel-collector..as they apply schema changes to clickhouse.
I have restarted signoz-otel-collector many times, output of changes being applied.
Copy code
2023-03-27T11:52:19.230Z	info	components/components.go:30	Stability level of component is undefined	{"kind": "exporter", "data_type": "metrics", "name": "clickhousemetricswrite", "stability": "Undefined"}
time="2023-03-27T11:52:19Z" level=info msg="Executing:\nCREATE DATABASE IF NOT EXISTS signoz_metrics ON CLUSTER cluster\n" component=clickhouse
time="2023-03-27T11:52:19Z" 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
time="2023-03-27T11:52:19Z" level=info msg="Executing:\nCREATE TABLE IF NOT EXISTS signoz_metrics.distributed_samples_v2 ON CLUSTER cluster AS signoz_metrics.samples_v2 ENGINE = Distributed(\"cluster\", \"signoz_metrics\", samples_v2, cityHash64(metric_name, fingerprint));\n" component=clickhouse
time="2023-03-27T11:52:19Z" level=info msg="Executing:\nALTER TABLE signoz_metrics.samples_v2 ON CLUSTER cluster MODIFY SETTING ttl_only_drop_parts = 1;\n" component=clickhouse
time="2023-03-27T11:52:19Z" level=info msg="Executing:\nSET allow_experimental_object_type = 1\n" component=clickhouse
time="2023-03-27T11:52:19Z" level=info msg="Executing:\nCREATE TABLE IF NOT EXISTS signoz_metrics.time_series_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\tlabels String Codec(ZSTD(5))\n\t\t)\n\t\tENGINE = ReplacingMergeTree\n\t\t\tPARTITION BY toDate(timestamp_ms / 1000)\n\t\t\tORDER BY (metric_name, fingerprint)\n\t\t\tTTL toDateTime(timestamp_ms/1000) + INTERVAL 2592000 SECOND DELETE;\n" component=clickhouse
time="2023-03-27T11:52:20Z" level=info msg="Executing:\nCREATE TABLE IF NOT EXISTS signoz_metrics.distributed_time_series_v2 ON CLUSTER cluster AS signoz_metrics.time_series_v2 ENGINE = Distributed(\"cluster\", signoz_metrics, time_series_v2, cityHash64(metric_name, fingerprint));\n" component=clickhouse
time="2023-03-27T11:52:20Z" level=info msg="Executing:\nALTER TABLE signoz_metrics.time_series_v2 ON CLUSTER cluster DROP COLUMN IF EXISTS labels_object\n" component=clickhouse
time="2023-03-27T11:52:20Z" level=info msg="Executing:\nALTER TABLE signoz_metrics.distributed_time_series_v2 ON CLUSTER cluster DROP COLUMN IF EXISTS labels_object\n" component=clickhouse
time="2023-03-27T11:52:20Z" level=info msg="Executing:\nALTER TABLE signoz_metrics.time_series_v2 ON CLUSTER cluster MODIFY SETTING ttl_only_drop_parts = 1;\n" component=clickhouse
2023-03-27T11:52:21.017Z	info	kube/client.go:101	k8s filtering	{"kind": "processor", "name": "k8sattributes", "pipeline": "metrics/generic", "labelSelector": "", "fieldSelector": "spec.nodeName=aks-agentpool-19285271-vmss000005"}
2023-03-27T11:52:21.027Z	info	components/components.go:30	Stability level of component is undefined	{"kind": "exporter", "data_type": "traces", "name": "clickhousetraces", "stability": "Undefined"}
2023-03-27T11:52:21.207Z	info	clickhousetracesexporter/clickhouse_factory.go:146	Patching views	{"kind": "exporter", "data_type": "traces", "name": "clickhousetraces"}
2023-03-27T11:52:22.292Z	info	clickhousetracesexporter/clickhouse_factory.go:116	Running migrations from path: 	{"kind": "exporter", "data_type": "traces", "name": "clickhousetraces", "test": "/migrations"}
2023-03-27T11:52:22.341Z	info	clickhousetracesexporter/clickhouse_factory.go:128	Clickhouse Migrate finished	{"kind": "exporter", "data_type": "traces", "name": "clickhousetraces", "error": "no change"}
2023-03-27T11:52:23.190Z	info	kube/client.go:101	k8s filtering	{"kind": "processor", "name": "k8sattributes", "pipeline": "traces", "labelSelector": "", "fieldSelector": "spec.nodeName=aks-agentpool-19285271-vmss000005"}
2023-03-27T11:52:23.190Z	info	signozspanmetricsprocessor/processor.go:140	Building signozspanmetricsprocessor	{"kind": "processor", "name": "signozspanmetrics/prometheus", "pipeline": "traces"}
2023-03-27T11:52:23.327Z	info	clickhouselogsexporter/exporter.go:356	Running migrations from path: 	{"kind": "exporter", "data_type": "logs", "name": "clickhouselogsexporter", "test": "/logsmigrations"}
2023-03-27T11:52:23.340Z	info	clickhouselogsexporter/exporter.go:370	Clickhouse Migrate finished	{"kind": "exporter", "data_type": "logs", "name": "clickhouselogsexporter"}
2023-03-27T11:52:23.601Z	info	kube/client.go:101	k8s filtering	{"kind": "processor", "name": "k8sattributes", "pipeline": "logs", "labelSelector": "", "fieldSelector": "spec.nodeName=aks-agentpool-19285271-vmss000005"}
2023-03-27T11:52:23.602Z	info	kube/client.go:101	k8s filtering	{"kind": "processor", "name": "k8sattributes", "pipeline": "metrics", "labelSelector": "", "fieldSelector": "spec.nodeName=aks-agentpool-19285271-vmss000005"}
2023-03-27T11:52:23.610Z	info	service/service.go:89	Starting signoz-otel-collector...	{"Version": "latest", "NumCPU": 4}
2023-03-27T11:52:23.610Z	info	extensions/extensions.go:41	Starting extensions...
Will check
values.yaml
now thanks.