Hi Max,
Maybe
Is go to the default database instead of mariaDB.
My suggestion is remove the MariaDB statement in your recorder integration and the database will rebuild. History will be at start-over. You could also ‘fix’ the broken tables (but that is something I couldn’t do) and migrate your data over, Migrate back from MariaDB to the default SQLite.
I personally delete my data every year.