Hi Team, I am trying to do a fresh install of signoz (self-hosted) using helm chart version 0.57.0 (signoz appVersion 0.59.0). but schema-migrator sync and async init pods are failing with the same error as below.
Any idea what this error means? also, another question that I have - why is schema-migrator needed for a fresh setup of signoz?
Error message:
{"L":"info","timestamp":"2024-12-12T07:36:09.723Z","C":"signozschemamigrator/main.go:162","M":"Migrating up"}
{"L":"info","timestamp":"2024-12-12T07:36:09.723Z","C":"schema_migrator/manager.go:589","M":"Running migrations up sync"}
{"L":"info","timestamp":"2024-12-12T07:36:09.723Z","C":"schema_migrator/manager.go:551","M":"Checking if migration should run","db":"signoz_metrics","migration_id":1000,"versions":[]}
{"L":"info","timestamp":"2024-12-12T07:36:09.723Z","C":"schema_migrator/manager.go:568","M":"Fetching migration status","query":"SELECT * FROM signoz_metrics.schema_migrations_v2 WHERE migration_id = 1000 SETTINGS final = 1;"}
*{"L":"error","timestamp":"2024-12-12T07:36:09.724Z","C":"schema_migrator/manager.go:576","M":"Failed to fetch migration status","error":"code: 115, message: Unknown setting final","S":"<http://github.com/SigNoz/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator.(*MigrationManager).shouldRunMigration|github.com/SigNoz/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator.(*MigrationManager).shouldRunMigration>*\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator/manager.go:576\<http://ngithub.com/SigNoz/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator.(*MigrationManager).MigrateUpSync|ngithub.com/SigNoz/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator.(*MigrationManager).MigrateUpSync>\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator/manager.go:617\nmain.registerSyncMigrate.func1\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/main.go:163\<http://ngithub.com/spf13/cobra.(*Command).execute|ngithub.com/spf13/cobra.(*Command).execute>\n\t/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.8.1/command.go:985\<http://ngithub.com/spf13/cobra.(*Command).ExecuteC|ngithub.com/spf13/cobra.(*Command).ExecuteC>\n\t/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.8.1/command.go:1117\<http://ngithub.com/spf13/cobra.(*Command).Execute|ngithub.com/spf13/cobra.(*Command).Execute>\n\t/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.8.1/command.go:1041\nmain.main\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/main.go:70\nruntime.main\n\t/opt/hostedtoolcache/go/1.23.3/x64/src/runtime/proc.go:272"}
panic: code: 115, message: Unknown setting final
goroutine 1 [running]:
<http://github.com/SigNoz/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator.(*MigrationManager).shouldRunMigration(0xc0000e7520|github.com/SigNoz/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator.(*MigrationManager).shouldRunMigration(0xc0000e7520>, {0xcb5fa1, 0xe}, 0x3e8, {0x13b6a40, 0x0, 0x0})
/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator/manager.go:577 +0xb85
<http://github.com/SigNoz/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator.(*MigrationManager).MigrateUpSync(0xc0000e7520|github.com/SigNoz/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator.(*MigrationManager).MigrateUpSync(0xc0000e7520>, {0xe21c60, 0x13b6a40}, {0x13b6a40, 0x0, 0x0})
/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/schema_migrator/manager.go:617 +0x27a
main.registerSyncMigrate.func1(0xc0001ca608, {0xcb1c0b?, 0x4?, 0xcb1c0f?})
/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/main.go:163 +0xfe9
<http://github.com/spf13/cobra.(*Command).execute(0xc0001ca608|github.com/spf13/cobra.(*Command).execute(0xc0001ca608>, {0xc0001ce8a0, 0x3, 0x3})
/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.8.1/command.go:985 +0xaaa
<http://github.com/spf13/cobra.(*Command).ExecuteC(0xc0001ca308)|github.com/spf13/cobra.(*Command).ExecuteC(0xc0001ca308)>
/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.8.1/command.go:1117 +0x3ff
<http://github.com/spf13/cobra.(*Command).Execute(...)|github.com/spf13/cobra.(*Command).Execute(...)>
/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.8.1/command.go:1041
main.main()
/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/main.go:70 +0x1f9
