Hi,
am running HA In a docker on my QNAP NAS. I’d set up a few integrations and built some automations and everything was running fine, but suddenly I notived my motion sensors weren’t triggering. I went into my logs and saw the following:
‘’’
2023-01-04 15:34:45.151 WARNING (Recorder) [homeassistant.components.recorder.util] The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly
2023-01-04 15:34:45.279 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=3 from 2023-01-04 14:22:00.468137)
2023-01-04 15:34:56.882 WARNING (MainThread) [homeassistant.config_entries] Config entry ‘LG webOS TV 2F8A’ for homekit_controller integration not ready yet: Timeout while waiting for connection to device 192.168.1.183:46441; Retrying in background
‘’’
I googled the sqlite error and it seemed to suggest that its a corrupted database issue and best solution is to wipe that file. I deleted it using WinSCP, and I had a backup from a few days ago so tried to upload that file which was definitely when it was working fine, but every time I upload that version it gives me an error in the logs stating it is corrupt, is there something I need to do in order to be able to restore a backup version or certain permissions i need to give the file if this happens again?