[mad_ady]

Hello all!
I'm new to this forum, but been a Kodi user for a while.
I recently moved to a mysql database (5.7.28-0ubuntu0.18.04.4) setup that is shared between two Android Kodi instances (18.5). I'm getting my media from a NAS over NFS.
Previously I was able to search and index TV shows without issues, but since moving to mysql (and rescanning my collection) I have this weird issue where:
* I see a list of recently added episodes (I can confirm that they show up in the mysql database as well)
* I see a list of in progress/unwatched TV shows (that correctly show how many episodes were seen (I marked them manually after rescan) out of the total) e.g. 1/153
* When pressing enter on a TV show (starting from the TV shows left menu) I get taken to the "Videos" view (with Movies/TV Shows/Files/Playlists/Video add-ons) instead of being taken to the season/episode list.
* Pressing enter on a recently added episode starts its playback correctly

Even when trying to access the episodes via TV Shows -> Titles -> Star Trek: The next generation I get a short loading bubble but nothing else (it remains at the same level).
I am able to access the seasons/episodes (and I can see their metadata) when navigating from Videos -> Share Name -> Star Trek: The next generation...

I enabled debug and this is the error I get when clicking enter on a TV show:

Code:

2019-12-31 22:05:43.006 T:10341   DEBUG: Keyboard: scancode: 0x17, sym: 0x000d, unicode: 0x0000, modifier: 0x0
2019-12-31 22:05:43.221 T:10341   DEBUG: Previous line repeats 1 times.
2019-12-31 22:05:43.221 T:10341   DEBUG: HandleKey: return (0xf00d) pressed, action is Select
2019-12-31 22:05:43.223 T:10341   DEBUG: Activating window ID: 10025
2019-12-31 22:05:43.533 T:10341   DEBUG: ------ Window Deinit (Home.xml) ------
2019-12-31 22:05:43.533 T:10341   DEBUG: FreeVisualisation() done
2019-12-31 22:05:43.620 T:10937   DEBUG: Thread waiting start, auto delete: false
2019-12-31 22:05:43.622 T:10341   DEBUG: ------ Window Init (MyVideoNav.xml) ------
2019-12-31 22:05:43.623 T:10341   DEBUG: CGUIMediaWindow::GetDirectory (videodb://inprogresstvshows/26/)
2019-12-31 22:05:43.623 T:10341   DEBUG:   ParentPath = [videodb://inprogresstvshows/26/]
2019-12-31 22:05:43.625 T:10937   DEBUG: Thread waiting 10937 terminating
2019-12-31 22:05:43.942 T:10341   ERROR: SQL: Missing result set!
2019-12-31 22:05:43.945 T:10341   ERROR: GetSeasonsByWhere failed
2019-12-31 22:05:44.079 T:10341   ERROR: GetDirectory - Error getting videodb://inprogresstvshows/26/
2019-12-31 22:05:44.087 T:10341   ERROR: CGUIMediaWindow::GetDirectory(videodb://inprogresstvshows/26/) failed
2019-12-31 22:05:44.088 T:10341   DEBUG: CGUIMediaWindow::GetDirectory ()
2019-12-31 22:05:44.089 T:10341   DEBUG:   ParentPath = [videodb://inprogresstvshows/26/]
2019-12-31 22:05:44.109 T:10938   DEBUG: Thread BackgroundLoader start, auto delete: false
2019-12-31 22:05:44.226 T:10938   DEBUG: Thread BackgroundLoader 10938 terminating

I'm not sure what query it's trying to do or why it's complaining about SQL: Missing result set... Any idea how to investigate further?
Thanks!

[mad_ady]

Never mind, I found the problem with the help of this post:
https://forum.kodi.tv/showthread.php?tid=340095

It seems my mysql sort_buffer_size was set to 32k. Upgraded it to 16M and now all is well after a kodi restart!

[mad_ady]

I'd like to ask a moderator to mark this as solved - I don't seem to have the ability yet.

[Karellen]

Thread marked solved.