Hi, After upgrading from 0.91.0 to 0.92.1, the signoz stateful set pod is not coming up and has following error. I'm using the signoz helm chart and updated from 0.88.2 to 0.88.3. I looked into these issues but they are a bit different: https://community-chat.signoz.io/t/27540294/hello-signoz-team-after-upgrading-community-edition-from-v0- https://community-chat.signoz.io/t/29208469/hi-team-i-ve-just-tried-to-update-signoz-0-85-3-helm-chart-v I have also attached the sql output based on the above outputs. Can you guide me how to solve this? Thank you.

{"timestamp":"2025-08-14T07:34:12.934214964Z","level":"INFO","code":{"function":"<http://github.com/SigNoz/signoz/pkg/signoz.New|github.com/SigNoz/signoz/pkg/signoz.New>","file":"/home/runner/work/signoz/signoz/pkg/signoz/signoz.go","line":75},"msg":"starting signoz","version":"v0.92.1","variant":"enterprise","commit":"9c95294","branch":"v0.92.1","go":"go1.23.11","timestamp":"2025-08-13T09:41:14Z"}
{"timestamp":"2025-08-14T07:34:12.93453486Z","level":"INFO","code":{"function":"<http://github.com/SigNoz/signoz/pkg/sqlstore/sqlitesqlstore.New|github.com/SigNoz/signoz/pkg/sqlstore/sqlitesqlstore.New>","file":"/home/runner/work/signoz/signoz/pkg/sqlstore/sqlitesqlstore/provider.go","line":44},"msg":"connected to sqlite","logger":"<http://github.com/SigNoz/signoz/pkg/sqlitesqlstore|github.com/SigNoz/signoz/pkg/sqlitesqlstore>","path":"/var/lib/signoz/signoz.db"}
{"timestamp":"2025-08-14T07:34:12.942122657Z","level":"ERROR","code":{"function":"<http://github.com/prometheus/prometheus/promql.NewActiveQueryTracker|github.com/prometheus/prometheus/promql.NewActiveQueryTracker>","file":"/home/runner/go/pkg/mod/github.com/prometheus/prometheus@v0.304.1/promql/query_logger.go","line":137},"msg":"Failed to create directory for logging active queries","logger":"<http://github.com/SigNoz/signoz/pkg/prometheus/clickhouseprometheus|github.com/SigNoz/signoz/pkg/prometheus/clickhouseprometheus>"}
{"timestamp":"2025-08-14T07:34:12.944462686Z","level":"INFO","code":{"function":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Migrate|github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Migrate>","file":"/home/runner/work/signoz/signoz/pkg/sqlmigrator/migrator.go","line":43},"msg":"starting sqlstore migrations","logger":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator|github.com/SigNoz/signoz/pkg/sqlmigrator>","dialect":"sqlite"}
{"timestamp":"2025-08-14T07:34:22.952830512Z","level":"ERROR","code":{"function":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock|github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock>","file":"/home/runner/work/signoz/signoz/pkg/sqlmigrator/migrator.go","line":112},"msg":"attempt to acquire lock failed","logger":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator|github.com/SigNoz/signoz/pkg/sqlmigrator>","error":"migrate: migrations table is already locked (UNIQUE constraint failed: migration_lock.table_name)","lock_interval":"10s","dialect":"sqlite"}
{"timestamp":"2025-08-14T07:34:32.952404837Z","level":"ERROR","code":{"function":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock|github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock>","file":"/home/runner/work/signoz/signoz/pkg/sqlmigrator/migrator.go","line":112},"msg":"attempt to acquire lock failed","logger":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator|github.com/SigNoz/signoz/pkg/sqlmigrator>","error":"migrate: migrations table is already locked (UNIQUE constraint failed: migration_lock.table_name)","lock_interval":"10s","dialect":"sqlite"}
{"timestamp":"2025-08-14T07:34:42.957006706Z","level":"ERROR","code":{"function":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock|github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock>","file":"/home/runner/work/signoz/signoz/pkg/sqlmigrator/migrator.go","line":112},"msg":"attempt to acquire lock failed","logger":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator|github.com/SigNoz/signoz/pkg/sqlmigrator>","error":"migrate: migrations table is already locked (UNIQUE constraint failed: migration_lock.table_name)","lock_interval":"10s","dialect":"sqlite"}
{"timestamp":"2025-08-14T07:34:52.952504059Z","level":"ERROR","code":{"function":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock|github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock>","file":"/home/runner/work/signoz/signoz/pkg/sqlmigrator/migrator.go","line":112},"msg":"attempt to acquire lock failed","logger":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator|github.com/SigNoz/signoz/pkg/sqlmigrator>","error":"migrate: migrations table is already locked (UNIQUE constraint failed: migration_lock.table_name)","lock_interval":"10s","dialect":"sqlite"}
{"timestamp":"2025-08-14T07:35:02.956952855Z","level":"ERROR","code":{"function":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock|github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock>","file":"/home/runner/work/signoz/signoz/pkg/sqlmigrator/migrator.go","line":112},"msg":"attempt to acquire lock failed","logger":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator|github.com/SigNoz/signoz/pkg/sqlmigrator>","error":"migrate: migrations table is already locked (UNIQUE constraint failed: migration_lock.table_name)","lock_interval":"10s","dialect":"sqlite"}
{"timestamp":"2025-08-14T07:35:12.956587175Z","level":"ERROR","code":{"function":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock|github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock>","file":"/home/runner/work/signoz/signoz/pkg/sqlmigrator/migrator.go","line":112},"msg":"attempt to acquire lock failed","logger":"<http://github.com/SigNoz/signoz/pkg/sqlmigrator|github.com/SigNoz/signoz/pkg/sqlmigrator>","error":"migrate: migrations table is already locked (UNIQUE constraint failed: migration_lock.table_name)","lock_interval":"10s","dialect":"sqlite"}
stream closed EOF for open-telemetry/signoz-0 (signoz)