New Movies won't appear

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