Cannot get PMS to run after restoring from Hyperbackup to a new NAS

Plex Media Server NAS & Devices
1

Server Version#: 1.29.2.6364-7000
Player Version#:

So I recently had a catastrophic two disk failure on my old SHR-1 NAS and took the opportunity to build a new DS923+ NAS with a 4-disk SHR-2 array and restored my “folders and packages” Hyperbackup to the new machine.

All the folders and most packages were restored but I did need to manually reinstall Plex (and a couple of others) for some reason.

During reinstallation I got the relink code from Plex and used that during the installation.

Now whenever I try to run the PMS service it starts, and then pretty much immediately stops.

Plex Media Server.log (47.9 KB)

Any recommendations?

2

The log file contains several database errors.

log snippet 
Jun 04, 2024 18:07:36.562 [0x7fda4245a0d0] ERROR - SQLITE3:0x80000001, 1, near ">>": syntax error in "UPDATE tags SET extra_data = extra_data ->> 'url' WHERE extra_data IS NOT NULL and json_valid(extra_data)"
Jun 04, 2024 18:07:36.563 [0x7fda4245a0d0] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/3537899744/Library/DatabaseMigrations.cpp:289): sqlite3_statement_backend::prepare: near ">>": syntax error for SQL: UPDATE tags SET extra_data = extra_data ->> 'url' WHERE extra_data IS NOT NULL and json_valid(extra_data)
Jun 04, 2024 18:07:36.564 [0x7fda4245a0d0] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::prepare: near ">>": syntax error for SQL: UPDATE tags SET extra_data = extra_data ->> 'url' WHERE extra_data IS NOT NULL and json_valid(extra_data)

What version of Plex Media Server was installed on the old NAS?

If 1.40 or higher, you will need to run that same or more current version of Plex Media Server.

1.40 introduced many database changes. It is not possible to fall back to versions before 1.31.2. See release notes.

Suggestion: Delete current installation, start over with current PMS version.

NOTE: This assumes the old NAS was running DSM 7. If it was on DSM 6, then a different procedure is needed.

Uninstall PMS 1.29.2 with the Erase option (appears after the “are you sure” prompt). This uninstalls the application and removes files from the /PlexMediaServer shared folder. Your media files are not touched.

If anything is left in /PlexMediaServer, remove it manually.

Restore /PlexMediaServer from the backup.

If it exists, rename the preferences.xml file to preferences.xml.bak (in /PlexMediaServer/AppData/Plex Media Server). It has the server ID & other info specific to the old server.

Download and install the current version of PMS from plex.tv. You want the DSM 7, Intel/AMD 64-bit version.

Run PMS.

From a system on the same network, use a private/incognito browser window pointed at the IP address of the NAS: http://192.168.178.100:32400/web.

You should be able to login, reach server settings, and claim the server. If you see the screens for setting up a new server, just skip through those.

3

Luckily I still have some logs from before the failure, though only seems to be relating to media scanner.

So in the Media Scanner log from the 16th May I can see
Plex Media Scanner v1.40.0.7998-c29d4c0c8 - Synology DS920+
DSM 7.2.1.69057-4

Does that help to narrow down what Media Server version I would have been on? I have a feeling I updated fairly recently… but can’t be sure.

Plex Media Scanner.log (4.3 KB)

4

You were using 1.40.0 (the first version with the new DB structure)

May 16, 2024 22:34:16.666 [140704852192000] INFO - Plex Media Scanner v1.40.0.7998-c29d4c0c8 - Synology DS920+ x86_64 - build: linux-x86_64 - GMT 02:00

I’ve found you can go back to 1.32.8 if you still have the SPK file handy but a damaged DB is still “damaged” and needs repairing or rebuilding.

5

Cool, thanks. I’ll try that in the morning and see if I can get anything working. It’d be nice to not lose all my watch/listening history.

Thanks!

6

Weird that Synology installed 1.29? I thought I had updated through Synology’s package manager. So would I not be better first trying to install 1.40+ and see if that just works? and failing that try 1.32?

7

Oh! No, I had manually downloaded “PlexMediaServer-1.40.0.7998-c29d4c0c8-x86_64_DSM7”.

So I did a manual install of that just now and plex started running straight away and everything appears to be working and accessible. I’ll double check in the morning!

Thanks. I don’t think I would have spotted this otherwise! :slight_smile:

8

Package Center only offers 1.29.2.6364 .

They will not upgrade our package. :pouting_cat:

When you use package center MANUAL INSTALL, you can install any version you want.

9

Yeah, I must have completely forgotten that I’d used Manual Install in the past :grin:

At least everything is working now! I just needed to get the same version installed :+1:

Thanks!

10

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