I just did a fresh install of Hass.io on Docker Ubuntu, but the Logbook and history stay empty.
I have this warning in the log
2018-10-19 16:31:43 WARNING (Recorder) [homeassistant.components.recorder.migration] Database requires upgrade. Schema version: None
I deleted home-assistant_v2.db and reboot didn’t fix.
Then I looked at the database looks:
root@virtualubuntu:/usr/share/hassio/homeassistant# sqlite3 home-assistant_v2.db “PRAGMA integrity_check”
ok
sqlite> SELECT * FROM schema_changes;
1|6|2018-10-19 06:29:02.801060
sqlite> SELECT count(*) from states;
48
Looks like the recorder is properly writing, data looks good inside.
I enable DEBUG log level on recorder and get
2018-10-19 17:07:53 DEBUG (Recorder) [homeassistant.components.recorder] Connected to recorder database
2018-10-19 17:14:27 DEBUG (SyncWorker_1) [homeassistant.components.recorder.util] converting 84 rows to native objects took 0.023768s
2018-10-19 17:14:29 DEBUG (SyncWorker_2) [homeassistant.components.recorder.util] converting 84 rows to native objects took 0.007865s
But somehow HA can not access to this data
Thanks in advance for your help
L.