Dashboard is frozen - no recent changes

Grafana PostgreSQL
1

When I try to load my Grafana dashboard today, it immediately freezes and the page becomes unresponsive. I can’t click anything. Only a couple panels show data before it freezes, and the rest of the panels are stuck with the rotating arrows.

I have not changed anything on the dashboard recently. It was working fine the last couple days. My browser is up to date Chrome.

How do I fix this? How do I determine what is causing the problem? I opened Chrome dev tools and don’t see any errors in the console. Is there a log somewhere?

I only have the Stat Panel and DataTables plugins installed. I saw the DataTables plugin was unsigned, so I removed it from the Grafana account settings page thinking maybe that was the problem, but no change. I am using the latest version of Grafana.

Any ideas?

1 Like
2

Interesting. I too have an unresponsive dashboard, after weeks of it working perfectly, and having changed nothing.

All my other dashboards are fine, however. Do you have any other dashboards, and, if yes, are they similarly affected?

JJ

3

Experiencing this too after updating to Grafana 7.3.2. A quick look at the debugger shows that it’s stuck in this for loop in BizCharts.js:

It’s trying to loop to Infinity.

1 Like
4

If you have a stats panel whose values are all 0, this causes a hanging issue fixed in this commit (and will presumably be in the next release): https://github.com/grafana/grafana/commit/01a4951da08dc144f93d927cc53cb2817952de83

1 Like
5

When I opened my laptop, I happened to have a tab open with my Grafana dashboard that had been there a few days. On another tab, I copied over one panel at a time to see what the problem was. Sure enough, I have 2 stat panels that both cause the page to freeze immediately. Both are a time series. I was able to grab the json for the entire dashboard from my tab that hadn’t been refreshed. If I omit the two stat panels causing issues, I can import the whole dashboard as a new dashboard and all works great.

I did a quick test with a new stat panel. The query is:

SELECT
created AS "time",
field2
FROM table_name
WHERE
$__timeFilter(created)

If field2 returns a null value (or maybe it is if all the values are null?), it immediately freezes.

So this does sound like this may be the same bug @fe1lann mentioned.

I did notice however, if the above query does not return a null value for field2, the stat panel shows No Data. I know the query should return rows. I have the stat panel calculation set to Count. Not sure if there is an issue with the $__timeFilter() or if something changed with the latest version? Maybe it’s all related to the same bug?

1 Like
6

Actually figured out my stat panel “no data” issue. For a workaround, since I am just counting rows returned, I just updated my query to:

SELECT
created AS "time", 1
FROM table_name
WHERE
$__timeFilter(created)

If the field2 column was not numeric, I was getting No Data. So I just set it to 1, and it works great. If I set it to 0 instead of 1, it freezes, so the bug mentioned above is definitely the issue.

2 Likes