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:
then I restarted:
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?
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?