Hello Signoz Team, after upgrading community editi...
# supportr
Robbin
04/14/2025, 9:58 AMHello Signoz Team, after upgrading community edition from v0.75 to v0.78.1 using the migration guide, we run into a startup issue of the Signoz pod where the "notification_channels" cannot be found.
Checking the SQLite DB file in both old/new situation the table is definitely there. This is blocking the upgrade and we had to rollback to old version.
Can you please assist ?
signoz {"timestamp":"2025-04-10T084133.948704249Z","level":"INFO","code":{"function":"github.com/SigNoz/signoz/pkg/sqlmigrator.(*migrator).Lock","file":"/home/runner/work/signoz/signoz/pkg/sqlmigrator/migrator.go","line":90},"msg":"acquired migration lock","logger":"github.com/SigNoz/signoz/pkg/sqlmigrator","dialect":"sqlite"} │
│ signoz {"level":"fatal","timestamp":"2025-04-10T084133.973Z","caller":"query-service/main.go:108","msg":"Failed to create signoz","error":"no such table: notification_channel","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"}
v
Vikrant Gupta
04/19/2025, 3:04 AMHey @Robbin can you please share the migration table entries for the sqlite DB and the current table names you have in sqlite
m
Mike McCune
05/07/2025, 2:16 AMI have the exact same problem. My SQlite tables are:
Mike McCune
05/07/2025, 2:17 AMagent_config_elements migration_lock
agent_config_versions notification_channels
agents org_domains
apdex_settings org_preference
cloud_integrations_accounts organizations
cloud_integrations_service_configs personal_access_tokens
dashboards pipelines
data_migrations planned_maintenance
feature_status reset_password_request
groups rules
ingestion_keys saved_views
integrations_installed sites
invites ttl_status
licenses user_preference
licenses_v3 users
migration
Mike McCune
05/07/2025, 2:33 AM{"level":"fatal","timestamp":"2025-05-07T023045.766Z","caller":"query-service/main.go:122","msg":"Failed to create signoz","error":"no such table: notification_channel","stacktrace":"main.main\n\t/home/runner/work/signoz/signoz/ee/query-service/main.go122\nruntime.main\n\t/opt/hostedtoolcache/go/1.22.12/x64/src/runtime/proc.go271"}
v
Vikrant Gupta
05/07/2025, 6:56 AM@Mike McCune please follow the steps mentioned here - https://signoz-community.slack.com/archives/C01HWQ1R0BC/p1745225054447769?thread_ts=1744948842.481029&cid=C01HWQ1R0BC
109 Views