- What Grafana version and what operating system are you using?
version 9.5.7 on Linux Red Hat Enterprise 7
- What are you trying to achieve?
I am trying to upgrade from version 6.2.0 (5d16da7) to version 9.5.7
- How are you trying to achieve it?
I have downloaded the binaries for 9.5.7 into it’s own folder and updated the grafana ini file with the settings of the previous version ini file so that it points the existing grafana and influx databases.
- What happened?
Initially the upgrade appears to work and I can view the dashboards etc. Then after about a day when I launch the dashboards all I see is the following disaplyed in the Grafana URL
{“traceID”:“”}
- What did you expect to happen?
I expected the dashboard to continue working after the upgrade as it appears to do so.
- Can you copy/paste the configuration(s) that you are having problems with?
i haven’t been able to identify any configuration that could potentially be causing the issue.
- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
t=2023-09-22T00:00:37+0100 lvl=eror msg=“failed to fetch alert definitions” logger=ngalert err=“no such table: alert_rule”
t=2023-09-22T00:00:40+0100 lvl=eror msg=“unable to sync admin configuration” logger=ngalert err=“no such table: ngalert_configuration”
t=2023-09-22T00:00:44+0100 lvl=eror msg=“failed to load Alertmanager configurations” logger=ngalert.multiorg.alertmanager err=“no such table: alert_configuration”
t=2023-09-22T00:00:47+0100 lvl=eror msg=“failed to fetch alert definitions” logger=ngalert err=“no such table: alert_rule”
t=2023-09-22T00:00:56+0100 lvl=eror msg=“Failed to get settings” logger=context userId=0 orgId=1 uname= error=“no such column: uid”
t=2023-09-22T00:00:56+0100 lvl=eror msg=“Failed to get settings” logger=context userId=0 orgId=1 uname= error=“no such column: uid”
t=2023-09-22T00:00:56+0100 lvl=eror msg=“Request Completed” logger=context userId=0 orgId=1 uname= method=GET path=/ status=500 remote_addr=10.202.10.83 time_ms=2 size=1349 referer=
t=2023-09-22T00:00:56+0100 lvl=eror msg=“Request Completed” logger=context userId=0 orgId=1 uname= method=GET path=/d/JQ-gQeCik/fxinfohome status=500 remote_addr=10.202.10.83 time_ms=2 size=1349 referer=
t=2023-09-22T00:00:57+0100 lvl=eror msg=“Failed to get settings” logger=context userId=0 orgId=1 uname= error=“no such column: uid”
t=2023-09-22T00:00:57+0100 lvl=eror msg=“Failed to get settings” logger=context userId=0 orgId=1 uname= error=“no such column: uid”
t=2023-09-22T00:00:57+0100 lvl=eror msg=“Request Completed” logger=context userId=0 orgId=1 uname= method=GET path=/ status=500 remote_addr=10.202.10.116 time_ms=8 size=1349 referer=
t=2023-09-22T00:00:57+0100 lvl=eror msg=“Request Completed” logger=context userId=0 orgId=1 uname= method=GET path=/d/JQ-gQeCik/fxinfohome status=500 remote_addr=10.202.10.116 time_ms=7 size=1349 referer=
t=2023-09-22T00:00:57+0100 lvl=eror msg=“failed to fetch alert definitions” logger=ngalert err=“no such table: alert_rule”
t=2023-09-22T00:01:07+0100 lvl=eror msg=“failed to fetch alert definitions” logger=ngalert err=“no such table: alert_rule”
t=2023-09-22T00:01:16+0100 lvl=eror msg=“Failed to get settings” logger=context userId=0 orgId=1 uname= error=“no such column: uid”
t=2023-09-22T00:01:16+0100 lvl=eror msg=“Request Completed” logger=context userId=0 orgId=1 uname= method=GET path=/d/JQ-gQeCik/fxinfohome status=500 remote_addr=10.202.10.83 time_ms=3 size=1349 referer=
logger=ngalert.multiorg.alertmanager t=2023-09-05T03:41:08.310384476+01:00 level=error msg=“failed to load Alertmanager configurations” error=“no such table: alert_configuration”
logger=ngalert.scheduler t=2023-09-05T03:41:10.000578062+01:00 level=error msg=“Failed to update alert rules” error=“failed to get alert rules: failed to fetch alert rules: no such table: alert_rule”
logger=context userId=0 orgId=1 uname= t=2023-09-05T03:41:18.059197799+01:00 level=warn msg= error=“no such table: permission” traceID=
logger=context userId=0 orgId=1 uname= t=2023-09-05T03:41:18.059382837+01:00 level=warn msg= error=“no such table: permission” traceID=
logger=ngalert.scheduler t=2023-09-05T03:41:20.000642729+01:00 level=error msg=“Failed to update alert rules” error=“failed to get alert rules: failed to fetch alert rules: no such table: alert_rule”
- Did you follow any online instructions? If so, what is the URL?
No