Restarting HA creates dublicate entries with wrong timestamp in the InFlux DB

[VasMan]

Problem/Motivation

I use InFluxDB and Grafana to store and visualise multiple data from sensors and external feeds (e.g. Apple Health Data). However, every time HA restarts it creates a duplicate entry of the last data that came in but with the wrong timestamp, the newtime stamp is the one when HA was restarted and not when the data first came in.

Expected behavior

When HA restarts it should not reload the old data with a different timestamp.

Actual behavior

As per problem description above, I see loads of duplicates with wrong timestamp that completely bias and distorts my statistics

Steps to reproduce

Check the data in the database for any input, e.g. Apple Health Data or Strava, see if you have any numbers showing for today, and when was the last number. If you have no data from today but had data yesterday, then restart HA and observe that the today's value will change from no data to what was the last value yesterday.

Proposed changes

As per description when HA restarts do not auto-reload all the data with new timestamp, either dont load at all or use the timestamp when the data first entered.

[github-actions]

There hasn't been any activity on this issue recently, so we clean up some of the older and inactive issues.
Please make sure to update to the latest version and check if that solves the issue. Let us know if that works for you by leaving a comment 👍
This issue has now been marked as stale and will be closed if no further activity occurs. Thanks!

[VasMan]

No problem is still there