Major connection issues with mezzmo

[HomerRamone]

Ive started getting major issues getting my client to connect with mezzmo.
I have several playlists defined. One for TVs, one for Movies, one for Music etc.
There are playlists within this.
So the TV one for example as a "stuff we are watching currently", "homers TV", "all TV" etc
The movie one has "All movies grouped by letter", "All movies ungrouped", and so on.
I just added a new playlist that has a criteria something like "keyword contains" and sorted by keyword.

This is in the Movies playlist.
Now whenever I try to open the movies playlist the client shows the busy thing for a while then says "mezzmo sever failed to respond".
Once this has happened I cant view any playlists.
If I go back to the addin selection page in kodi the mezzmo server no longer shows up.
If I try to stop the server I get an error that it could not be stopped
"The mezzmo media service could not be stopped"
"The service did not respond to the start or control request in a timely fashion"
Error code 1053

This does appear to stop the server - but obviously this isnt really solving the problem.

[jbinkley60]

Ive started getting major issues getting my client to connect with mezzmo.
I have several playlists defined. One for TVs, one for Movies, one for Music etc.
There are playlists within this.
So the TV one for example as a "stuff we are watching currently", "homers TV", "all TV" etc
The movie one has "All movies grouped by letter", "All movies ungrouped", and so on.
I just added a new playlist that has a criteria something like "keyword contains" and sorted by keyword.

This is in the Movies playlist.
Now whenever I try to open the movies playlist the client shows the busy thing for a while then says "mezzmo sever failed to respond".
Once this has happened I cant view any playlists.
If I go back to the addin selection page in kodi the mezzmo server no longer shows up.
If I try to stop the server I get an error that it could not be stopped
"The mezzmo media service could not be stopped"
"The service did not respond to the start or control request in a timely fashion"
Error code 1053

This does appear to stop the server - but obviously this isnt really solving the problem.

It is likely the playlist is not leveraging database indexes and doing table scans which causes it to take a long time to respond. I've had this happen and had to modify my playlist to leverage the database indexes. What is the Mezzmo server timeout value set to in the Mezzmo Kodi addon ? If it isn't set to 60 seconds try setting it to that and then see if you eventually get the playlists to appear. I have found on slow playlist that once they load the first time they are cached and often come back faster the second time. Lastly, what type of drive (i.e. hard disk or SSD) is your Mezzmo database running on ?



Thanks,

Jeff

[HomerRamone]

Thanks for the suggestions. I've not changed the timeout setting - but looks like is 60
Database is on an SSD (Learned that lesson a long time ago )

[HomerRamone]

Looks like 60 is the max it can be set to also

[jbinkley60]

Looks like 60 is the max it can be set to also

Did this just start without you adding or making changes to any smart or active playlists ? If so it sounds like a potential database issue or possibly something going on with your SSD. If you haven't made any changes you could try backing up your database and running maintenance. 60 seconds is the maximum because folks aren't going to sit around longer than that to wait for a response. Can you tell me if anything preceeded the issue beginning ?


Thanks,

Jeff

[HomerRamone]

This all started when I added a new playlist.
That said I had a similar issue around Christmas last year when I created a Christmas playlist - never got to the bottom of it - just removed the playlist
Ive certainly done maintenance and a chkdsk on the drive - but will run them again anyway but not hopeful this will help