Why am I getting errors adding, deleting items in the library?

General Discussions
1

Hello,

I already posted in the general area but I not getting any responses/help.

I’m suddenly running into all kinds of issues. I can’t delete certain items, can’t delete trash in some libraries, can’t play some items, some libraries don’t add new items. Attached are the logs.
I already tried some techniques to “repair” the library with no success. I also tried adding new library but the server is not even scanning any new items anymore. The library stays empty even though I’ve selected folders with dozens of shows.
I’ve been using Plex since the early days and never had an issue like this. I don’t want to delete everything and restart.
Any help would really be appreciated!

Attached are the logs.

3

Thanks Andy!

That solved my problems. I actually had a system backup from three weeks ago and I followed your instructions restoring a database backup. All working now again. :slight_smile:

4

You should still try and perform the database repairing procedure on that backup.
It is quite possible, that the database corruption is already growing inside this as well.
Make sure to stop Plex Server completely before attempting the repair procedure.

https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database

updated instructions for newer SQLite3 versions:

OSX
---

sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db "PRAGMA integrity_check"

sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db .dump > dump.sql

mv ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db.original

sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db < dump.sql
5

@OttoKerner said:
You should still try and perform the database repairing procedure on that backup.

I did that yesterday after I encountered another issue playing a show. Everything is running fine now. Thanks for your tip!