Having problems with libraries disappearing or not appearing properly

[jimboz]

So I’ve been using Plex for well over a year I think, and it’s been for the most part working perfectly fine. Recently though, weird things started to happen and I have no idea why.

My MOVIES library one day decided to not be viewable if filtered by Title and a few other filters, but could be viewed by others. TV SHOWS was still working however.

No idea how, but I finally was able to get movies working again. All 121 movies appear in Plex, and can be filtered by anything, and are playable. The one issue however is that 18 random movies refuse to grab the posters and plot/cast information, no matter how many times I refresh metadata. (the metadata refresh symbol will just keep spinning but doing nothing)

But now, TV SHOWS does not work at all. Nothing will show up at all on my NVIDIA Shield Plex app. I’ve tried refreshing the metadata, optimizing the database, emptying the trash, deleting the library and making a new one, multiple times, with different names, I even tried moving the source files to a different folder and again making a new library. I tried updating Plex, uninstalling it and reinstalling it, rebooting the NAS, but nothing worked.

Whenever I make a new library, all the shows appear on the server (but without any metadata or even any episodes if you click into them. It’ll just say “Unable to load seasons”). Refreshing the metadata for the whole library does nothing at all other than have the ring spin for a second. But i does semi-work if you select the individual shows and refresh them that way. You’ll get the posters and some limited information that way, and the episodes will be watchable via the server, but on my Nvidia Shield app, the library will still say there’s nothing there.

I’ve tried Emby, but that seems to come with it’s own different set of problems, and is just a bit uglier and more annoying to use.

Don’t know what to do any more. Should I just delete the account and start from scratch on a new account? Would that fix this?

My server is on a Synology DS918+

Server Version#: 3.108.2

[ChuckPa]

The version you reference sounds like the Web app version and not the server.

Settings - Server - General will show you the server version.

Would it be possible to

1. Restart Plex
2. Let it set 2 minutes to startup and stabilize
3. Settings - Server - Troubleshooting - Download Logs
4. Attach the ZIP file it gives you.

This will let me see if there is a major server issue or if your issue is in the app itself.

[jimboz]

Ah yeah my mistake: Server Version#: 1.16.5.1552

Plex Media Server Logs_2019-11-21_14-36-02.zip (3.3 MB)

[ChuckPa]

Thanks for the logs. I found it.

The database got damaged somehow (abrupt shutdown / power off / something like that)

Nov 21, 2019 13:43:29.050 [0x7f1863447700] DEBUG - Request: [192.168.1.14:57963 (Subnet)] GET /hubs/home/recentlyAdded?type=2 (14 live) TLS Page 0-15 GZIP Signed-in Token (jimmy_09@live.com.au)
Nov 21, 2019 13:43:29.050 [0x7f18b2473700] ERROR - SQLITE3:(nil), 11, database corruption at line 79051 of [bf8c1b2b7a]
Nov 21, 2019 13:43:29.050 [0x7f18b2473700] ERROR - SQLITE3:(nil), 11, statement aborts at 22: [select metadata_items.id from metadata_item_settings join metadata_items on metadata_items.guid=metadata_item_settings.guid and metadata_item_settings.account_id=? where  view_offset>0
Nov 21, 2019 13:43:29.052 [0x7f18b2a4f700] DEBUG - Auth: authenticated user 1 as jimmy_09@live.com.au
Nov 21, 2019 13:43:29.052 [0x7f18b2473700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed

Depending on how long it’s been this way, you can recover using one of the database backups.

Here is the full procedure.

1. Stop Plex in Package Center
2. Control Panel - Shared Folders - EDIT the Plex share
3. Permissions tab - Give your Synology username permission to R/W
4. File Station - Plex share
5. Drill into it , down into it and into the Databases directory.
6. You should see the com.plexapp.plugins.library.db (this is the current DB)
7. You should also see backup copies (date stamped in name)
8. Using FileStation, rename the current one to com.plexapp.plugins.library.db-corrupt
9. Now take your most recent backup
10. Select the most recent backup then, Copy & paste (to make a duplicate)
11. Rename the duplicate to be com.plexapp.plugins.library.db
12. Right-click on the file → Properties
13. Verify the owner is plex. If not plex change it to be plex.
14. Now back out to Package Center
15. Start Plex.
16. Give it a minute to catch up with this database.
17. Open Plex .
18. Scan Files
19. Empty Trash
20. Clean Bundles

[jimboz]

It worked Legend. Thank you so much