All my history is gone

Configuration
#1

someone experience that issue? I can’t see any history of any entity

#2

Did you delete your database ?

#3

no, I don’t know where that database is
and if so it should have been start the statistics by now

#4

Check the log for database errors.

#5

were I can found the logs?

#6

Developer Tools > Logs. If you see something like “database disk image is malformed” delete home-assistant_v2.db in the same directory as configuration.yaml and then restart home assistant.

1 Like
#7

thanks, indeed I had that error and deleting the file solved the issue
why this is happened?

#8

Can happen for a number of reasons. The most common as far as I know is after a snapshot restore.

#9

thank you that helped me fixed my issue :slight_smile:

#10
  1. I could not find Developer Tools > Logs.
  2. I went forward and deleted the home-assistant-v2.db
  3. After restart I could see history again, but there is no previous history.

Question: can it be restored from a backup?

#11

If it’s not corrupted in your backup, yes.

1 Like
#12

SQL lite is just a file

#13

It has moved to Configuration / Settings

1 Like
#14

thank you so much

#15

I have this issue and have no errors in the log? any pointers?