Any issues in dev tools statistics | Home Assistant | Page 1

ember kraken Oct 11, 2023, 11:58 AM

#

Thoufght I'd thread instead.
OK I've "fixed" those issues" but it definitely looks like the recorder has gotten into a weird/bad state.

gaunt plume Oct 11, 2023, 12:15 PM

#

not sure what that means

#

but if you dont mind deleting all your data you can always delete the database file

ember kraken Oct 11, 2023, 3:04 PM

#

ah ok, I'm using PostgreSQL, so I probably need to shell in and delete the broken rows. Or you know. Just drop the DB. 👍

gaunt plume Oct 11, 2023, 3:05 PM

#

Ok, I recommend using the built in db because it is highly optimized to be used with HA

ember kraken Oct 11, 2023, 8:44 PM

#

This definitely isn't a Pg error though. Which is good. Looks like some migrations didn't work for a particular set of entities. And they've got duplicate keys so I need to go remove them all

#

What about sqlite makes it highly optimized?

gaunt plume Oct 11, 2023, 8:59 PM

#

no idea, im not a backend dev. But that's what the HA devs say all the time

ember kraken Oct 11, 2023, 9:56 PM

#

Good to know.
It's probably because they spend a lot of time making sure it doesn't do things like wreck SD cards.

Which thankfully doesn't effect me given my, slightly over the top setup 😂
I might just drop the recorder db and upgrade postgresql tomorrow.
I've removed about 20 rows and counting in the statistics table which were throwing unique constraint errors. And right now that's all down to one integration.

gaunt plume Oct 11, 2023, 9:59 PM

#

yup, its developed with raspberry pi in mind since that's the majority of the users

#Any issues in dev tools statistics