https://signoz.io logo
Join Slack
Powered by
Hi, I’m migrating from an old signoz version to th...
# support
r
Hi, I’m migrating from an old signoz version to the latest one, I have this issue:
Copy code
✘ Container otel-migrator-sync  service "otel-collector-migrator-sync" didn't complete successfully: exit 1                                                                                                               0.0s
I saw the same issue in github here. I tried to delete the 
data/clickhouse/
contents with which returns:
Copy code
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/.gitkeep': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/user_scripts': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/tmp': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/user_files': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/format_schemas': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/preprocessed_configs': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/uuid': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/flags': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/dictionaries_lib': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/data': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/metadata': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/metadata_dropped': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/rocksdb': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/access': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/store': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/user_defined': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/named_collections': Permission denied
rm: cannot remove 'docker/clickhouse-setup/data/clickhouse/status': Permission denied
Has someone had this issue?
Here is the log for the failed container
Copy code
{"L":"info","timestamp":"2024-11-26T17:18:28.192Z","C":"schema_migrator/manager.go:804","M":"Inserting migration entry","query":"INSERT INTO signoz_metrics.distributed_schema_migrations_v2 (migration_id, status, created_at) VALUES (1000, 'in-progress', '2024-11-26 17:18:28')"}
{"L":"info","timestamp":"2024-11-26T17:18:28.195Z","C":"schema_migrator/manager.go:861","M":"Running operation","sql":"ALTER TABLE signoz_metrics.time_series_v4_1week ON CLUSTER cluster ADD COLUMN IF NOT EXISTS attrs Map(LowCardinality(String), String) DEFAULT map() CODEC(ZSTD(1))"}
{"L":"info","timestamp":"2024-11-26T17:18:28.256Z","C":"schema_migrator/manager.go:810","M":"Updating migration entry","query":"ALTER TABLE signoz_metrics.schema_migrations_v2 ON CLUSTER cluster UPDATE status = $1, error = $2, updated_at = $3 WHERE migration_id = $4","status":"failed","error":"code: 60, message: There was an error on [clickhouse:9000]: Code: 60. DB::Exception: Could not find table: time_series_v4_1week. (UNKNOWN_TABLE) (version 24.1.2.5 (official build))","migration_id":1000}
Error: code: 60, message: There was an error on [clickhouse:9000]: Code: 60. DB::Exception: Could not find table: time_series_v4_1week. (UNKNOWN_TABLE) (version 24.1.2.5 (official build))
I deleted them with sudo, ran again and is working lol
My dashboards are gone 😢
There needs to be a better way to upgrade versions
an auto-upgrader haha
192 Views
Open in Slack
PreviousNext
Powered by