Kodi Community Forum

Kodi Community Forum > Support > General Support > Windows > 13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db?
Full Version: 13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

clutch

2014-05-15, 20:47
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?

jmarshall

2014-05-16, 10:26
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).

clutch

2014-05-17, 21:43
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.
Kodi Community Forum > Support > General Support > Windows > 13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db?