Comment 0 for bug 1846971

Revision history for this message
Uwe Klotz (uklotzde-deactivatedaccount) wrote : Inconsistent database

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.