Hi Team,
After upgrading from 0.77.0 to 0.78.1, signoz-0 would not start up.
{"level":"fatal","timestamp":"2025-04-11T18:40:54.547Z","caller":"query-service/main.go:108","msg":"Failed to create signoz","error":"FOREIGN KEY constraint failed","stacktrace":"main.main\n\t/home/runner/work/signoz/signoz/ee/query-service/main.go:108\nruntime.main\n\t/opt/hostedtoolcache/go/1.22.12/x64/src/runtime/proc.go:271"}
We rolled back to 0.77.0, but alerting is no longer working.
If I open an Alert error dialogs pop up.
If I visit '/settings/channels' the text 'Something went wrong' is displayed.
"level":"ERROR","code":{"function":"<http://github.com/SigNoz/signoz/pkg/alertmanager.(*Service).SyncServers|github.com/SigNoz/signoz/pkg/alertmanager.(*Service).SyncServers>","file":"/home/runner/work/signoz/signoz/pkg/alertmanager/service.go","line":56},"msg":"failed to get alertmanager config for org","logger":"<http://github.com/SigNoz/signoz/pkg/alertmanager/signozalertmanager|github.com/SigNoz/signoz/pkg/alertmanager/signozalertmanager>","orgID":"blah-blah-blah-blah-blah","error":"sql: Scan error on column index 0, name \"id\": strconv.ParseUint: parsing \"blah-blah-blah-blah-blah\": invalid syntax"}
