Solved Struggles testing Omega, getting ready for upgrade from Nexus
#1
Hi.  I'm not sure that I am posting exactly where I should be.  If I am in the wrong place, I apologise.  I am working on testing Kodi Omega to ensure that all will work for me when the final version is available.  With Nexus, all is working well.  But when I upgrade to Omega, I am having two problems that are evident in the logs:

Log for Nexus, everything working well:

Kodi Nexus Log

But when I upgrade to Omega, I am getting delays of around 2 minutes in 2 places:

Kodi Omega Log

At the line in this log, (2024-04-01 11:54:43.462 T:21852 info <general>: Loading skin file: MyVideoNav.xml, load type: KEEP_IN_MEMORY), I have asked Kodi to display the list of all of my movies (there are 4,900).  With Nexus, I get a screen display in less than 10 seconds.  On Omega, it is taking more than 2 minutes before I get any display.

And then again, with Omega, at the bottom of the log, where it says "Stopping all services", there is again a delay of at least 90 seconds before Kodi stops. I do not have this problem with Nexus.

I realise that Omega is not yet formally released, but with it being RC2, I would expect that basic tasks like this should be smoothed out.  Please feel free to move my post elsewhere if it does not belong here.

Thank you
Reply
#2
Neither of those logs are a Debug Log so not enough info in them. Try again?

I note you are using MySQL.
For the purpose of fault finding, can you use the default database instead. I am pretty sure your issue is MySQL related, so lets test that first.

You can use multiple Portable installs so your existing setup is not touched... https://kodi.wiki/view/Portable_mode
Hopefully you are using local info, so you can rebuild your large library in about 15 minutes.
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#3
Hi Karellan.  Thank you for your fast response!  Yes - I am using MySQL ... actually MariaDB ... running on my Synology DS418 NAS.

As you have suggested, I installed Omega RC1 in portable mode and recreated my database as default local.  FYI - I did not mention that in addition to my 4,900 movies, I also have about 15,000 TV episodes.  So the load took a while to build the DB!

Once it was done, I was able to have a look.  And I am pretty certain that your intuition was correct!  It appears to be a SQL problem.  Running from the local database, I can display all movies in about 4 seconds.  So its not a Kodi or Omega issue.  However, I do have a problem with query efficiency accessing my database!

The way in which I wish to access movies in the skin, is via a playlist that requests movies to be sorted in order from most recently added, to least recently added.  Therefore, in order to get "most recently added", I am guessing that the query would have to join the FILES table with the MOVIES table to gain access to the "DATE ADDED" value in FILES, then sort, and display the MOVIES attributes required.  I am guessing that this might be able to be accelerated via an index.  But are you able to assist me with the syntax of what would be required for a CREATE INDEX?

Thank you!
Reply
#4
There were a few movie and database-related changes in v21 and what you described sounds like an inefficient query.
Is it possible that you created a custom index for performance in v20? Kodi db migration to v21 would not have included custom indexes.

The database export / import functions are recommended for database transfer and are much more efficient than rescraping, in case that's what you did.

Please provide details about your playlist / however you setup the access to the movies to allow reproduction by others.
Always read the Kodi online-manual, the FAQ and search the forum before posting.
Do not e-mail Kodi Team members directly asking for support. Read/follow the forum rules (wiki).
For troubleshooting and bug reporting please make sure you read this first.
Reply
#5
Hi @CrystalP and thank you for the assistance

My skin points to a playlist to show movies in descending dateadded order.  It executes a file that I have called Movies.xsp:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="movies">
    <name>Kodi Movies</name>
    <match>all</match>
    <order direction="descending">dateadded</order>
</smartplaylist>

As I have mentioned prior, the population of movies that I have is 4,900.  Yes - I did rescrape; but you are correct ... I should have done an export import.

And yes I did do optimisation on V20 but have not done on V21.  I will investigate recreating that.  I believe, if memory serves, I simply did a manual ANALYZE/OPTIMIZE on the major tables such as "movies", "files", "paths" and "tvshows".  I don't know the specific syntax of the query that Kodi would have used given my playlist above.  Hence I don't know if my manual optimisation would have included all of the tables needed to be indexed to avoid a scan.
Reply
#6
(2024-04-03, 09:47)bfgane Wrote: It executes a file that I have called Movies.xsp:
Why not use the sort option in the movie list?

Image
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#7
Now that you point that out, I see it.  I can't recall why I went the playlist route so long ago.  And there is no query performance problem when I use the direct "movies" display vs. the playlist.

Consider this request for assistance closed.  Thank you @Karellen and @CrystalP for your time.
Reply
#8
Thread marked solved.
Reply

Logout Mark Read Team Forum Stats Members Help
Struggles testing Omega, getting ready for upgrade from Nexus0
This forum uses Lukasz Tkacz MyBB addons.