13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db?
#1
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?
Reply
#2
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).
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#3
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.
Reply

Logout Mark Read Team Forum Stats Members Help
13.1 Beta1 - Bug when updating from MyMusic20.db to MyMusic46.db?0