Plex not finding ALL new files added to Library, Not a naming issue

Plex Media Server
, ,
1

Server Version#: 1.31.3.6868
Player Version#: ALL
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>

I’m having a problem i can’t work out, As of about a week ago, all new media added to the plex library folders will not appear in the plex library. If i navigate the libaray in plex via folders, i can find the newly created folder, however plex shows it as empty, the files are named correctly, and i have tried changing the file names to force a re-detect but nothing will bring them into the library. I have verified the files are working via VLC in windows, i have checked that they have the correct permissions (or at least the same permissions as all the other files)
Server is running on unraid in a docker container, and no changes had been made to any part of the server for 35 days, so this didn’t pop up as a new bug via an update.
To trouble shoot, I have tried running the entire plex container through my VPN (incase something like TVDB had been blocked at ISP) but that didn’t work, i have tried creating a new library pointed at the same folder, that produced nothing at all (no new, or existing files are found/usable, library shows as empty) i also don;t seem to be able to delete the libraries, i can select delete, confirm it, but the library just stays put, no error is returned (at least that i can see) i also now seem to have one TV series constantly updating metadata over and over again in a never ending loop.

To me this seems to be something silly like, i’ve run out of space for my library somehow, and instead of throwing an error, the server just writes the new data to nowhere and proceeds with its business, I’m not short of space, with around 54TB total, of which 35TB is still available.

I managed to pull up the logs of the library scanner, and it seemed to show it scanning that folder, finding nothing and moving on, is there an issue with the TVDB or the way plex matches shows to metadata?

Any advise, or troubleshooting steps are more than welcome.

2

The two most common issues is permissions (it’s a NX system) and file naming.

Please post your server logs, exact path and filename of one of the affected files.

3

Logs below:
Plex Media Server Logs_2023-04-05_21-42-42.zip (4.4 MB)

The one i’ve been focusing on has been (i believe inside the container at least) /data/TV Shows/TVShows/Taskmaster/Season 15/Taskmaster.S15E01.The.Curse.of.Politeness.1080p.ALL4.WEBRip.AAC2.0.H264-TEiLiFiS[rarbg].mkv

I get the following back when i check the permissions the container can see for that folder (from inside the docker console):

ls -la

total 1440908
drwxr-xr-x 1 plex users 113 Apr 5 21:40 .
drwxrwxrwx 1 plex users 31 Mar 31 16:49 ..
-rw-rw-rw- 1 plex users 1475486281 Mar 30 21:00 ‘Taskmaster.S15E01.The.Curse.of.Politeness.1080p.ALL4.WEBRip.AAC2.0.H264-TEiLiFiS[rarbg].mkv’

(should note, i don’t know where the scanner has gotten to, or how that will be recorded in the logs, i recently changed the file name (just added all the “WEBRIP AAC2 ect” garbage at the end in the hopes that might prompt something from the scanner)

4

I forgot to add the 3rd most common issue, which is what you are dealing with:
Apr 01, 2023 22:16:58.998 [0x14cbbd48fb40] ERROR - SQLITE3:0x80000001, 11, database corruption at line 72267 of [a29f994989]

Apr 01, 2023 22:16:58.998 [0x14cbbd48fb40] ERROR - SQLITE3:0x80000001, 11, statement aborts at 3: [SELECT value FROM 'main'.'fts4_metadata_titles_icu_stat' WHERE id=?] database disk image is malformed

EDIT: ADD: here is a link to fix your databases GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases

I will also point out two other issues, your library should be pointing to /mnt/TV_Shows/TVShows not /mnt/TV_Shows and your file naming could be improved (you dont follow the naming 100%.

My canned response is to see https://support.plex.tv/articles/naming-and-organizing-your-tv-show-files/ and:

If you want to save yourself a lot of time I would recommend using Download - tinyMediaManager and use:

Episode format:
${showTitle} - S${seasonNr2}E${episodeNr2} - ${title}

Folder format:
${showTitle} (${showYear}) {tvdb-${tvShow.ids.tvdb}}/Season ${seasonNr2}

as the new name format.
(Please note I linked to the v3 which is free to use)

1 Like
5

If changing anything, you should rather remove that stuff, in order not to confuse the scanner. It won’t use any of the hints which all relate to pirating. Plex doesn’t use anything of that.

But yeah, the prime issue is the database corruption. Resolve this first, before trying anything else.

6

Maaaaate… what a legend.
took a bit of messing around (was trying to launch the script via SSH into unraid, rather than inside the container because it said “Plex has to be stopped”)
finally worked it out, got it going and all good, found the errors repaired them, started up PMS and straight away everything that was missing started appearing.
100% sorted my issue, thanks for your quick reply.

Yea, that is what I thought, and that was the first thing I did, I decided to try and add it back, but used the info from a known working file. The current naming comes from the grabber i use, i seem to have broken the naming scheme i set-up ages ago, everything else aside from the last 6-ish months is named cleanly i just haven’t gotten around to fixing it as it wasn’t really causing issues, although, It wouldn’t surprise me if something in the name of a file is what caused my recent issues, I didn’t import an episode called “DROP TABLE Students;–” did I? :sweat_smile:

7

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