I had to do a full snapshot restore but after it (no errors) and a HA restart, HACS is missing - even the /config/custom-components folder is gone. As half of my HA setup is based on HACS addons, this is unacceptable. Any tips as to what may have happened? Thanks!
Are you sure the snapshot you restored from was a full snapshot?
Yes I am, itâs even in the file name.
Yes, but I can name something âfull snapshotâ and it only contain a text file that says âfooled yaâ. Going off the name is meaningless.
When you created the snapshot, did it complete? Did you get errors? When you unzip the snapshot, does it contain those folders?
I´m not sure why the hostile tone but I didn´t create the snapshot, HA did and Hassio Google Drive Backup backed it up to Google and yes, it´s a complete backup. I can see the not-restored files in the homeassistant.tar.gz file inside it. It just didn´t restore. And yes, I did let it do its thing
What makes what I said hostile?
So the quickest solution would be to extract that information and place it back into your config.
As for why itâs not doing it, weâd need to see logs of the snapshot creation and logs when you restored the snapshot.
hi, curiously enough, HACS DID restore properly with second try with the same snapshot. So that´s solved.
Now, logbook and history don´t work - when accessed, the wait spinner just spins indefinitely. I´m using mariaDB, which gives me this log:
Error during connection setup: (MySQLdb._exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: CREATE INDEX ix_recorder_runs_start_end ON recorder_runs (start, end)] (Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
mariaDB addon does not display any error. I have uninstalled it and reinstalled, settings are correct (original)
Recorder settings are as follows:
recorder:
purge_interval: 1
purge_keep_days: 3
db_url: mysql://hass:a@core-mariadb/homeassistant?charset=utf8
What do I do? I should probably make this a new thread, right? Thanks!
EDIT: CORRECTION History does work, only Logbook doesn´t.
are there errors in your logs? Did you jump HA versions when updating/restoring? If you did, what did you go from and what did you go to? There was a database migration that was required recently. If you skipped that, youâll have problems.
Still smiling at the idea of what you asked as being in any way hostile. The OP should try support on some of the paid products out there. No fear of any hostility there as rarely do you receive a response to create any
This sounded really weird. I checked that it was a full snapshot. I guess thereâs no way Petro could have known that so I apologize. I am grateful for the support I and we all get here.
There are no errors in HA log about database, logbook, MariaDB or anything like that. There are also no errors in the MariaDB addon log. The error that I stated above is no longer present in the log:
Error during connection setup: (MySQLdb._exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: CREATE INDEX ix_recorder_runs_start_end ON recorder_runs (start, end)] (Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
When the error first appeared, there was no HA update. It started happening after restoring the snapshot, from 0.13.4 to 0.13.4 (or .3? the latest before 0.14), it did not happen before that. I then went on to upgrade to 0.14, problem still stands - accessing the logbook is just spinner spinning indefinitely.
have you cleared the cache on logbook, CTRL+F5? It doesnât make sense that logbook is failing when history is fine. Unless the table for logbook is broken. But youâd see errors in the logs. Worse case scenario is that youâll have to delete your entire history.
Iâll gladly zap it all and start fresh. Iâm not able to reach HA at the moment, how do I delete history/logbook? Thank you very much.
You have to delete your database. Iâm not sure how to do that with the addon as Iâve never used it.
Home Assistant 0.115.3. and 0.116.4. I tried twice recovery from full snapshot. And the hacs was presented but not activated (left-side bar). I wasn´t able to remove or add hacs again. Deleted every hacs file and after restart hack disappeard logically. But new installation didn´t finished with final left-side bar, tried twice. Useless recovery from clean install three times together. Only manully recovery step by step I was able to build my HA again. Hate HA.
I just did the restore twice. It worked the second time. HA is extremely stable otherwise, this is just a small nit.