I’m using Grafana Cloud to display data about a sewage lift station, including float status and pumping frequency and flows. The data comes from influx in the clould as well. Node red and influx handle the font end - and checking the data all is good, float statuses, pumping frequency and pumping flows, all good and what is to be expected. I have a series of time-series panels that show water elevations, power consumption, and flow data - those mostly work fine. I have added a series of gauges and stat displays that give the current Float Status (boolean), Pump Speed (analogue), and Flow Rate (Analogue), totalling 11 values. 4 of the 11 (3 analoges, 1 digital) are now unstable, they fluctuate between the value and zero (or false). Taking one of the analogue displays for example, editing it, showing the query data as a table will show the table flipping between the analogue value and zero every time it updates (every 5 seconds). I have no idea how to fix this, it looks like some kind of underlying data problem but the grafana cloud instance can’t be rebooted from what I can see.
To demonstrate, I opened a second window in grafana cloud and executed the same query that is supplying the gauges with their data and the screen shot shows below that the data is good but the pump 1 speed should be 60, not zero - and note the screwed up plotting of the mag meter flow in the time series.
I am wondering if the gauges are randomly picking up data from a different time period?
A few seconds later, the flow graph will correct as follows, see below. Can anyone suggest a fix for this strange behaviour?
After a bit more digging, I noticed the separate query screen mis-behaving as well, which is driving the bad screen data. It is randomly going back in time by 20 minutes, and then jumping back to the present time. The mag flow time series will go blank for a few seconds and will then return to the proper data display. Stumped on this one…
John
… To illustrate the issue, here is my grafana page screen shot taken at 1:33pm, note the different times in the panels, the three panels will change every few seconds to a correct, then a different time.
this is what a query on the influx data loos like, it looks fine:
I’m completely stumped here.
I have a series of gauges and stat panels in the bottom of my dashboard that should be displaying the “Last” values of time series data. This data is being sent to a cloud based influx db, and also I am sending it out to an MQTT broker every 10-20 seconds. I have tried display the data from an influx query, and now I tried to alternatively get the data directly from the MQTT broker.
In both data source setups, the data being displayed is not consistent, it randomly picks a different time period to query, I get ‘no data’ displays.
I have uploaded a video of what it looks like, see link below. The time was 12:15. You’ll see the mag flow (bottom left with a reading of 16.5 cu/hr, the ‘south flow’ gauge right next to it is the same data (showing zero), and the time series shows it to actually be zero, and the two bottom right panels are showing data from the influx time series, but the one on the right is using the wrong time at 11:46, then updates to the correct time. These panels seem to alternate picking up the incorrect time every few seconds.
Can anyone suggest the issue???
