Outdated values get recorded shortly after HA restart

[joel-bourquard]

The problem

I'm running the official HA 2025.2.4 Docker container on Linux x86-64.
After restarting HA twice in a row (docker compose down + up) within a few minutes, I observed that some monotonically increasing sensors suddenly had an outlier value in the recorder DB shortly after the 2nd restart. The server and database itself (MariaDB 10.11.11) were not restarted.

This issue seems independent of the integration that supplies the values (eg: Webhook, ModBus).

Among the symptoms: any statistics sensors with state_characteristic "sum_differences_nonnegative" will go crazy (and that's how I noticed the issue).

What version of Home Assistant Core has the issue?

core-2025.2.4

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant Container

Integration causing the issue

Recorder

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

Anything in the logs that might be useful for us?

Additional information

SQL query that I used to retrieve the values:
SELECT state, state_id, last_updated_ts, last_reported_ts FROM home_assistant.states WHERE metadata_id = (SELECT metadata_id FROM home_assistant.states_meta WHERE entity_id = 'sensor.THE_SENSOR_ID') AND last_updated_ts > 1739992700 AND last_updated_ts < 1739993300 ORDER BY last_updated_ts;

Example 1 (Webhook platform sensor, interval ~ 20s):

Data: webhook-meter-main.txt

Example 2 (Modbus sensor):

Data: modbus-meter-hp.txt

Exemple 3 (Modbus sensor):

Data: modbus-meter-wh.txt