Hello Signoz team, I'm trying to upgrade my docker standalone instance from version 0.48.1 to version 0.87.0. It's not clear to me which is the correct upgrade path... From this link https://signoz.io/docs/operate/migration/, I see that the most recent version to upgrade to is the 0.76.0 and starting from this the upgrade path I want to follow is: upgrading from 0.48.1 to 0.70.0, then to 0.76.0 and finally to 0.87.0, is this correct? I started with the first upgrade (from 0.48.1 to 0.70.0) and I'm immediately getting this error on the signoz-schema-migrator:0.111.24

{"L":"info","timestamp":"2025-06-18T09:46:00.897Z","C":"schema_migrator/manager.go:868","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))

Am I missing something? I should run some db migration before trying to upgrade to 0.70.0? Thanks in advance for your support

Hey @Leonardo Agueci, yeah, right, you to upgrade the version step by step, i.e > you need to run these migration scripts step by step. For example if you are currently on

0.8.2

and want to migrate to

0.10.0

- you need to run migration script for

0.9

first and then

0.10

ok, then I have to run each step manually? is there any automatic way of doing it?

No, you need to run the mention step for each migration manually

ok thanks