There was a problem emptying the trash

Plex Media Server Metadata & Adding Files
1

Server Version#: Version 1.41.0.8994

Hi,
I’ve had a littel hiccup where some media data got lost.
Now I have multiple items shown as “Unavailable”. I don’t want to delete each of them manually since there are quite a few.

I’ve read that emptying the trash will get rid of these. However when I click this I get a red pop up “There was a problem emptying the trash” and that’s it.
I also checked the "Empty trash automatically after every scan " checkbox, but that also doesn’t get rid of things.

In the logs i see the following exception:

Sep 30, 2024 22:27:26.977 [140286090537784] INFO - Request: [10.10.20.6:52971 (Allowed Network (WAN))] PUT /library/sections/3/emptyTrash (3 live) #48ab TLS GZIP Signed-in
Sep 30, 2024 22:27:27.698 [140286090537784] ERROR - [Req#48ab] Exception inside transaction (inside=1) (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/MetadataItem.cpp:856): Null value fetched and no indicator defined.
Sep 30, 2024 22:27:27.698 [140286090537784] ERROR - [Req#48ab] Exception inside transaction (inside=1) (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/MediaItem.cpp:911): Null value fetched and no indicator defined.
Sep 30, 2024 22:27:27.721 [140286090537784] ERROR - Got exception from request handler: Null value fetched and no indicator defined.
Sep 30, 2024 22:27:27.721 [140286173575992] INFO - Completed: [10.10.20.6:52971] 500 PUT /library/sections/3/emptyTrash (3 live) #48ab TLS GZIP 744ms 530 bytes (pipelined: 1)

I’m happy about any pointers where the issue might be.

Cheers,
marvin

2

Two choices here:

  1. “Auto” repair – which might get it (if not too damaged)
  2. “Replace” – and pick a backup DB where you know it’s good.
3

Thanks for the link to the repair tool.
Seems the database is ok and it didn’t find any issues.
I did the optimize/reindex anyway, doesn’t hurt.

However the issue still remains:

Oct 01, 2024 22:26:58.935 [140122084698936] INFO - Request: [10.10.20.6:58563 (Allowed Network (WAN))] PUT /library/sections/3/emptyTrash (9 live) #8625 TLS GZIP Signed-in
Oct 01, 2024 22:26:59.592 [140122084698936] ERROR - [Req#8625] Exception inside transaction (inside=1) (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/MetadataItem.cpp:856): Null value fetched and no indicator defined.
Oct 01, 2024 22:26:59.592 [140122084698936] ERROR - [Req#8625] Exception inside transaction (inside=1) (/home/runner/actions-runner/_work/plex-media-server/plex-media-server/Library/MediaItem.cpp:911): Null value fetched and no indicator defined.
Oct 01, 2024 22:26:59.620 [140122084698936] ERROR - Got exception from request handler: Null value fetched and no indicator defined.
Oct 01, 2024 22:26:59.621 [140122183039800] INFO - Completed: [10.10.20.6:58563] 500 PUT /library/sections/3/emptyTrash (9 live) #8625 TLS GZIP 686ms 530 bytes (pipelined: 54)

Anything else I could try?
Manually removing/deleting items works, however not the empty trash function.

Oct 01, 2024 22:29:17.565 [140122084698936] INFO - Request: [10.10.20.6:58698 (Allowed Network (WAN))] DELETE /library/metadata/29180 (4 live) #8631 TLS GZIP Signed-in
Oct 01, 2024 22:29:17.813 [140122183039800] INFO - Completed: [10.10.20.6:58698] 200 DELETE /library/metadata/29180 (4 live) #8631 TLS GZIP 247ms 320 bytes (pipelined: 2)

I don’t have a backup of the DB available where the issue is not present

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.