Solved - Database Update fails on Kodi19_beta1

Solved Database Update fails on Kodi19_beta1 - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Solved Database Update fails on Kodi19_beta1 (/showthread.php?tid=358922)

Database Update fails on Kodi19_beta1 - Noosi - 2020-12-04

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!

RE: Database Update fails on Kodi19_beta1 - Klojum - 2020-12-04

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

RE: Database Update fails on Kodi19_beta1 - Noosi - 2020-12-04

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

Sorry, was quite long with pvr debug enabled Smile

redone without it

RE: Database Update fails on Kodi19_beta1 - Noosi - 2020-12-08

Solved!

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

Thanks!

Database Update fails on Kodi19_beta1 - Klojum - 2020-12-08

Thread marked solved.

RE: Database Update fails on Kodi19_beta1 - DaveBlake - 2020-12-08

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.