Hi Team, I am trying to upgrade using helm chart f...
# support
s
Hi Team, I am trying to upgrade using helm chart from v0.71 (App Version 0.73.0) to v0.76.1 (App Version 0.78.1). I followed the migration guide. However, encountered two issues. 1. Startup issue for Signoz pod where the "notification_channels" cannot be found. 2. OtelCollector is not starting > 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 > > We had to rollback to the previous version as this is blocking the upgrade. Can you please assist ?
v
Hi @Sunil Deshpande can you please share the migration table entires and the current output for
.tables
command in sqlite. Thanks !
s
@Vikrant Gupta here is the output for
.tables
command from sqlite.
Copy code
sqlite> .tables
agent_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
explorer_queries                    reset_password_request
feature_status                      rules
groups                              saved_views
ingestion_keys                      sites
integrations_installed              ttl_status
invites                             user_flags
licenses                            user_preference
licenses_v3                         users
migration
sqlite>
sqlite>
SELECT * FROM migration;
1|000|1|2025-02-19 06:04:38
2|001|1|2025-02-19 06:04:38
3|002|1|2025-02-19 06:04:38
4|003|1|2025-02-19 06:04:38
5|004|1|2025-02-19 06:04:38
6|005|1|2025-02-19 06:04:38
7|006|1|2025-02-19 06:04:38
8|007|1|2025-02-19 06:04:38
9|008|1|2025-02-19 06:04:38
10|009|1|2025-02-19 06:04:38
sqlite>
v
please upgrade to version v0.77.0 first and then upgrade to to the latest version.
@Robbin @Sunil Deshpande
s
I'm having this issue also, i ran helm upgrade --namespace=platform my-release signoz/signoz -f npg.yaml --version 0.77.0 However, my pod signoz-0 is restarting with "msg":"Failed to create signoz","error":"no such table: notification_channel",
v
Did you try upgrading to the
app version - 77
first and then to the latest ?
s
Yes i did
Here is my helm history
Copy code
sqlite> .tables
agent_config_elements               migration_lock                    
agent_config_versions               notification_channels             
agents                              org_domains                       
alertmanager_config                 org_preference                    
alertmanager_state                  organizations                     
apdex_settings                      personal_access_tokens            
cloud_integrations_accounts         pipelines                         
cloud_integrations_service_configs  planned_maintenance               
dashboards                          reset_password_request            
data_migrations                     rules                             
feature_status                      saved_views                       
groups                              ttl_status                        
integrations_installed              user_invite                       
licenses_v3                         user_preference                   
migration                           users                             
sqlite> 
sqlite> 
sqlite> SELECT * FROM migration;
1|000|1|2025-02-08 17:09:46
2|001|1|2025-02-08 17:09:46
3|002|1|2025-02-08 17:09:46
4|003|1|2025-02-08 17:09:46
5|004|1|2025-02-08 17:09:46
6|005|1|2025-02-08 17:09:46
7|006|1|2025-02-08 17:09:46
8|007|1|2025-02-08 17:09:46
9|008|1|2025-02-08 17:09:47
10|009|1|2025-02-08 17:09:47
11|011|2|2025-02-26 11:34:43
12|012|2|2025-02-26 11:34:43
13|013|3|2025-04-30 07:10:49
14|014|3|2025-04-30 07:10:49
15|015|3|2025-04-30 07:10:49
16|016|3|2025-04-30 07:10:49
17|017|3|2025-04-30 07:10:49
18|018|3|2025-04-30 07:10:49
19|019|3|2025-04-30 07:10:49
20|020|3|2025-04-30 07:10:49
r
Upgrade to Signoz from v0.75 to v0.76 is succesful, at least. Thanks for the support from our end.
Upgrade to latest version from 0.76 also worked
s
@Vikrant Gupta can you kindly help?
v
@Samuel Olowoyeye you need to follow the same steps as @Robbin and @Sunil Deshpande, please correctly check your chart versions and app versions. make sure the helm rollback happened properly. • Upgrade to v0.76 ( SigNoz App Version ) • Upgrade to latest version from there
s
I followed the instruction, Kindly see this screenshot
Screenshot 2025-05-05 at 9.59.48 AM.png,Screenshot 2025-05-05 at 10.02.28 AM.png
@Vikrant Gupta @nitya-signoz could you kindly assist here