[Noosi]

Hello,

I have a Problem running Kodi19beta1. With Kodi18.9 everything is fine with Databases/MariaDB, but on 19beta1 the Database is "empty" after updating. No Movies/Music are displayed on Mainmenu.
Here a debug with Database Component debug enabled. Can you please have a look?

https://paste.kodi.tv/foraliyema.kodi

Software/Machines used : PC/Win64 with 19beta1/64bit, Android/FireTV Cube with 19beta1/32bit, Server Debian Linux/64bit with MariaDB 10.4.17-MariaDB-1:10.4.17+maria~bionic-log

Thank you!

[Klojum]

We want the full uncut/unedited kodi log, please.
Not just the part(s) that you find interesting.

[Noosi]

https://paste.kodi.tv/atinocicul.kodi

Sorry, was quite long with pvr debug enabled redone without it

[Noosi]

Solved!

https://github.com/xbmc/xbmc/issues/18864

Thanks!

[Klojum]

Thread marked solved.

[DaveBlake]

Just for search purposes and helping other users. Database migration from v18 databases to v19 databases failed, and the log included the error message
"SQL: Can't determine list of routines to drop"

Logging into Mariadb with Kodi user and executing the following statement

Code:

SELECT routine_name FROM information_schema.routines
WHERE routine_type = 'FUNCTION' and routine_schema = 'MyMusic82';

resulted in an error:

Code:


ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 21, found 20.
Created with MariaDB 100144, now running 100417.
Please use mysql_upgrade to fix this error


Basically a fault in the MariaDB installation, that was fixed using mysql_upgrade

Any database schemas partially created by migration e.g. MyMusic82 and MyVideo119 needs to be removed before running Kodi again which will create and populate them correctly.