mixxxdb.sqlite error on startup
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mixxx |
Won't Fix
|
Critical
|
Unassigned |
Bug Description
working with mixxx1.12 on archlinux on an Lenovo T61
BUT: Bug is reproducible with Mixxx1.11 !
I recently reinstalled dj-system and after installing mixxx i copied the .mixxx directory from backup to home.
When i now start mixxx i get an error saying:
Debug [Main]: Available QtSQL drivers: ("QSQLITE", "QSQLITE3", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")
Debug [Main]: DB status: "/home/
Debug [Main]: SchemaManager:
Debug [Main]: Loading schema "/usr/share/
Debug [Main]: Applying version 1 : "The base schema for the Mixxx SQLITE database."
Debug [Main]: Failed query: "CREATE TABLE IF NOT EXISTS settings (
name TEXT UNIQUE NOT NULL,
value TEXT,
locked INTEGER DEFAULT 0,
hidden INTEGER DEFAULT 0)" QSqlError(11, "Der Befehl konnte nicht ausgeführt werden", "database disk image is malformed")
Debug [Main]: Failed to move from version 0 to version 1
Debug [Main]: Rolling back transaction on "qt_sql_
exit 255
Mixxx Suggested renaming the mixxxdb and start all over, but that obviously gives me a fresh db with all my crates and playlists lost.
The Error lead me to this
http://
so i did this.
step 3 (.read dumb_all.sql) gives me some errors like this
Error: near line 23478: UNIQUE constraint failed: library.id
Error: near line 23479: UNIQUE constraint failed: library.id
Error: near line 23480: UNIQUE constraint failed: library.id
Error: near line 33891: UNIQUE constraint failed: library.id
AND
resulting mixxxdb is much smaler (from 73849K to 14729k)
Then i started mixxx again
Debug [Main]: Available QtSQL drivers: ("QSQLITE", "QSQLITE3", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")
Debug [Main]: DB status: "/home/
Debug [Main]: SchemaManager:
and opening the "select your music library" window.
Mixxx starts, an i get all my crates and Playlists. But almost empty!!!
some crates contain 4 songs, some 10, most 0.
So obviously i lost all my crates, which is…faltan palabras, ich weiß gar nicht was ich dazu sagen soll. ;)
Any chance to look into that?
hi daniel! Sorry for this data loss. We aren't careful with our UNIQUE constraints. We can recovery this by hand if you're interested and get it working with the latest Mixxx.