+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59)
+---- Thread: 13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db? (/showthread.php?tid=195261)
13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db? - clutch - 2014-05-15
After Beta1 came along, I did an upgrade of my (very old) xbmc installation.
The first run, the debug log says:
Code:
20:33:52 T:3520 NOTICE: Old database found - updating from version 20 to 46
20:33:52 T:3520 DEBUG: Copying from MyMusic20.db to MyMusic46 at C:\util\Xbmc\portable_data\userdata\Database\
20:34:25 T:3520 NOTICE: Attempting to update the database MyMusic46 from version 20 to 46
20:34:25 T:3520 DEBUG: Cleaning indexes from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\
20:34:25 T:3520 DEBUG: Cleaning views from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\
20:34:25 T:3520 DEBUG: Cleaning triggers from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\
20:34:27 T:3520 INFO: CMusicDatabase::CreateAnalytics - creating indices
20:34:27 T:3520 ERROR: SQL: Abort due to constraint violation
Query: CREATE UNIQUE INDEX idxAlbumGenre_1 ON album_genre ( idAlbum, idGenre )
20:34:27 T:3520 ERROR: Exception updating database MyMusic46 from version 20 to 46
20:34:27 T:3520 ERROR: Error updating database MyMusic46 from version 20 to 46
20:34:27 T:3520 NOTICE: Old database found - updating from version 18 to 46
20:34:27 T:3520 DEBUG: Copying from MyMusic18.db to MyMusic46 at C:\util\Xbmc\portable_data\userdata\Database\
20:34:27 T:3520 NOTICE: Attempting to update the database MyMusic46 from version 18 to 46
20:34:27 T:3520 DEBUG: Cleaning indexes from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\
20:34:27 T:3520 DEBUG: Cleaning views from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\
20:34:27 T:3520 DEBUG: Cleaning triggers from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\then I restarted:
Code:
20:36:32 T:3204 NOTICE: Attempting to update the database MyMusic46 from version 18 to 46
20:36:32 T:3204 DEBUG: Cleaning indexes from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\
20:36:36 T:3204 DEBUG: Cleaning views from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\
20:36:37 T:3204 DEBUG: Cleaning triggers from database MyMusic46.db at C:\util\Xbmc\portable_data\userdata\Database\
(uses 1 minute on this EVERY start)I ended up moving all MyMusic*.db files to a subdir and then restarted the PC. finally it worked fine.
I'm not sure this is a bug or not, but it seems like it to me?
RE: 13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db? - jmarshall - 2014-05-16
It might be, it might not. The index violation suggests you have multiple albums linking to the same genres multiple times. This shouldn't be happening.
I dunno which version ran music database version 20. IIRC Eden was v18, so that's somewhere between Eden + Frodo (i.e. some build that could have had broken stuff in it).
RE: 13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db? - clutch - 2014-05-17
okay. i don't think i'll investigate more. thanks for your responding jmarshall. i leave this thread in case somebody else end up here while googling.