Ever since migrating server from old hardware build (Windows server 2016) to new hardware build (Windows server 2019 preview), Plex Mix has refused to work. This was in June.
I have performed multiple DB repairs, as described in this guide to no avail. Deleting and recreating the Library also does not fix the issue.
As a workaround, creating a secondary VM (Running Windows 10) with a new plex install and new library works. I’d prefer to fix the main install however. Creating an entire new install and losing TV/Movie watched status is not an attractive option.
I’ve done a fair amount of troubleshooting into this issue, and I believe I have narrowed it down to some weirdness in the database regarding the ‘gn_genre’ attribute. It almost looks like a locale setting is missing for my server.
Going through the logs, when the server fails to create a plex mix playlist, I get the following:
Sep 26, 2018 17:01:31.878 [10084] DEBUG - Request: [192.168.1.1:51566 (Subnet)] POST /playQueues?type=audio&shuffle=0&continuous=0&uri=library%3A%2F%2F275f36e5-7b08-40d9-8ee1-b5baa5c9363b%2Fdirectory%2F%252Fservices%252Fgracenote%252FsimilarPlaylist%253Fid%253D269111&includeRelated=1 (12 live) TLS GZIP Signed-in Token (username)
Sep 26, 2018 17:01:31.894 [10084] WARN - LPE: falling back to slow path evaluation: /services/gracenote/similarPlaylist?id=269111
Sep 26, 2018 17:01:31.894 [10084] DEBUG - Downloading document http://127.0.0.1:32400/services/gracenote/similarPlaylist?id=269111
Sep 26, 2018 17:01:31.956 [10084] ERROR - Gracenote: Exception error -1870069037 (no locale loaded to support 'like' operator for attribute 'gn_genre')
Sep 26, 2018 17:01:31.956 [10084] ERROR - PlexClient::downloadContainer: expected MediaContainer element, found html
Sep 26, 2018 17:01:31.956 [10084] ERROR - LPE: failed to get container for path: /services/gracenote/similarPlaylist?id=269111
Sep 26, 2018 17:01:31.956 [10084] DEBUG - PlayQueue: Start index: 0 End index: -1 Count: 0
Sep 26, 2018 17:01:31.956 [10084] DEBUG - PlayQueue: 0 generated IDs compressed down to a 2 byte blob.
On the VM where Plex Mix works, this is the log detail
Sep 26, 2018 14:39:57.772 [6204] DEBUG - Request: [192.168.1.1:52186 (Subnet)] POST /playQueues?type=audio&uri=library%3A%2F%2F%2Fdirectory%2F%252Fservices%252Fgracenote%252FsimilarPlaylist%253Fid%253D11087&key=%2Flibrary%2Fmetadata%2F11087&repeat=0&own=1&includeChapters=1&includeGeolocation=1 (23 live) TLS GZIP Signed-in Token (username)
Sep 26, 2018 14:39:57.772 [6204] DEBUG - PlayQueue: 0 generated IDs compressed down to a 2 byte blob.
Sep 26, 2018 14:39:57.788 [6204] WARN - LPE: falling back to slow path evaluation: /services/gracenote/similarPlaylist?id=11087
Sep 26, 2018 14:39:57.788 [6204] DEBUG - Downloading document http://127.0.0.1:32400/services/gracenote/similarPlaylist?id=11087
Sep 26, 2018 14:39:58.022 [6204] DEBUG - GN: Generated playlist with 61 items
Sep 26, 2018 14:39:58.100 [6204] DEBUG - PlayQueue: Start index: 0 End index: 61 Count: 62
Sep 26, 2018 14:39:58.100 [6204] DEBUG - PlayQueue: 62 generated IDs compressed down to a 215 byte blob.
Sep 26, 2018 14:39:58.132 [6204] DEBUG - PlayQueue: Added 62 items in 0.0 sec.
What I’m stuck at now is how I can possibly manually fix my database or set that locale setting (If this is truly the issue). Any help is greatly appreciated!
