Historical reporting/recording glitches

[stk21]

The problem

The ingest of historical data into the database seems to glitch, or stop recording. This usually happens about 4am ish, every other day or sometimes daily.

Here is a temp graph

Here is an energy graph

This also effects the energy dashboard reporting

Home assistant was rebooted at 6:10 am, and reporting resumed. Last report before the pause was ~4am

This started in the 2022.7 release.

I searched but didnt find a similar issue.

What version of Home Assistant Core has the issue?

core-2022.8.1

What was the last working version of Home Assistant Core?

core-2022.6.x

What type of installation are you running?

Home Assistant Supervised

Integration causing the issue

effects all things that are recording history

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

No response

Additional information

No response