Don’t delete anything yet.
Please verify your version of Plex Media Server. “Latest” is not helpful, as there are multiple builds (public, beta, alpha, forum previews, etc.) that can be updated at any time.
There is a problem with some of the 1.41.7 builds that causes massive growth in the database files.
You’ve definitely been bitten. Your current database is 77 GB. Your backups on May 18th and earlier are 240 MB.
Stop the Growth
First, stop the growth. Either update to the current beta, 1.41.7.9823 (release notes), or fall back to to 1.41.6 (see this thread for download links).
Options
Next, you have a choice. You can either (a) remove the unnecessary information from the database, (b) restore a backup, or (c) wait on an update from Plex to fix the problem.
Cleaning the db may take minutes or hours, depending on CPU & hard drive/ssd speed. If you fall back, any play history, etc. since the backup date will be lost. Plex is working on a fix, where PMS will remove the unnecessary info, but it is unknown when it will be available.
Clean the db
To clean the database, you’ll need to use Plex SQLite to edit the database. See this post: Library.db size more than doubled in latest version - #186 by FordGuy61. The full thread has additional details on the problem and possible resolutions.
Restore from backup
To restore from a backup:
- Stop Plex Media Server
- Rename
com.plexapp.plugins.library.dbandcom.plexapp.plugins.library.blobs.dbtocom.plexapp.plugins.library.db.bakandcom.plexapp.plugins.library.blobs.db.bak. - Pick the backup you wish to use, and remove the date from the db and blobs.db files so they end in .db.
- Start Plex Media Server
- Scan your libraries to pick up changes since the backup date.
Once you are comfortable that the server is stable, you can then remove old backups, etc. if desired.
