Tableplus postgres5/31/2023 I see you posted a bug report in github, that is probably a good path to an answer. So if that in fact works, HA does not care about the previous ‘old_state_id’ values not being available when it build a new SQLite DB. I am pretty sure the default ‘fix’ when your SQLite DB gets corrupt is to simply shut down HA, delete the database file and restart HA. Might be a bug in HA with it’s Postgresql integration. But I can query these as well externallly with no issues. These are what I mostly query, leaving the main states and events table to HA’s use. But I also archive all my history to Postgresql archive tables. I let HA purge the database using it’s standard function. I have 54 million records in my states table for 65 days of history. I am using Postgresql docker image created by postgresql people on docker hub. If so, I would think there is something amiss with the Postgresql image you are using. There was a big database change back a couple releases ago, changing what was stored in the events table.Ī pain to do, but is it possible for you to temporarily switch to a clean Postgresql VM and let HA build it’s tables from zero. I have only these tables as created by HA in Postgresql database homeassistant: The message seems to reference a table I do not have.
0 Comments
Leave a Reply. |