Sorry, what happened to me is somewhat complicated although I don't understand how the trigger could have caused the result. I currently have 3 Libreelec boxes in my house for streaming content from my Synology NAS. It's probably been about a year since I have made any significant changes to my setup. Each of my three streamers does NOT use it's local DB for content watch history. Instead, I have a MariaDB instance running on a VM on my network and each libreelec instance has advancedsettings.xml pointing to this DB. The setting is pretty simple:
<videodatabase>
<type>mysql</type>
<host>192.168.<blah>.<blah></host>
<port>3306</port>
<user>******</user>
<pass>********</pass>
</videodatabase>
This has been great for a long time. I can stop a show on one streamer and pick up where I left off on another.
About a week ago, we had a power outage and one of my three streamers now fails to boot. Gives me all sorts of cryptic NVMe errors. I swapped out the NVMe drive (even though it is not very old and has pretty light usage) and even tried a SATA SSD boot drive but it appears something on this n100 machine's motherboard went belly up. I replaced it with a backup machine. I installed libreelec fresh and pointed it at the same mariaDB as the other ones.
The next morning, I went to continue watching a show in the basement while working out and the history was all gone. Most of the history of all shows I have found is gone. Not all, appears most of my movie history has been preserved and the tv shows watched on the 3rd streamer. However, the rest of the TV show history appears to be gone.
As far as I can tell, nothing happened to the MariaDB instance. It is on a VM on a machine that is on a UPS and never went down in the power outage. It appears to be working fine, if I watch a new show, the history is reflected on the other two streamers in the house.
Any idea what would cause a selective hole in the history? This isn't like a 1-2 show hiccup, it's hundreds of entries that have been working consistently on all streamers for 6+months.
Unfortunately, I am not great at low level mySQL debugging but, like I said, functionally, everything appears to be working, I just lost a large chunk of my viewing history and am confused what would have caused that.
Any ideas?
Thank you
I guess what I was trying to make clear by my statement that I am not great at low level mySQL debugging, currently I don't know if MariaDB actually lost this history or if something happened on my libreelec instances making them collectively all see a subset of history than what is on my MariaDB instance.
My MariaDB instance is running on Proxmox and I feel kind of silly not having a recent backup, but like I said, this has all been working fantastic for a long time (upwards of a year). I do have a backup of the MariaDB instance since I got it working, but it's been a while and if I revert to that backup, it like doesn't have 90% of the history that was lost. Not much point in rolling back to gather that level of history.