So I was making regularly full ha backups in the past just to find out that these backups include corrupted databases which actually can’t be restored. :bowing_man: What happen? Well, recently my (sqlite) database was “corrupted” while ha was running. It created a new (empty) database and marked my…

I use the mariadb add on and the the Google drive back up add on. I stop the DB prior to back up and this let’s you get a backup that is not corrupt.

Do not store anything you care about in SQLite. Ever.

This is mostly due to an open transaction while the backup was taken. In most cases this can be repaired, by dumping and reimporting the database. Plenty of posts here how to do this. I never experienced any problems with this but there might be some inconsistencies. Apart from that I remember rea…

[image] flyize: Do not store anything you care about in SQLite. Ever. That’s not fair. When used properly, Sqlite is perfectly robust and can be used for mission-critical data. Sure, other options can be more powerful — if you want to be DBA. Otherwise, you’re adding complexity and probably n…

[image] seanomat: In most cases this can be repaired, by dumping and reimporting the database. Plenty of posts here how to do this. You mimd sharing a link? Linke described above I was already runing sqlite3 .recover many times and at the very moment pragma checks are running already for hour…

[image] DB image malformed. How to fix it? Home Assistant OS For all ya googlers (or ducckduckgoers). I fixed mine! shut down HA via shell cd into config folder and execute: sqlite3 ./home-assistant_v2.db “.dump” | sqlite3 ./home-assistant_v2.db.fix mv ./home-assistan…

No one uses SQLite for mission critical data. That would be insane. Either way, I would assume that most people who have dealt with HA backups, or HA in general, have seen DB corruption. While it might be able to be fixed, for the most folks the data just doesn’t really matter that much. I assume t…

[image] flyize: No one uses SQLite for mission critical data. That would be insane. That’s quite the confident assertion, but you are wrong, both in whether it happens and whether it is “sane”. I’m not going to escalate on the name calling — I think it’s inappropriate. But I will say: for ev…

Apologies if you took that as a personal attack. It wasn’t. No normal IT person is going to run mission critical data on SQLite. If they do, they won’t be in IT for long. If you disagree, then we will just have to leave it there. I’ve no need to convince you and it’s probably not that constructive …

I didn’t take it as a personal attack, but I don’t think it’s constructive to call people “insane”. And your other assertions continue to just be factually wrong. To stay to the topic, if you install MariaDB, you will still need to do something about backups other than just back up or snapshot the …

Are HA Backups useless? 🚮 (sqlite db always corrupted)

Configuration

seanomat March 4, 2022, 11:24am 8