influxdata / influxdata/influxdb

Data points not visible on grafana but present in DB after restart

Open
#21,054 0 comments 0 reactions 0 assignees View on GitHub
1.x
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

I have a Influxdb-grafana setup with a python script periodically adding data to influxdb. All of these were setup on my localhost and the dashboard was running fine showing the data. But after a system restart only the points post restart are visible on dashboard and all other points are shown as "no data".

The data is present in influxdb. I could verify the query results by influx CLI. However when I use query inspector in grafana, I don't get any results. On exploring the result data of the panel it shows "null" for all the timestamps before restart.

I have read so much about it but can't seem to figure out what issue is this and how a system restart affected the visualization even though the data is present. I tried creating a new user with all privileges for the data source connection.

I also tried copying the entire DB just to verify but even copied DB doesn't show any data when there are about 500K points. Please suggest me how to fix this.

__Expected behavior:__
Points to be shown in Grafana since they are seen on querying,
No data loss

__Actual behavior:__
Data loss for one months recent data.
data is not reflecting on grafana
copied database doesn't work

__Environment info:__

* System info: Windows OS
* InfluxDB version: 1.8.2

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the behavior with InfluxDB 1.8.2 and Grafana on Windows, then compare the Influx CLI results with the Grafana query inspector before and after a system restart. Check the panel data for the timestamps before the restart and verify whether the copied database behaves the same. Done means historical points render in Grafana without data loss.

Written by the indexing model from the issue text.

Assessment

Tech stack
grafana, python
Domain
databases, observability
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.