Error deleting Collections

Plex Media Server Desktops & Laptops
1

Server Version#: 1.22.1.4200 on Ubuntu 20.04.2 LTS (GNU/Linux 5.4.0-67-generic x86_64)
Player Version#: Plex Web 4.51.3

I started using Plex Auto Collections a week ago. Today, I went to delete a collection and I was presented with a red error modal and Plex failed to remove the collection. I restored com.plexapp.plugins.library.db from a pre-PAC version, manually created a collection through Plex Web, and I got the same error when I tried to delete it.

Here is what shows up in the logs when I confirm delete:

Mar 18, 2021 15:01:49.653 [0x7f93a0ff9700] DEBUG - Request: [10.0.0.20:52294 (Subnet)] DELETE /library/collections/16683?includeExternalMedia=1 (5 live) TLS GZIP Signed-in Token (XXXXXXXX)
Mar 18, 2021 15:01:49.655 [0x7f94219b9700] DEBUG - Completed: [10.0.0.20:52294] 405 DELETE /library/metadata/16683?includeExternalMedia=1 (5 live) TLS GZIP 1ms 532 bytes (pipelined: 1)

I have run the commands to verify and repair a corrupt database to no avail. I have no issues deleting media or playlists, only collections.

For what it’s worth, I started digging into a copy of the database where (I believe) the collections are defined. I tried to manually delete the record and an error occurs:

$ sqlite3 com.plexapp.plugins.library.db
SQLite version 3.32.3 2020-06-18 14:16:19
Enter “.help” for usage hints.
sqlite> delete from metadata_items where id = 16672;
Error: no such collation sequence: icu_root
sqlite>

Thoughts? Thanks in advance for any assistance that can be provided!

2 Likes
2

I just tried deleting a collection and get the same error message. PMS version 1.22.1.4200 on linux and Plex Web 4.53.0.

1 Like
3

I am getting the same error with PMS version 1.22.1.4200 on Windows 10 and Plex Web 4.53.0. The log does not show anything useful.

Mar 18, 2021 22:43:30.876 [2596] Debug — Auth: authenticated user 1 as AngryVirginian
Mar 18, 2021 22:43:30.876 [4484] Debug — Request: [192.168.XX.XX:60775 (Subnet)] DELETE /library/collections/27267?includeExternalMedia=1 (16 live) TLS GZIP Signed-in Token (AngryVirginian)
Mar 18, 2021 22:43:30.877 [2596] Debug — Completed: [192.168.XX.XX:60775] 405 DELETE /library/metadata/27267?includeExternalMedia=1 (16 live) TLS GZIP 1ms 524 bytes (pipelined: 5)
Mar 18, 2021 22:43:37.767 [1300] Debug — Completed: [127.0.0.1:52361] 200 GET /player/proxy/poll?deviceClass=pc&protocolVersion=3&protocolCapabilities=timeline%2Cplayback%2Cnavigation%2Cmirror%2Cplayqueues&timeout=1 (16 live) GZIP 20010ms 5 bytes (pipelined: 16)
Mar 18, 2021 22:43:37.773 [1300] Debug — Auth: authenticated user 1 as AngryVirginian
1 Like
4

Thanks for reports. I’ve seen a few others. Trying to figure out what is going on.

4 Likes
5

On Windows Server 2019 PMS Version 1.22.1.4200 , having the same issues (can’t edit or delete newly auto generated collections). It seems I have no trouble with ones created a week ago & older.

1 Like
6

Was about to report the same thing lol

1 Like
7

A fix for this should be in 1.22.2 coming soon

8 Likes
8

@BigWheel Thank you very much for the prompt response and info around resolution!

1 Like
9

Guess its not fixed. I created 2 Collections and unassigned (untagged) the TV shows associated to the Collection. The collection has no TV show associated to it. As you can see below the command does initiate but does not delete the actual Collection.

“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing deleteItems”,
“time”: “2021-03-22T19:28:57.620Z”
},
{
“type”: “log:message”,
“level”: 3,
“message”: “[Metrics] Updating session last interaction time”,
“time”: “2021-03-22T19:28:57.626Z”
},
{
“type”: “ajax”,
“url”: “https://analytics.plex.tv/collect/event”,
“status”: 200,
“params”: “{“deviceIdentifier”:“m4acf00qva9kviqinok8edkv”,“context”:{“campaign”:{},“device”:{“product”:“Plex Web”,“version”:“4.53.0”,“platform”:“Chrome”,“platformVersion”:“89.0”,“device”:“Windows”,“model”:“hosted”,“screenResolution”:“1920x880,1920x1080”,“layout”:“desktop”,“protocol”:“https”},“user”:{“anonymous”:false,“plexpass”:“lifetime”}},“event”:“client:click”,“interaction”:true,“properties”:{“page”:“source”,“action”:“delete”,“type”:“collection”},“sessionIdentifier”:“884daa04-271f-4d30-8490-48e207a9ff32”}”,
“responseLength”: 0,
“time”: “2021-03-22T19:28:57.775Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing deleteItem”,
“time”: “2021-03-22T19:28:58.995Z”
},
{
“type”: “log:message”,
“level”: 4,
“message”: “[Commands] Executing deleteFile”,
“time”: “2021-03-22T19:28:58.995Z”

10

1.22.2 isn’t out yet. I was just told it should be out for Plex Pass users in beta next week

2 Likes
11

Same issue here
Waiting for a fix

12

Still have the same error after trying to delete a collection on PMS Version 1.22.1.4228 (mini update today). Will post again after 1.22.2 if problem persist.

Screenshot 2021-03-23 174054

Mar 23, 2021 17:34:26.524 [11268] Warning — QueryParser: Invalid field ‘readOnly’ found, ignoring.
Mar 23, 2021 17:35:03.065 [8164] Error — Unknown metadata type: folder
Mar 23, 2021 17:35:03.350 [10580] Error — Unknown metadata type: folder

13

Same Issue, but in addition, it erroneously created a collection for TV Movie that was saved in the Movies folder. when the movie was not part of a series.

14

Do you have this set to a low number? What tv movie was it?

Plex
Plex710×284 24.9 KB

15

I don’t have that option. My menu shows:

image
image730×385 26.4 KB
Capture2
Capture2720×214 13.7 KB

16

ok then you have not upgraded matching to new movie agent. Information is here about it.

17

Still broke. v 1.22.1.4228

1 Like
18

Can confirm this error is still persisting. v 1.22.1.4228
Please advise.

19

the fix is in 1.22.2 which is not out yet.

3 Likes
21

I didn’t create this collection i can’t delete.
I copied a movie, plex decided to create “Documentary” collection (hmm ok? nobody asked for this but OK?)
Now i deleted the movie.
And the collection sits there with 0 movies in it.