-
-
Notifications
You must be signed in to change notification settings - Fork 1.2k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
mixxxdb.sqlite error on startup #7292
Comments
Commented by: mail-daniel |
Commented by: rryan 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. |
Commented by: mail-daniel Hi Ryan. So it happend again. just installing and starting 1.12 goes terribly wrong thanks for your help! |
Commented by: kain88-de HI Daniel I looked into the db file that you uploaded. Your crates are basically still saved in there. But you have only ~7000 tracks saved in the track_locations table while the library table contains ~50000 entries. The mismatch between track_locations and library table already exists in the text dump of the sql database. So the database still knows about your tracks and crates it just forgot where most of them are saved. What might work is to invalidate all your library hashes and then rescan your whole library.
This will add all the tracks again with a track location. What you have to do now is connecting the track locations to the old library.ids'. We usually do this in 'TrackDAO::detectMovedFiles' but this function uses the filename (stored in the track_locations table) and track duration, so it won't work directly for you. But it should be possible to change the algorithm we use to take 'artist', 'title', 'album' and 'duration' from the library table only. If you have problems writing the sql code please tell us. best Max |
Commented by: daschuer I remove this from the 1.12 target, because by now only one user is effected and no one is working on it. Sorry. |
Commented by: xeruf Why is this bug categorised as "New" and does still exist? It is one of the first things I see when looking at the bug list, even though it is 99% likely that noone will ever get use from it. This Bug database is a mess of old reports... |
Commented by: uklotzde This bug report is obsolete after many changes on the database subsystem in 2.0/2.1. A fix is not possible without the ability to reproduce the bug. Please open a new bug report if this should ever happen again with Mixxx 2.1 or newer. |
Issue closed with status Won't Fix. |
Reported by: mail-daniel
Date: 2014-02-06T11:57:16Z
Status: Won't Fix
Importance: Critical
Launchpad Issue: lp1277045
Attachments: [original mixxxdb.sql](https://bugs.launchpad.net/bugs/1277045/+attachment/3971121/+files/original mixxxdb.sql)
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:
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://techblog.dorogin.com/2011/05/sqliteexception-database-disk-image-is.html
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
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.
Any chance to look into that?
The text was updated successfully, but these errors were encountered: