Restored Backup does not contain configurations

tiko · May 10, 2025, 11:12am

Hey guys,

I recently tried to move my HomeAssistant installation and therefore created a backup on my currently running instance. In the backup settings I enabled everything, so that the HomeAssistant settings, Media, Share folder and all add-ons are backed up.

The backup went fine and was uploaded to my OneDrive and my NAS just as I configured it to. The backup is around 1.8 GB big which looked like a reasonable size to me.

So I left it there. I created a new VM following the HomeAssistant Guide and everything went fine as well. On the welcome screen I chose to restore a backup and uploaded the .tar file. It took about 20 minutes and after that I could login to my instance.

There I noticed that it was started in safe mode. When I looked into the error I noticed that not all my configuration files were present on the new instance.

My configuration.yaml is split into multiple files and is using include statements to use those files in the main configuration.yaml.
However those extra files are completely missing.
As the configuration depends on those extra files the startup could obviously not be successful.

Besides that many other folder which were under /config are missing in the restored instance (e.g. /config/custom_components or /config/packages

Now my question is why those files are missing and if I did anything wrong?

Thanks in advance for any help!

EDIT: Added screenshots of config folder contents

This is the content of my config folder in the old instance.

This is the content of my config folder in the new instance where the backup was restored

Mikefila · May 10, 2025, 3:23pm

Have you looked at the backup you restored to see what files are in the backup? When you open the back up look in homeassistant.tar.gz. Keep opening the folders, everything from config should be in \homeassistant.tar.gz\homeassistant.tar\data\

tiko · May 10, 2025, 5:11pm

I did try to do that but wasn’t able to extract the homeassistant.tar.gz and got the error that it’s not valid data. When I tried to extract it I got an error that it isn’t a in the gz format.

That’s when I thought that my backup might be corrupt but if so I do not understand, why the original config.yaml is correctly imported.

Mikefila · May 10, 2025, 5:22pm

What program are you using? 7zip? That is what I use and if I click on the file I get an error. I have to right click on the file and from the 7zip menu choose open archive. Then it opens.

tiko · May 10, 2025, 5:32pm

I am using Linux and tried to extract it using tar -xvzf homeassistant.tar.gz which let to

gzip: stdin: not in gzip format
tar: Child returned status 1
tar: Error is not recoverable: exiting now

I also tried this which explains that it might be only a tar file but no luck with that.
When I execute file homeassistant.tar.gz the output is only data.

The same problem occurs with all other tar.gz files in that backup.

I will try to open the file in Windows now.

tiko · May 10, 2025, 5:52pm

When I try it under windows as you described I also get the error that it could not be opened as a gzip archive because it is not an archive.

I really think my backup ist broken BUT I already created a second, manual, backup. With that I get the same error so for me it seems like it is some underlying process that does not work for me.

And I still do not understand, why the original config.yaml is correct

tiko · May 10, 2025, 6:11pm

It’s the same for at least three others of my backups, of which all were done with Core 2025.4.4.

These are my backup settings

I do not see anything suspicious in the Core or Supervisor logs when I am creating a backup.
What I did find interesting was something in the host logs:

2025-05-10 18:09:55.089 homeassistant kernel: get_swap_device: Bad swap file entry 4003ffffffffffff
2025-05-10 18:09:55.125 homeassistant kernel: get_swap_device: Bad swap file entry 4003ffffffffffee

This was printed thousands of times before calming down, but I do not really see the reason where this might be leading to a broken backup

EDIT

I looked into the logs a little bit more and did find something that might explain the corrupt backups. It looks like my recorder (I am using MariaDB). The following log was around the time I started the backup.

[31m2025-05-10 20:11:34.736 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb.OperationalError) (1034, "Index for table 'state_attributes' is corrupt; try to repair it")
[SQL: SELECT state_attributes.attributes_id, state_attributes.shared_attrs 
FROM state_attributes 
WHERE state_attributes.hash IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: (681121794, 1034549251, 1590949894, 431761416, 2577659920, 3079208980, 3547082772, 2493089818, 632684570, 680699932, 3923623965, 2646792222, 1592193057, 2279342114, 1415952421, 188035112, 1701077035, 3275954220, 4285251634, 2726402107, 1075757115, 991723580, 4105168960, 3165546560, 3050483776, 4086257731, 3069476932, 4159273032, 376959054, 1002080337, 2576988243, 4180191318, 642828382, 1331218528, 152354913, 3787391074, 689231972, 2609387621, 2326720614, 1371826279, 4275019879, 676927591, 3915384933, 3152003180, 3893932141, 2021251182, 2464854125, 1549070451, 1930874997, 617480311 ... 792 parameters truncated ... 548775831, 2277889947, 2910244765, 806227871, 1229930401, 66936737, 565962659, 3716341668, 569540513, 1451202473, 1672046505, 262780842, 139577260, 3792166833, 2718504882, 2574327731, 1738547125, 733867958, 1416054716, 1603073982, 3928154048, 2354722754, 648277955, 1572272069, 467980229, 3290312648, 1478948812, 2229462989, 3065159634, 486137811, 3299626962, 2403835866, 3194550241, 2869133283, 1122353124, 1921386471, 2764978153, 3315046378, 2328762345, 594862060, 422938608, 3756785651, 309895156, 566364149, 152547318, 338356215, 4022396916, 3076646909, 973545470, 255741951)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)[0m
[31m2025-05-10 20:11:34.959 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb.OperationalError) (1034, "Index for table 'state_attributes' is corrupt; try to repair it")
[SQL: SELECT state_attributes.attributes_id, state_attributes.shared_attrs 
FROM state_attributes 
WHERE state_attributes.hash IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: (681121794, 1034549251, 1590949894, 431761416, 2577659920, 3079208980, 3547082772, 2493089818, 632684570, 680699932, 3923623965, 2646792222, 1592193057, 2279342114, 1415952421, 188035112, 1701077035, 3275954220, 4285251634, 2726402107, 1075757115, 991723580, 4105168960, 3165546560, 3050483776, 4086257731, 3069476932, 4159273032, 376959054, 1002080337, 2576988243, 4180191318, 642828382, 1331218528, 152354913, 3787391074, 689231972, 2609387621, 2326720614, 1371826279, 4275019879, 676927591, 3915384933, 3152003180, 3893932141, 2021251182, 2464854125, 1549070451, 1930874997, 617480311 ... 792 parameters truncated ... 548775831, 2277889947, 2910244765, 806227871, 1229930401, 66936737, 565962659, 3716341668, 569540513, 1451202473, 1672046505, 262780842, 139577260, 3792166833, 2718504882, 2574327731, 1738547125, 733867958, 1416054716, 1603073982, 3928154048, 2354722754, 648277955, 1572272069, 467980229, 3290312648, 1478948812, 2229462989, 3065159634, 486137811, 3299626962, 2403835866, 3194550241, 2869133283, 1122353124, 1921386471, 2764978153, 3315046378, 2328762345, 594862060, 422938608, 3756785651, 309895156, 566364149, 152547318, 338356215, 4022396916, 3076646909, 973545470, 255741951)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)[0m
[31m2025-05-10 20:11:35.136 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb.OperationalError) (1034, "Index for table 'state_attributes' is corrupt; try to repair it")
[SQL: SELECT state_attributes.attributes_id, state_attributes.shared_attrs 
FROM state_attributes 
WHERE state_attributes.hash IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: (681121794, 1034549251, 1590949894, 431761416, 2577659920, 3079208980, 3547082772, 2493089818, 632684570, 680699932, 3923623965, 2646792222, 1592193057, 2279342114, 1415952421, 188035112, 1701077035, 3275954220, 4285251634, 2726402107, 1075757115, 991723580, 4105168960, 3165546560, 3050483776, 4086257731, 3069476932, 4159273032, 376959054, 1002080337, 2576988243, 4180191318, 642828382, 1331218528, 152354913, 3787391074, 689231972, 2609387621, 2326720614, 1371826279, 4275019879, 676927591, 3915384933, 3152003180, 3893932141, 2021251182, 2464854125, 1549070451, 1930874997, 617480311 ... 792 parameters truncated ... 548775831, 2277889947, 2910244765, 806227871, 1229930401, 66936737, 565962659, 3716341668, 569540513, 1451202473, 1672046505, 262780842, 139577260, 3792166833, 2718504882, 2574327731, 1738547125, 733867958, 1416054716, 1603073982, 3928154048, 2354722754, 648277955, 1572272069, 467980229, 3290312648, 1478948812, 2229462989, 3065159634, 486137811, 3299626962, 2403835866, 3194550241, 2869133283, 1122353124, 1921386471, 2764978153, 3315046378, 2328762345, 594862060, 422938608, 3756785651, 309895156, 566364149, 152547318, 338356215, 4022396916, 3076646909, 973545470, 255741951)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)[0m
[31m2025-05-10 20:11:35.136 ERROR (Recorder) [homeassistant.components.recorder.core] Recorder._run threw unexpected exception, recorder shutting down

Mikefila · May 10, 2025, 6:26pm

It seems the swap file is corrupt. I found this sequence to delete and rebuild the swap file. It doesn’t mention it in the post but I am pretty sure you need the OS shell to run these commands. If you are using haos the easiest way to get to it is to use an monitor and keyboard connected to the server.

https://www.reddit.com/r/linuxmint/comments/yzzepg/logs_files_filled_with_get_swap_device_bad_swap/ix3ucdl/

tiko · May 10, 2025, 6:41pm

I sadly cannot perform the reddit guide as I do not have the rights to do swapoff and sudo is not found

But as it calmed down now I do not think that is the main problem.

tiko · May 10, 2025, 9:43pm

I solved the recorder problems by dumping, dropping and re-importing the corresponding tables but sadly the error with the backups persists.

It is yet another problem with HomeAssistant where I do not even have an idea what the reason might be and where to ask next.

Edit

Finally found the reason why I couldn’t open the tar.gz files. My backup was saved encrypted on my NAS.
When I created another unencrypted backup I was able to look at it correctly.

tiko · May 11, 2025, 9:48am

It seems like the problem was with the encryption of the backup. Restoring an unencrypted backup worked with only minor problems.