Hello, i use signoz-schema-migrator:0.88.13 to upg...
# support
k
Hello, i use signoz-schema-migrator:0.88.13 to upgrade the signoz data structure and prompt this error. How can I solve this error? {“level”“error”,“timestamp”“2024-02-18T075240.658Z”,“caller”“migrationmanager/manager.go80",“msg”:“Failed to run migrations for migrator”,“component”“migrationmanager”,“migrator”“metrics”,“error”:“clickhouse migrate failed to run, error: migration failed in line 0: CREATE TABLE IF NOT EXISTS signoz_metrics.exp_hist ON CLUSTER cluster (\n env LowCardinality(String) DEFAULT ‘default’,\n temporality LowCardinality(String) DEFAULT ‘Unspecified’,\n metric_name LowCardinality(String),\n fingerprint UInt64 CODEC(Delta, ZSTD),\n unix_milli Int64 CODEC(DoubleDelta, ZSTD),\n count UInt64 CODEC(ZSTD(1)),\n sum Float64 Codec(Gorilla, ZSTD),\n min Float64 Codec(Gorilla, ZSTD),\n max Float64 Codec(Gorilla, ZSTD),\n sketch AggregateFunction(quantilesDD(0.01, 0.5, 0.75, 0.9, 0.95, 0.99), UInt64) CODEC(ZSTD(1))\n)\nENGINE = MergeTree\n PARTITION BY toDate(unix_milli / 1000)\n ORDER BY (env, temporality, metric_name, fingerprint, unix_milli)\n TTL toDateTime(unix_milli/1000) + INTERVAL 2592000 SECOND DELETE\n SETTINGS ttl_only_drop_parts = 1; (details: code: 63, message: Unknown aggregate function quantilesDD. Maybe you meant: [‘quantiles’,‘quantilesGK’])“,”stacktrace”:“github.com/SigNoz/signoz-otel-collector/migrationmanager.(*MigrationManager).Migrate\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go80\nmain.main\n\t/home/runner/work/signoz otel collector/signoz otel collector/cmd/signozschemamigrator/migrate.go108\nruntime.main\n\t/opt/hostedtoolcache/go/1.20.14/x64/src/runtime/proc.go:250”} {“level”“fatal”,“timestamp”“2024-02-18T075240.658Z”,“caller”“signozschemamigrator/migrate.go110”,“msg”:“Failed to run migrations”,“component”:“migrate cli”,“error”:“clickhouse migrate failed to run, error: migration failed in line 0: CREATE TABLE IF NOT EXISTS signoz_metrics.exp_hist ON CLUSTER cluster (\n env LowCardinality(String) DEFAULT ‘default’,\n temporality LowCardinality(String) DEFAULT ‘Unspecified’,\n metric_name LowCardinality(String),\n fingerprint UInt64 CODEC(Delta, ZSTD),\n unix_milli Int64 CODEC(DoubleDelta, ZSTD),\n count UInt64 CODEC(ZSTD(1)),\n sum Float64 Codec(Gorilla, ZSTD),\n min Float64 Codec(Gorilla, ZSTD),\n max Float64 Codec(Gorilla, ZSTD),\n sketch AggregateFunction(quantilesDD(0.01, 0.5, 0.75, 0.9, 0.95, 0.99), UInt64) CODEC(ZSTD(1))\n)\nENGINE = MergeTree\n PARTITION BY toDate(unix_milli / 1000)\n ORDER BY (env, temporality, metric_name, fingerprint, unix_milli)\n TTL toDateTime(unix_milli/1000) + INTERVAL 2592000 SECOND DELETE\n SETTINGS ttl_only_drop_parts = 1; (details: code: 63, message: Unknown aggregate function quantilesDD. Maybe you meant: [‘quantiles’,‘quantilesGK’])“,”stacktrace”“main.main\n\t/home/runner/work/signoz otel collector/signoz otel collector/cmd/signozschemamigrator/migrate.go110\nruntime.main\n\t/opt/hostedtoolcache/go/1.20.14/x64/src/runtime/proc.go:250”}
s
You should upgrade the ClickHouse version to 24.1.2-alpine
153 Views