The upgrade of 0.52.0 to 0.53.0 failed with this error. How can I fix this? I couldn't find any other help for this problem.

✘ Container otel-migrator          service "otel-collector-migrator" didn't complete successfully: exit 1

And the log of this container is

otel-migrator          | {"level":"info","timestamp":"2024-09-04T13:17:05.624Z","caller":"migrationmanager/manager.go:76","msg":"Running migrations for all migrators","component":"migrationmanager"}
otel-migrator          | {"level":"info","timestamp":"2024-09-04T13:17:05.624Z","caller":"migrationmanager/manager.go:78","msg":"Running migrations for logs","component":"migrationmanager","migrator":"logs"}
otel-migrator          | {"level":"error","timestamp":"2024-09-04T13:17:05.713Z","caller":"migrationmanager/manager.go:81","msg":"Failed to run migrations for migrator","component":"migrationmanager","migrator":"logs","error":"clickhouse migrate failed to run, error: Dirty database version 14. Fix and force version.","stacktrace":"<http://github.com/SigNoz/signoz-otel-collector/migrationmanager.(*MigrationManager).Migrate|github.com/SigNoz/signoz-otel-collector/migrationmanager.(*MigrationManager).Migrate>\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go:81\nmain.main\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/migrate.go:126\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.13/x64/src/runtime/proc.go:267"}
otel-migrator          | {"level":"fatal","timestamp":"2024-09-04T13:17:05.714Z","caller":"signozschemamigrator/migrate.go:128","msg":"Failed to run migrations","component":"migrate cli","error":"clickhouse migrate failed to run, error: Dirty database version 14. Fix and force version.","stacktrace":"main.main\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/migrate.go:128\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.13/x64/src/runtime/proc.go:267"}

@nitya-signoz please update the release notes include what do people need to perform upgrade.

Sure, let me do that.

@nitya-signoz Thanks! But that's a localhost URL. Is this already published somewhere?

My bad 🙈 , updated it

Thanks, it seems that it's working now. The change in clickhouse-config.xml was already enabled, but apparently the automatic migration still failed.