History Errors Venus 3.7 - Unhandled database error while processing task StatisticsTask

[kcoffau]

HA 2026.2.3 reports History Errors and stops reporting history across entire of HA. Reporting Unhandled database error while processing task StatisticsTask

Environment

• Home Assistant Core release with the issue: 2026.2.3
• Last working Home Assistant Core release (if known):
• Integration version causing this issue: 0.6.4 (Venus 3.7.0)

Problem-relevant configuration dialog

Traceback/Error logs

sqlalchemy.exc.ProgrammingError: (sqlite3.ProgrammingError) Error binding parameter 3: type 'TextReadEntityType' is not supported
[SQL: INSERT INTO statistics_meta (statistic_id, source, unit_of_measurement, unit_class, has_mean, has_sum, name, mean_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING id]
[parameters: ('sensor.victronvebus_microgrid_error227', 'recorder', <custom_components.victron.const.TextReadEntityType object at 0x7fab540aa190>, None, None, 0, None, <StatisticMeanType.ARITHMETIC: 1>)]
(Background on this error at: https://sqlalche.me/e/20/f405)

In case of unit ID issue, missing devices or non-updating devices

Additional information

[stefanbode]

Looks similar to #420

[kcoffau]

yeah I fixed it... but.... its intermittent... im not having second guesses about my PR #419

[kcoffau]

I rolled back and it fell apart. Ive made another change. Will let it run for a while and see if that fixes it again.

[kucerazdenek]

currently running victron OS 3.66, HA 2026.2.3 and integration version 6.4.
Is it possible to safely upgrade to venus OS 3.70/3.71, without affecting HA current and historic data?

[kcoffau]

#419 and #424 together resolve this bug.
@sfstar fyi.