New Movies won't appear

Hi All,

I’ve suddenly noticed that movies added to my system are no longer being picked up by the automatic or manual “scan library files”. for example, I’ve attached my logfiles, and although the movie “Bloodshot” is found it is not added and doesn’t appear in the web client.

Can anyone guide me in the right direction?

Thanks, Dean.
Server Version#: Version 1.19.5.3035
Player Version#: Version 4.34.3
Plex Media Server Logs_2020-08-03_19-36-55.zip (4.9 MB)

You’ve a corrupt database.

In Plex Media Server.log:
Aug 03, 2020 19:28:12.349 [0x7f421ab7d700] ERROR - SQLITE3:(nil), 11, database corruption at line 79051 of [bf8c1b2b7a]

This repeats 700+ times in Plex Media Server.log.

Aug 03, 2020 15:46:03.542 [0x7f41d6e6b700] ERROR - SQLITE3:(nil), 1, statement aborts at 1: [COMMIT] cannot commit - no transaction is active
Aug 03, 2020 15:46:03.542 [0x7f41d6e6b700] ERROR - Failed to commit transaction (../Library/MetadataItem.cpp:1020) (tries=4): Cannot commit transaction. cannot commit - no transaction is active

Options:

  1. Try to repair.
  2. Restore from backup.
  3. Delete it & start over.

To repair, you’ll need to SSH into your Synology (FAQ 14 ). See Repair A Corrupt Database , Linux section, for the instructions you’ll have to issue. My DS918+ has sqlite3 installed, so you may not have to install it on your system (the article says it is not installed on Linux systems).

See Synology FAQ 17 to restore from a backup.

Deleting the database is almost like starting over. You files are safe, but you’ll have to re-create libraries, re-share them if you share with others, etc. See the Repair A Corrupt Database article. Look for the text in the blue box, about the fifth paragraph.

Synology FAQ #17

Repair A Corrupt Database

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