Grafana Version: “Currently using Grafana v8.5.2”
-
Upgrade/Downgrade Steps:
“Upgraded to v10.0.3, then downgraded to v8.5.2” -
Configuration Changes:
No significant configuration changes during the downgrade. -
Logs:
Logs show Grafana stopping at ‘Connecting to DB’ with the messagedbtype=sqlite3. -
Operating System:
“Running Grafana on Ubuntu 20.04”
We performed OSS Upgrade on our VM, due to that Grafana also got upgraded to the latest version, Grafana v10.0.3, with the latest version, Alerting functionality was not compatible with the use case we implemented in our project. Hence we downgraded to the earlier version we were using Grafana v8.5.2. After downgrading we are seeing issues with Grafana, UI is not loading and from the logs we see that it is stopping till “Connecting to DB” dbtype=sqlite3" and not proceeding further.
Issue occurs consistently after downgrading from v10.0.3 to v8.5.2 and restarting Grafana service. Expected Grafana v8.5.2 to load UI normally. Actual behavior is UI not loading, stuck at ‘Connecting to DB’.
Kindly suggest how to proceed further.
Attached are the log files and Grafana.ini config file.
Blockquote
GarfanaAdmin@CNAS-GRAFANA:/var/log/grafana$ sudo tail -100 grafana.log
logger=settings t=2023-10-03T14:52:32.23+0000 lvl=info msg=“App mode production”
logger=sqlstore t=2023-10-03T14:52:32.23+0000 lvl=info msg=“Connecting to DB” dbtype=sqlite3
logger=settings t=2023-10-03T14:52:33.77+0000 lvl=info msg=“Starting Grafana” version=8.5.2 commit=90701be19 branch=HEAD compiled=2022-05-03T07:44:14Z
logger=settings t=2023-10-03T14:52:33.77+0000 lvl=info msg=“Config loaded from” file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2023-10-03T14:52:33.78+0000 lvl=info msg=“Config loaded from” file=/etc/grafana/grafana.ini
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.data=/var/lib/grafana”
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.logs=/var/log/grafana”
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.plugins=/var/lib/grafana/plugins”
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.provisioning=/etc/grafana/provisioning”
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Path Home” path=/usr/share/grafana
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Path Data” path=/var/lib/grafana
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Path Logs” path=/var/log/grafana
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Path Plugins” path=/var/lib/grafana/plugins
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Path Provisioning” path=/etc/grafana/provisioning
logger=settings t=2023-10-03T14:52:33.79+0000 lvl=info msg=“App mode production”
logger=sqlstore t=2023-10-03T14:52:33.79+0000 lvl=info msg=“Connecting to DB” dbtype=sqlite3
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Starting Grafana” version=8.5.2 commit=90701be19 branch=HEAD compiled=2022-05-03T07:44:14Z
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Config loaded from” file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Config loaded from” file=/etc/grafana/grafana.ini
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.data=/var/lib/grafana”
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.logs=/var/log/grafana”
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.plugins=/var/lib/grafana/plugins”
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.provisioning=/etc/grafana/provisioning”
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Path Home” path=/usr/share/grafana
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Path Data” path=/var/lib/grafana
logger=settings t=2023-10-03T14:59:09.14+0000 lvl=info msg=“Path Logs” path=/var/log/grafana
logger=settings t=2023-10-03T14:59:09.15+0000 lvl=info msg=“Path Plugins” path=/var/lib/grafana/plugins
logger=settings t=2023-10-03T14:59:09.15+0000 lvl=info msg=“Path Provisioning” path=/etc/grafana/provisioning
logger=settings t=2023-10-03T14:59:09.15+0000 lvl=info msg=“App mode production”
logger=sqlstore t=2023-10-03T14:59:09.15+0000 lvl=info msg=“Connecting to DB” dbtype=sqlite3
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Starting Grafana” version=8.5.2 commit=90701be19 branch=HEAD compiled=2022-05-03T07:44:14Z
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Config loaded from” file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Config loaded from” file=/etc/grafana/grafana.ini
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.data=/var/lib/grafana”
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.logs=/var/log/grafana”
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.plugins=/var/lib/grafana/plugins”
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.provisioning=/etc/grafana/provisioning”
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Path Home” path=/usr/share/grafana
logger=settings t=2023-10-03T14:59:10.95+0000 lvl=info msg=“Path Data” path=/var/lib/grafana
logger=settings t=2023-10-03T14:59:10.96+0000 lvl=info msg=“Path Logs” path=/var/log/grafana
logger=settings t=2023-10-03T14:59:10.96+0000 lvl=info msg=“Path Plugins” path=/var/lib/grafana/plugins
logger=settings t=2023-10-03T14:59:10.96+0000 lvl=info msg=“Path Provisioning” path=/etc/grafana/provisioning
logger=settings t=2023-10-03T14:59:10.96+0000 lvl=info msg=“App mode production”
logger=sqlstore t=2023-10-03T14:59:10.96+0000 lvl=info msg=“Connecting to DB” dbtype=sqlite3
logger=settings t=2023-10-03T14:59:12.56+0000 lvl=info msg=“Starting Grafana” version=8.5.2 commit=90701be19 branch=HEAD compiled=2022-05-03T07:44:14Z
logger=settings t=2023-10-03T14:59:12.56+0000 lvl=info msg=“Config loaded from” file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2023-10-03T14:59:12.56+0000 lvl=info msg=“Config loaded from” file=/etc/grafana/grafana.ini
logger=settings t=2023-10-03T14:59:12.56+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.data=/var/lib/grafana”
logger=settings t=2023-10-03T14:59:12.56+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.logs=/var/log/grafana”
logger=settings t=2023-10-03T14:59:12.56+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.plugins=/var/lib/grafana/plugins”
logger=settings t=2023-10-03T14:59:12.56+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.provisioning=/etc/grafana/provisioning”
logger=settings t=2023-10-03T14:59:12.57+0000 lvl=info msg=“Path Home” path=/usr/share/grafana
logger=settings t=2023-10-03T14:59:12.57+0000 lvl=info msg=“Path Data” path=/var/lib/grafana
logger=settings t=2023-10-03T14:59:12.57+0000 lvl=info msg=“Path Logs” path=/var/log/grafana
logger=settings t=2023-10-03T14:59:12.57+0000 lvl=info msg=“Path Plugins” path=/var/lib/grafana/plugins
logger=settings t=2023-10-03T14:59:12.57+0000 lvl=info msg=“Path Provisioning” path=/etc/grafana/provisioning
logger=settings t=2023-10-03T14:59:12.57+0000 lvl=info msg=“App mode production”
logger=sqlstore t=2023-10-03T14:59:12.57+0000 lvl=info msg=“Connecting to DB” dbtype=sqlite3
logger=settings t=2023-10-03T14:59:13.86+0000 lvl=info msg=“Starting Grafana” version=8.5.2 commit=90701be19 branch=HEAD compiled=2022-05-03T07:44:14Z
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Config loaded from” file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Config loaded from” file=/etc/grafana/grafana.ini
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.data=/var/lib/grafana”
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.logs=/var/log/grafana”
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.plugins=/var/lib/grafana/plugins”
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.provisioning=/etc/grafana/provisioning”
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Path Home” path=/usr/share/grafana
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Path Data” path=/var/lib/grafana
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Path Logs” path=/var/log/grafana
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Path Plugins” path=/var/lib/grafana/plugins
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Path Provisioning” path=/etc/grafana/provisioning
logger=settings t=2023-10-03T14:59:13.88+0000 lvl=info msg=“App mode production”
logger=sqlstore t=2023-10-03T14:59:13.88+0000 lvl=info msg=“Connecting to DB” dbtype=sqlite3
logger=settings t=2023-10-03T14:59:15.08+0000 lvl=info msg=“Starting Grafana” version=8.5.2 commit=90701be19 branch=HEAD compiled=2022-05-03T07:44:14Z
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Config loaded from” file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Config loaded from” file=/etc/grafana/grafana.ini
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.data=/var/lib/grafana”
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.logs=/var/log/grafana”
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.plugins=/var/lib/grafana/plugins”
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.provisioning=/etc/grafana/provisioning”
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Path Home” path=/usr/share/grafana
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Path Data” path=/var/lib/grafana
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Path Logs” path=/var/log/grafana
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Path Plugins” path=/var/lib/grafana/plugins
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Path Provisioning” path=/etc/grafana/provisioning
logger=settings t=2023-10-03T14:59:15.09+0000 lvl=info msg=“App mode production”
logger=sqlstore t=2023-10-03T14:59:15.09+0000 lvl=info msg=“Connecting to DB” dbtype=sqlite3
logger=settings t=2023-10-03T14:59:16.34+0000 lvl=info msg=“Starting Grafana” version=8.5.2 commit=90701be19 branch=HEAD compiled=2022-05-03T07:44:14Z
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Config loaded from” file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Config loaded from” file=/etc/grafana/grafana.ini
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.data=/var/lib/grafana”
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.logs=/var/log/grafana”
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.plugins=/var/lib/grafana/plugins”
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Config overridden from command line” arg=“default.paths.provisioning=/etc/grafana/provisioning”
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Path Home” path=/usr/share/grafana
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Path Data” path=/var/lib/grafana
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Path Logs” path=/var/log/grafana
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Path Plugins” path=/var/lib/grafana/plugins
logger=settings t=2023-10-03T14:59:16.35+0000 lvl=info msg=“Path Provisioning” path=/etc/grafana/provisioning
logger=settings t=2023-10-03T14:59:16.36+0000 lvl=info msg=“App mode production”
logger=sqlstore t=2023-10-03T14:59:16.36+0000 lvl=info msg=“Connecting to DB” dbtype=sqlite3
Attached is the config file of the current version-
