Due to various bugs and inconsequent usage of transactions the Mixxx database accumulates inconsistent entries over time. Those inconsistent contents cause consecutive bugs as https://bugs.launchpad.net/mixxx/+bug/1846945 demonstrates.
How-to-fix: Periodically (e.g. after upgrading the database schema on startup) remove inconsistent rows from all tables for which the referential integrity constraints are violated.
Due to various bugs and inconsequent usage of transactions the Mixxx database accumulates inconsistent entries over time. Those inconsistent contents cause consecutive bugs as https:/ /bugs.launchpad .net/mixxx/ +bug/1846945 demonstrates.
How-to-fix: Periodically (e.g. after upgrading the database schema on startup) remove inconsistent rows from all tables for which the referential integrity constraints are violated.