[BizJet78]

I have upgraded 14.2 to 16.0 on my Amazon Fire TV.

After displaying the splash screen for a while, it crashed back to the main Amazon menu.

So I installed on my MacBook Pro (Retina, 15-inch, Late 2013) which is running 10.11.3 to make it easier to access and post the logs.

This was a clean install with no previous version running and used the 16.0 release from 20th Feb 2016.

I have a shared library so presume it is related to this. I have tried deleting the MyMusic56 and MyVideos99 to allow it to try rebuilding, and it appears to keep crashing at the exact same point (MyVideos99 always ends up with 139,927 rows).

Once it gets to this point, the app keeps failing.

The XBMC log is pasted here: http://pastebin.com/rNUK8MSp

The crash report from OSX is pasted here: http://pastebin.com/ia3nPvCN

[Memphiz]

Code:

15:20:30 T:140735190970368   ERROR: SQL: [MyVideos99] The table does not exist
                                            Query: SELECT idVersion FROM version

Looks like you added an empty mysql db - you need to let Kodi create that database. So basically setup only the user with permissions for MyVideos99 and let kodi create the db.

[BizJet78]

Code:

15:20:30 T:140735190970368   ERROR: SQL: [MyVideos99] The table does not exist
                                            Query: SELECT idVersion FROM version

Looks like you added an empty mysql db - you need to let Kodi create that database. So basically setup only the user with permissions for MyVideos99 and let kodi create the db.

Thanks Memphiz

I haven't created any databases or tables manually - anything created is from Kodi and I presume permissions is not a factor if it is at least able to partially created / populate the tables rather than totally failing to create anything.

Just to check, before I submitted my reply, I deleted both databases and relaunched Kodi on the Mac. The splash screen displayed for about 2 minutes, it recreated the databases (with MyVideos99 having the exact same row count as previously) and any subsequent attempt to launch crashes almost instantly.

[BizJet78]

I should add, it is not successfully creating the MyVideos99 database - it stops at 3 tables.

See screenshot.

http://imgur.com/2WzIGpd

[Memphiz]

could you post a debug log (wiki) (debug is empasized here) when it tries to create the db? (drop the partially created db before...)

[Vatoe]

Not creating a new database on my setup (Synology NAS) either, when all previous versions of Kodi have worked flawlessly. To be sure, I have checked and there is no MyVideos99 in phpMyAdmin. Here's a copy of the log file:
http://pastebin.com/Tzx06hsJ

edit: If I remove my advancesettings.xml file it seems to start up ok, and then create a db on the NAS

[Memphiz]

moved to os independend as it must be a generic issue when updating from db93 to db99 - is this mariadb by any chance? Or a normal mysql server?

[Vatoe]

Not really sure of the mechanics, but both are running on the NAS, and I log in via phpMyAdmin.

It's almost like we don't need the advancesettings file any more as with my limited testing it seems that the db's are being created normally without the advancesettings file pointing to the NAS and providing passwords?

I have another mac, when i get time I will load jarvis on it and see if it all works as expected.

[Memphiz]

Then you did something wrong - without advancedsettings it will Never connect to any MySQL Server ...

[Vatoe]

Not sure what's going on. I tested it by dropping the 99 database. Left the advance settings file there with my usual working settings. Jarvis gets stuck splash screen. remove the advance settings file, it starts up normally and does create the 99 db. This is repeatable.

[Vatoe]

In case anyone else is having this problemm, I did a quick check on Krypton and the issue persists in that it hangs on splash screen as a result of it not being able to create the Maria database (I assume) on my NAS.


edit: Issue resolved: drop the previous database from the NAS and let Jarvis create a new one (http://forum.kodi.tv/showthread.php?tid=263173)

[Sionzris]

In case anyone else is having this problemm, I did a quick check on Krypton and the issue persists in that it hangs on splash screen as a result of it not being able to create the Maria database (I assume) on my NAS.


edit: Issue resolved: drop the previous database from the NAS and let Jarvis create a new one (http://forum.kodi.tv/showthread.php?tid=263173)

This is a last Resort. Having Kodi sit on the upgrade for hours often works too. (Or updating mariadb when possible)