Romil Khanna
07/28/2023, 4:02 PM2023/07/28 16:01:02 application run finished with error: failed to build pipelines: failed to create "clickhousetraces" exporter for data type "traces": code: 60, message: Table signoz_traces.distributed_signoz_index_v2 doesn't exist
anyone get this problem?Prashant Shahi
07/28/2023, 4:54 PMRomil Khanna
07/28/2023, 4:56 PMschema_migrations
and deleted the row then set the other ones to dirty = 0clickhouse.cluster
at all
• the pod does not query to see how many shards or replicas are present so it marks 1 as good and other as dirtyPrashant Shahi
07/28/2023, 5:06 PMclickhouse.cluster
is static value cluster
at the moment due to the limitations of the go-migrate and it being static in migration filesthe pod does not query to see how many shards or replicas are present so it marks 1 as good and other as dirtyCould you please elaborate on this?
Romil Khanna
07/28/2023, 5:09 PMPrashant Shahi
07/29/2023, 7:16 AMRomil Khanna
08/01/2023, 5:02 PMsignoz-otel-collector-7b86585cd5-nrnnd signoz-otel-collector 2023-08-01T16:57:09.381Z info clickhousetracesexporter/clickhouse_factory.go:127 Clickhouse Migrate finished {"kind": "exporter", "data_type": "traces", "name": "clickhousetraces", "error": "migration failed in line 0: \n\n\n\nCREATE MATERIALIZED VIEW IF NOT EXISTS signoz_traces.dependency_graph_minutes_service_calls_mv ON CLUSTER cluster\nTO signoz_traces.dependency_graph_minutes AS\nSELECT\n A.serviceName as src,\n B.serviceName as dest,\n quantilesState(0.5, 0.75, 0.9, 0.95, 0.99)(toFloat64(B.durationNano)) as duration_quantiles_state,\n countIf(B.statusCode=2) as error_count,\n count(*) as total_count,\n toStartOfMinute(B.timestamp) as timestamp\nFROM signoz_traces.signoz_index_v2 AS A, signoz_traces.signoz_index_v2 AS B\nWHERE (A.serviceName != B.serviceName) AND (A.spanID = B.parentSpanID)\nGROUP BY timestamp, src, dest; (details: code: 47, message: Unknown identifier: B.timestamp; there are columns: timestamp, serviceName, B.serviceName, quantilesState(0.5, 0.75, 0.9, 0.95, 0.99)(toFloat64(B.durationNano)), countIf(equals(B.statusCode, 2)), count(): While processing serviceName AS src, B.serviceName AS dest, quantilesState(0.5, 0.75, 0.9, 0.95, 0.99)(toFloat64(B.durationNano)) AS duration_quantiles_state, countIf(B.statusCode = 2) AS error_count, count() AS total_count, toStartOfMinute(B.timestamp) AS timestamp)"}
and
signoz-otel-collector-7b86585cd5-nrnnd signoz-otel-collector 2023-08-01T17:00:01.906Z error clickhousetracesexporter/writer.go:128 Could not write a batch of spans {"kind": "exporter", "data_type": "traces", "name": "clickhousetraces", "error": "code: 60, message: Table signoz_traces.distributed_span_attributes doesn't exist"}
Prashant Shahi
08/01/2023, 5:15 PMRomil Khanna
08/01/2023, 5:15 PMSrikanth Chekuri
08/02/2023, 2:29 AM