Xiaomi temperature sensor has no history

[baden03 (Baden)]

I am also noticing this on two home assistant setups. The currently using deCONZ 6.5.0 with ConBee II as the Zigbee hub on both.

Checking the logs:

Logger: homeassistant.components.recorder
Source: components/recorder/init.py:509
Integration: Recorder (documentation, issues)
First occurred: 7:08:55 PM (405 occurrences)
Last logged: 8:39:54 PM

Error saving events: (sqlite3.DatabaseError) database disk image is malformed
Background on this error at: Error Messages — SQLAlchemy 1.3 Documentation

Update: this lead me to a good thread:

DB image malformed. How to fix it?

Hi, after some hussel around sd card images (i.e. restoring snapshots) and some updates this errors occures: 2018-11-01 22:37:01 ERROR (SyncWorker_4) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_c…

In short: ssh in, delete the db (yes, along with it all history) and then restart HA.