Server Version#: 1.18.1.1973
Player Version#: 4.8.3
I’m trying to migrate onto a new plex FreeNAS 11.2-U6 iocage ‘jail’ from an old FreeNAS 9.x jail. The old plex version is 1.13.95439.
The media mounts are the same between both, /media/{movies,tv_shows}, the actual media files have been mirrored over, as well the the old installation’s Plex Media Server/*.
Various permutations I have tried:
0) created the jail.
- started and configured the jail.
- rsync’d the media.
- performed/let pms perform rescans.
- observed media shows up and is playable. It’s just ‘teh suck’ of every file showing up as having been added ‘14 days ago’.
(NOTE: jail was down/up cycled between any db/install path shenanigans)
5) rsync’d Plex Media Server/* from the old jail to the new jail. Observed it falling all over itself. (Likely schema change unpleasantness).
Dec 03, 2019 00:20:16.747 [0x80ba16000] VERBOSE - BPQ: delaying processing 120 second(s)
Dec 03, 2019 00:20:16.748 [0x80ba16000] ERROR - Unable to open named mutex 9334581e-7251-4ef7-a8ec-5bfe8e89ff68 with option 1: File exists
Dec 03, 2019 00:20:16.748 [0x80ba16000] DEBUG - FeatureManager: Using cached data for features list
Dec 03, 2019 00:20:16.748 [0x80ba16000] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.26.0, threadsafe=1
Dec 03, 2019 00:20:16.752 [0x80ba16000] INFO - SQLITE3:(nil), 283, recovered 624 frames from WAL file /Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db-wal
Dec 03, 2019 00:20:16.753 [0x80ba16000] ERROR - SQLITE3:(nil), 11, database corruption at line 122744 of [bf8c1b2b7a]
Dec 03, 2019 00:20:16.753 [0x80ba16000] ERROR - SQLITE3:(nil), 11, database corruption at line 65066 of [bf8c1b2b7a]
Dec 03, 2019 00:20:16.753 [0x80ba16000] ERROR - SQLITE3:(nil), 11, statement aborts at 8: [] database disk image is malformed
Dec 03, 2019 00:20:16.753 [0x80ba16000] ERROR - SQLITE3:(nil), 11, malformed database schema (MaxObservedChangestamp) in "PRAGMA cache_size=2000"
Dec 03, 2019 00:20:16.753 [0x80ba16000] ERROR - Database corruption: sqlite3_statement_backend::prepare: malformed database schema (MaxObservedChangestamp) for SQL: PRAGMA cache_size=20005’) Attemped to follow a purported solution here. This fails for similar reasons as above.
5’’) Thought perhaps the create_at column from media_parts would be a reasonable thing the Date Added sort would use. To that end, I wrote a script to get the created_at dates from the old db and update that column in the same table in the new db where file like ‘%${fname}%’. Resulting in:
$ echo "select id,created_at,file from media_parts where file is not '' limit 10;" | sqlite3 new.db
1|2018-07-18 01:02:18|/media/movies/Black Panther (2018)/Black Panther (2018) - 1080p.mkv
2|2018-07-18 01:01:20|/media/movies/Black Panther (2018)/Black Panther (2018) - 2160p.mkv
63|2017-01-13 10:14:08|/media/tv_shows/Alien Nation/Season 01/Alien Nation - S01E01 - Alien Nation The TV Movie.mkv
64|2017-01-13 10:14:08|/media/tv_shows/Alien Nation/Season 01/Alien Nation - S01E02 - Fountain of Youth.mkv
65|2017-01-13 10:14:08|/media/tv_shows/Alien Nation/Season 01/Alien Nation - S01E03 - Little Lost Lamb.mkv
66|2017-01-13 10:14:08|/media/tv_shows/Alien Nation/Season 01/Alien Nation - S01E04 - Fifteen with Wanda.mkv
67|2017-01-13 10:14:07|/media/tv_shows/Alien Nation/Season 01/Alien Nation - S01E05 - The Takeover.mkv
68|2017-01-13 10:14:08|/media/tv_shows/Alien Nation/Season 01/Alien Nation - S01E06 - The First Cigar.mkv
69|2017-01-13 10:14:08|/media/tv_shows/Alien Nation/Season 01/Alien Nation - S01E07 - Night of the Screams.mkv
70|2017-01-13 10:14:08|/media/tv_shows/Alien Nation/Season 01/Alien Nation - S01E08 - Contact.mkvAfter emplacing that db, and restarting the jail/plex the sorting still shows the same w/everything being added ‘14 days ago’.
So what/where is the magical juju special thingy that must be altered/migrated/mapped from the prior installation to the new one that controls this sort order? This should.not.be.this.hard. 
Thanks!
