Hi, only last 6-7 rolling days shows contantly in the enery dash board. Can't figure out what's going on.
#Years of data lost
echo adder
echo adder
Look like all devices only have a week history. I think I did something with recorder few months ago since my dB was about 15gb. Did not realized the energy was affected, I thought long therm statistics was something else. Can't find any recorder in configuration.yaml, could that be the reason?
solid umbra
Did you delete the database?
echo adder
No, but it got smaller at that time.
solid umbra
long term statistics (energy data) are not affected by the recorder
echo adder
I noticed it now when I tried to compared to last year.
solid umbra
it's in the same database but its a different table
echo adder
long term statistics (energy data) are not affected by the recorder
That what I thought but still only a week data. Today I have data back to 20th Nov, yesterday I had data back to 19th.
solid umbra
did you check dev tools -> statistics?
echo adder
Looks like it related to corupted database.
I have multiple files lite these.
home-assistant_v2.db.corrupt.2024-11-20T03:13:09.888273+00:00
solemn willow
Yeah that would do that. If the db can't be loaded it creates an empty new one (and renames old to .corrupt)
echo adder
I will try to do a .recover with sqlite and see if I can extract the old history.
The problem is I can't copy the home-assistant_v2.db.corrupt.2024-11-20T03:13:09.888273+00:00 file, not sure if it's possible to install sqlite in HA OS with SSH/Terminal?
solemn willow
Why can't it be copied?