This thread is the split off of the primary research thread https://forums.plex.tv/discussion/254362/tv-series-name-matching-research
The purpose of this thread is to help and resolve issues asked/ identified in the primary thread wherever possible
How do I find the database location when PMS is installed on a Synology NAS?
Never mind, found it
If I upload a copy of my db file, can someone repair it and send it back? I REALLY don’t want to have to start over with a new database and lose a couple of years worth or work. 
There is no way to ‘repair’ a DB in isolation. The data in it pertains only to your list of files & directories as they exist in your system. As such, it would take a complete pathname listing of all media, and a full dump from Library down. The database itself is only the glue.
Before you just burn it all down, What, specifically, is the problem?
The same issue I’ve been having for over a month now. It’s no longer picking up ep 10 or ep 11 of any show upon import.
Do you have the distribution package for 1.2.7 available?
Where I am going with this is:
a) remove 1.3.3, keeping your library intact
b) install 1.2.7, and see if this has any impact (refresh / analyze some of the “Episode 10” files).
c) upgrade back to 1.3.3 and then add more “Episode 10” files elsewhere.
I propose this because there is nothing special between ‘09’ , ‘10’ or even ‘20’. Why episode 10?
There has to be an external influence. This is the challenge to find.
Unfortunately not. Where could I find old downloads for synology?
Plex doesn’t make older versions available via the web page anymore. I know, a pain.
Apologies if I forgot. I didn’t realize this is synology.
Conduct this test with me.
- Stop PMS (package center)
- Open FileStation.
- Navigate to the Plex share and rename “Library” to “Library-save”
- Start PMS
- Perform first-run again but do not add any libraries in the wizard
- Upon reaching the dashboard, add 1 library containing “Episode 10” files you are experiencing problems with (make a test share if easier)
OK, so that appears to confirm that my primary database is corrupt. The new database is picking up episodes 10 and 11 on all of the shows in question.
In the Databases directory, you will find other database backups if they were enabled.
You can ‘rotate’ through them to attempt recovery. You will have lost any work since the date of the backup but better than losing everything
A ‘Share level’ backup > 30 days old would also serve well
OK, so I just started a new database, everything seems to be showing up properly, but now my dashboard has stopped showing up. Any ideas? 
Slow/timeout?
of course the ‘F5’ trick. what is the CPU showing? The one thing SQLite3 can’t cope with dynamically is becoming lopsided when a lot of media gets added.
If you check the Plex Media Server.log and see “SLOW QUERY” this is what’s happening. The DB needs optimizing but you need the UI to do it.
I should have best warned you in the process of doing a full build with a lot of media. I have been reminding evrything I can to do one section / large folder/directory at a time and “Optimize Database” between directory additions to a section. When folks add 3000 movies or something that big, it’ll get lopsided fast.
That resolved it. Thanks for all of your help!
Optimize Database resolved it for you?
