[Milhouse]

Since build #0527 my Music library is not working anymore. (Movie library is fine)
Main menu says "Library Empty", opening it makes Kodi crash.
Same when opening files section only > Kodi crash.
I'm using a MariaDB on another server for my libraries.

In build #0519 it's working fine.

text:


2020-06-16 12:17:09.272 T:1765    DEBUG <general>: Initialize, updating databases...

2020-06-16 12:17:09.272 T:1765     INFO <general>: Running database version Addons27

2020-06-16 12:17:09.272 T:1765     INFO <general>: Running database version ViewModes6

2020-06-16 12:17:09.273 T:1765     INFO <general>: Running database version Textures13

2020-06-16 12:17:09.274 T:1765     INFO <general>: WakeOnAccess [192.168.1.4] trigged by accessing : MySQL : MyMusic77

2020-06-16 12:17:09.275 T:1765     INFO <general>: WakeOnAccess success exit, server already running

2020-06-16 12:17:09.276 T:1765     INFO <general>: MYSQL: Connected to version 10.4.13-MariaDB-1:10.4.13+maria~bionic-log

2020-06-16 12:17:09.278 T:1765     INFO <general>: Attempting to update the database MyMusic77 from version 75 to 77

2020-06-16 12:17:09.278 T:1765    DEBUG <general>: Mysql Start transaction

2020-06-16 12:17:09.279 T:1765    ERROR <general>: SQL: Can't determine list of routines to drop.

2020-06-16 12:17:09.279 T:1765    ERROR <general>: Exception updating database MyMusic77 from version 75 to 77

2020-06-16 12:17:09.279 T:1765    ERROR <general>: Error updating database MyMusic77 from version 75 to 77

2020-06-16 12:17:09.280 T:1765    DEBUG <general>: Mysql rollback transaction

2020-06-16 12:17:09.281 T:1765     INFO <general>: Old database found - updating from version 76 to 77

2020-06-16 12:17:09.282 T:1765    ERROR <general>: SQL: Can't create database for copy: 'MyMusic76' (1007)

2020-06-16 12:17:09.282 T:1765    ERROR <general>: Unable to copy old database MyMusic76 to new version MyMusic77

2020-06-16 12:17:09.284 T:1765     INFO <general>: Running database version MyVideos117

2020-06-16 12:17:09.285 T:1765     INFO <general>: Running database version TV36

2020-06-16 12:17:09.285 T:1765     INFO <general>: Running database version Epg13

2020-06-16 12:17:09.285 T:1765    DEBUG <general>: Initialize, updating databases... DONE

It looks like the database migration from MyMusic75 to MyMusic76 is failing for some reason - can you drop MyMusic77 and also MyMusic76 (if they exist), turn on debugging then upload a debug log after attempting another migration from MyMusic75 to MyMusic76?

Are you sure this issue started with #0527? Both #0527 and also #0519 are using MyMusic75, so #0527 should be your last working build (assuming there's nothing wrong with your MyMusic75 database, of course).

Build #0601 introduced MyMusic76 with PR17838, and build #0609 introduced MyMusic77 with PR17990, so probably best to test with #0601 until MyMusic76 has been migrated successfully.

The error you are seeing is in this piece of code: https://github.com/xbmc/xbmc/blob/941afd...t.cpp#L451 added by PR17838, which might suggest a permission problem of some kind in the MariaDB server, or possibly even a compatibility issue as the new code may not be compatible with MariaDB (either all, or only some MariaDB server versions - but that's a total guess).

Can you check if you are able to execute the following query against your MariaDB server while using the kodi sql user:

text:


SELECT routine_name

FROM information_schema.routines

WHERE routine_type = 'FUNCTION' and routine_schema = 'MyMusic76'

With a MySQL server 5.5.x, the above query returns the following:

text:


udfFirstNumberPos

udfNaturalSortFormat

udfSymbolShift

Please post any errors you see when executing the query.