Synology: DSM 7 Installation Archive -- Archived from main thread

SandmanXX · June 24, 2023, 11:46pm

Well crap. Automatic failed, and repair failed, 5 lines of code listed,

Runtime error near line 2379423: UNIQUE constraint failed: statistics_media.id (19)

FordGuy61 · June 24, 2023, 11:53pm

Try Option 9, replace. It will check the backup versions, if any exist, and see if any of them are OK.

Example:

Enter command # -or- command name (4 char min) : 9

Checking the PMS databases
Check complete.  PMS main database is OK.
Check complete.  PMS blobs database is OK.
Are you sure you want to restore a previous database backup (Y/N) ? y
yChecking for a usable backup.
Database backups available are:  2023-06-22 2023-06-19 2023-06-16 2023-06-13
Checking database 2023-06-22
Found valid database backup date: 2023-06-22
Use backup '2023-06-22' ? (Y/N) ?

SandmanXX · June 24, 2023, 11:55pm

Letting it run one more pass, then that will be next. Not sure how long it’s been corrupted, tho.
Trying to make it stop running now.

SandmanXX · June 25, 2023, 12:06am

Says PMS main db is damaged, blobs ok. No backups available. Only available option is repair, and repair didn’t work. Could that be because I ran the newest (non-working) release of plex?
Logs show:

==================================================================================
2023-06-24 19.36.14 - ============================================================
2023-06-24 19.36.14 - Session start: Host is Synology (DSM 7)
2023-06-24 19.36.25 - Auto    - START
2023-06-24 19.36.28 - Check   - Check com.plexapp.plugins.library.db - FAIL (DBRepair.log com.plexapp.dlna.db com.plexapp.dlna.db-shm com.plexapp.dlna.db-wal com.plexapp.plugins.library.blobs.db com.plexapp.plugins.library.blobs.db-2022-09-22 com.plexapp.plugins.library.blobs.db-2022-09-25 com.plexapp.plugins.library.blobs.db-2022-09-28 com.plexapp.plugins.library.blobs.db-2022-10-01 com.plexapp.plugins.library.blobs.db-shm com.plexapp.plugins.library.blobs.db-wal com.plexapp.plugins.library.db com.plexapp.plugins.library.db-2021-01-30 com.plexapp.plugins.library.db-2021-02-02 com.plexapp.plugins.library.db-2021-02-05 com.plexapp.plugins.library.db-2021-02-08 com.plexapp.plugins.library.db-damaged dbtmp in database main DBRepair.log com.plexapp.dlna.db com.plexapp.dlna.db-shm com.plexapp.dlna.db-wal com.plexapp.plugins.library.blobs.db com.plexapp.plugins.library.blobs.db-2022-09-22 com.plexapp.plugins.library.blobs.db-2022-09-25 com.plexapp.plugins.library.blobs.db-2022-09-28 com.plexapp.plugins.library.blobs.db-2022-10-01 com.plexapp.plugins.library.blobs.db-shm com.plexapp.plugins.library.blobs.db-wal com.plexapp.plugins.library.db com.plexapp.plugins.library.db-2021-01-30 com.plexapp.plugins.library.db-2021-02-02 com.plexapp.plugins.library.db-2021-02-05 com.plexapp.plugins.library.db-2021-02-08 com.plexapp.plugins.library.db-damaged dbtmp On tree page 640825 cell 41: Extends off end of page)
2023-06-24 19.37.08 - Check   - Check com.plexapp.plugins.library.blobs.db - PASS
2023-06-24 19.37.08 - Check   - FAIL
2023-06-24 19.40.43 - Repair  - Export databases - PASS
2023-06-24 19.42.36 - Repair  - Cannot import main database from './dbtmp/library.plexapp.sql-2023-06-24_19.36.25' - FAIL (1)
2023-06-24 19.42.36 - Repair  - FAIL
2023-06-24 19.42.36 - Auto    - FAIL
2023-06-24 19.46.10 - Repair  - Export databases - PASS
2023-06-24 19.48.05 - Repair  - Cannot import main database from './dbtmp/library.plexapp.sql-2023-06-24_19.42.36' - FAIL (1)
2023-06-24 19.48.05 - Unknown command:  'Runtime error near line 2379424: UNIQUE constraint failed: statistics_media.id (19)'
2023-06-24 19.48.05 - Unknown command:  'Runtime error near line 2379425: UNIQUE constraint failed: statistics_media.id (19)'
2023-06-24 19.48.05 - Unknown command:  'Runtime error near line 2379426: UNIQUE constraint failed: statistics_media.id (19)'
2023-06-24 19.48.05 - Unknown command:  'Error 1 from Plex SQLite while importing from './dbtmp/library.plexapp.sql-2023-06-24_19.36.25''
2023-06-24 19.48.05 - Unknown command:  'Cannot continue.'
2023-06-24 19.53.20 - Repair  - Export databases - PASS
2023-06-24 19.55.14 - Repair  - Cannot import main database from './dbtmp/library.plexapp.sql-2023-06-24_19.48.05' - FAIL (1)
2023-06-24 19.55.14 - Unknown command:  'Runtime error near line 2379424: UNIQUE constraint failed: statistics_media.id (19)'
2023-06-24 19.55.14 - Unknown command:  'Runtime error near line 2379425: UNIQUE constraint failed: statistics_media.id (19)'
2023-06-24 19.55.14 - Unknown command:  'Runtime error near line 2379426: UNIQUE constraint failed: statistics_media.id (19)'
2023-06-24 19.55.14 - Unknown command:  'Error 1 from Plex SQLite while importing from './dbtmp/library.plexapp.sql-2023-06-24_19.36.25''
2023-06-24 19.55.14 - Unknown command:  'Cannot continue.'
2023-06-24 19.59.50 - Repair  - Export databases - PASS
2023-06-24 20.01.45 - Repair  - Cannot import main database from './dbtmp/library.plexapp.sql-2023-06-24_19.55.14' - FAIL (1)
2023-06-24 20.01.45 - Exit    - Retain temp files.
2023-06-24 20.02.24 - ============================================================
2023-06-24 20.02.24 - Session start: Host is Synology (DSM 7)
2023-06-24 20.04.56 - Replace - Check com.plexapp.plugins.library.db - FAIL (DBRepair.log com.plexapp.dlna.db com.plexapp.dlna.db-shm com.plexapp.dlna.db-wal com.plexapp.plugins.library.blobs.db com.plexapp.plugins.library.blobs.db-2022-09-22 com.plexapp.plugins.library.blobs.db-2022-09-25 com.plexapp.plugins.library.blobs.db-2022-09-28 com.plexapp.plugins.library.blobs.db-2022-10-01 com.plexapp.plugins.library.db com.plexapp.plugins.library.db-2021-01-30 com.plexapp.plugins.library.db-2021-02-02 com.plexapp.plugins.library.db-2021-02-05 com.plexapp.plugins.library.db-2021-02-08 com.plexapp.plugins.library.db-damaged dbtmp in database main DBRepair.log com.plexapp.dlna.db com.plexapp.dlna.db-shm com.plexapp.dlna.db-wal com.plexapp.plugins.library.blobs.db com.plexapp.plugins.library.blobs.db-2022-09-22 com.plexapp.plugins.library.blobs.db-2022-09-25 com.plexapp.plugins.library.blobs.db-2022-09-28 com.plexapp.plugins.library.blobs.db-2022-10-01 com.plexapp.plugins.library.db com.plexapp.plugins.library.db-2021-01-30 com.plexapp.plugins.library.db-2021-02-02 com.plexapp.plugins.library.db-2021-02-05 com.plexapp.plugins.library.db-2021-02-08 com.plexapp.plugins.library.db-damaged dbtmp On tree page 640825 cell 41: Extends off end of page)
2023-06-24 20.05.26 - Replace - Check com.plexapp.plugins.library.blobs.db - PASS
2023-06-24 20.05.26 - Replace - Scan for usable candidates - FAIL
==================================================================================

FordGuy61 · June 25, 2023, 12:26am

@SandmanXX Quick question. Did you run the DBRepair utility with sudo or directly as root? It must be run that way to succeed.

SandmanXX · June 25, 2023, 12:26am

I wonder if I start up the last working plex, then try the DB repair again. Here’s the last run on repair:

Enter command # -or- command name (4 char min) : repair

Exporting current databases using timestamp: 2023-06-24_20.20.24
Exporting Main DB
Exporting Blobs DB
Successfully exported the main and blobs databases. Proceeding to import into new databases.
Importing Main DB.
Runtime error near line 2379423: UNIQUE constraint failed: statistics_media.id (19)
Runtime error near line 2379424: UNIQUE constraint failed: statistics_media.id (19)
Runtime error near line 2379425: UNIQUE constraint failed: statistics_media.id (19)
Runtime error near line 2379426: UNIQUE constraint failed: statistics_media.id (19)
Error 1 from Plex SQLite while importing from ‘./dbtmp/library.plexapp.sql-2023-06-24_20.20.24’
Cannot continue.

SandmanXX · June 25, 2023, 12:27am

I think I ran it as root.

I did sudo -i

FordGuy61 · June 25, 2023, 12:29am

Give it a try. It might work.

Uninstall Plex Media Server with the “keep” option. Uninstall → Are You Sure → Uninstall Only.

You can then install the older version.

FordGuy61 · June 25, 2023, 12:29am

That works. Just wanted to check.

SandmanXX · June 25, 2023, 12:37am

I got 6973 up and running, logged on to see if it works.
Still says Main DB is damaged. Don’t know where to go from here, except a complete rebuild, I guess.

ChuckPa · June 25, 2023, 12:38am

Suggest?

Get in there (script) interactively.
Stop PMS
Attempt to have it restore a backup, starting with the OLDEST one.
Stay in the tool after restoring (DO NOT EXIT)
Start PMS
Evaluate PMS behavior
If still not working (same errors) then all backups are contaminated.
If working,
– exit
– scan / refresh all metadata
– deal with any potential loss.

Solve why it got shutdown HARD

SandmanXX · June 25, 2023, 12:39am

There are no backups, somehow. I started the oldest working, seems to work fine generally. movie and music all there.

ChuckPa · June 25, 2023, 12:41am

If there are no backups ?
– this is a new installation and it got corrupted that fast ? WHY? Power fail? Hard Power OFF / Shutdown of DSM ?

If you have only a corrupt section or two…
– delete each and recreate

SandmanXX · June 25, 2023, 12:42am

This installation is 3+ years old, I occasionally optimize database by hand, has seemed to work fine, I don’t know what part is corrupted, or I would wipe and rebuild whatever part is bad. There have been 2-3 power outs at the house over the past 2 years, although the NAS is on a UPC, who knows on that one.

ChuckPa · June 25, 2023, 12:44am

Sorry if i’m slow here.

what happened to the backup files which PMS makes automatically every 3 days?

SandmanXX · June 25, 2023, 12:46am

They don’t exist.

Where would they be?

ChuckPa · June 25, 2023, 12:48am

The backups would be (by default) adjacent the actual database files in the ‘Databases’ directory

unless you changed the backup location in settings - Server - Scheduled Tasks.

Side note: There is a way to “force” this to import. Cannot guarantee the result but it can be forced.

SandmanXX · June 25, 2023, 12:49am

After running dbrepair, it couldn’t find the backups, so I’m up for whatever we need to do.
And yes, the backup files are under pluginsupport/databases

ChuckPa · June 25, 2023, 12:50am

The script doesn’t remove the PMS-created backup files. They are held as sacred / pristine.

SandmanXX · June 25, 2023, 12:52am

Are you recommending the import option in dbrepair? still have that open atm
In hindsight, it appears the last backups were made in 9-22. well now.

Topic		Replies	Views
Synology - DSM 7.0 Release - Plex Installation (Not Operational) Issues NAS & Devices server-synology	196	120960	March 7, 2025
DSM 7 files not available NAS & Devices server-synology	63	2985	January 30, 2022
Synology 7 Upgrade - Lost All History NAS & Devices server-synology	50	724	April 20, 2022
Synology DSM 7 - Plex Media Server Installation Issue NAS & Devices server-synology	33	1389	February 16, 2022
Plex Media Server - Synology DSM 7 Preview - Issues ( Archive ) NAS & Devices server-synology	3050	16544	October 25, 2021

Synology: DSM 7 Installation Archive -- Archived from main thread

Related topics