I added a large amount of content the other night. Today I realized that it only added 90% of it. Since then I’ve had issues adding any content. I tried restoring a DB from a few days ago, and now I’m missing all of the content I’ve added since that DB was backed up.
I am seeing SQlite errors in the logs:
Jun 06, 2020 11:58:30.090 [0x7f5b6e81d700] INFO - Plex Media Scanner v1.19.4.2902-69560ce1e - unknown PC unknown - build: linux-x86_64 - GMT -07:00
Jun 06, 2020 11:58:30.090 [0x7f5b6e81d700] INFO - Linux version: 4.18.20-unRAID (#1 SMP Fri Nov 23 11:38:16 PST 2018), language: en-GB
Jun 06, 2020 11:58:30.090 [0x7f5b6e81d700] INFO - Processor Intel® Xeon® CPU X3470 @ 2.93GHz
Jun 06, 2020 11:58:30.091 [0x7f5b6e81d700] INFO - /usr/lib/plexmediaserver/Plex Media Scanner --scan --refresh --section 1 --activity 3890cb41-e60a-4daf-b601-a7f9b97f22cb --directory /media/MOVIES/Meet the Fockers (2004)
Jun 06, 2020 11:58:30.089 [0x7f5b6f308300] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.26.0, threadsafe=1
Jun 06, 2020 11:58:30.231 [0x7f5b6f308300] DEBUG - It took 10.000000 ms to retrieve 960 items.
Jun 06, 2020 11:58:30.300 [0x7f5b6f308300] DEBUG - HTTP requesting PUT http://127.0.0.1:32400/activities/?percentComplete=0
Jun 06, 2020 11:58:30.300 [0x7f5b6723b700] DEBUG - HTTP requesting GET http://127.0.0.1:32400/:/metadata/notify/cullTimeline?librarySectionID=1&sinceTime=1591468710
Jun 06, 2020 11:58:30.301 [0x7f5b6723b700] DEBUG - HTTP 200 response from GET http://127.0.0.1:32400/:/metadata/notify/cullTimeline?librarySectionID=1&sinceTime=1591468710
Jun 06, 2020 11:58:30.301 [0x7f5b6f308300] DEBUG - HTTP 200 response from PUT http://127.0.0.1:32400/activities/?percentComplete=0
Jun 06, 2020 11:58:30.301 [0x7f5b6f308300] DEBUG - Scanning Movies using en(Plex Movie Scanner) with 0 current media items and 1 section locations in the database…
Jun 06, 2020 11:58:30.380 [0x7f5b6f308300] DEBUG - Performing a scan with ‘Plex Movie Scanner’ (language: en virtual: 0).
Jun 06, 2020 11:58:30.380 [0x7f5b6f308300] DEBUG - * Scanning /media/MOVIES/Meet the Fockers (2004)
Jun 06, 2020 11:58:30.381 [0x7f5b6f308300] DEBUG - Scanner: Processing directory /media/MOVIES/Meet the Fockers (2004) (parent: yes)
Jun 06, 2020 11:58:30.389 [0x7f5b6f308300] DEBUG - Directory had 1 files, database had 0 files, can’t skip.
Jun 06, 2020 11:58:30.403 [0x7f5b6f308300] DEBUG - Looking for path match for [/media/MOVIES/Meet the Fockers (2004)/Meet.The.Fockers.2004.720p.HDDVD.x264-hV.mkv]
Jun 06, 2020 11:58:30.404 [0x7f5b6f308300] DEBUG - Skipping hash check, no size match for 4695414878 bytes.
Jun 06, 2020 11:58:30.404 [0x7f5b6f308300] DEBUG - No match for hash.
Jun 06, 2020 11:58:30.404 [0x7f5b6f308300] DEBUG - Downloading document http://127.0.0.1:32400/library/changestamp
Jun 06, 2020 11:58:30.404 [0x7f5b6f308300] DEBUG - HTTP requesting GET http://127.0.0.1:32400/library/changestamp
Jun 06, 2020 11:58:30.405 [0x7f5b6f308300] DEBUG - HTTP 200 response from GET http://127.0.0.1:32400/library/changestamp
Jun 06, 2020 11:58:30.408 [0x7f5b6f308300] ERROR - SQLITE3:(nil), 14, cannot open file at line 38389 of [bf8c1b2b7a]
Jun 06, 2020 11:58:30.408 [0x7f5b6f308300] ERROR - SQLITE3:(nil), 14, os_unix.c:38389: (2) open(/config/transcode/etilqs_84e5de205d1ea1fe) - No such file or directory
Jun 06, 2020 11:58:30.408 [0x7f5b6f308300] ERROR - SQLITE3:(nil), 14, statement aborts at 166: [insert into metadata_items (library_section_id,parent_id,metadata_type,guid,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,su
Jun 06, 2020 11:58:30.409 [0x7f5b6f308300] ERROR - Exception inside transaction (inside=1) (…/Library/MetadataItem.cpp:1071): sqlite3_statement_backend::loadOne: unable to open database file
Jun 06, 2020 11:58:30.409 [0x7f5b6f308300] ERROR - Exception inside transaction (inside=1) (…/Library/MetadataItem.cpp:3590): sqlite3_statement_backend::loadOne: unable to open database file
Jun 06, 2020 11:58:30.409 [0x7f5b6f308300] ERROR - Exception assimilating media item in Meet the Fockers (2004): sqlite3_statement_backend::loadOne: unable to open database file
Jun 06, 2020 11:58:30.409 [0x7f5b6f308300] DEBUG - HTTP requesting PUT http://127.0.0.1:32400/activities/?percentComplete=%2B0&subtitle=Meet%20the%20Fockers%20(2004)
Jun 06, 2020 11:58:30.410 [0x7f5b6f308300] DEBUG - HTTP 200 response from PUT http://127.0.0.1:32400/activities/?percentComplete=%2B0&subtitle=Meet%20the%20Fockers%20(2004)
Jun 06, 2020 11:58:30.411 [0x7f5b6f308300] DEBUG - HTTP requesting PUT http://127.0.0.1:32400/activities/?percentComplete=99.000000
Jun 06, 2020 11:58:30.412 [0x7f5b6f308300] DEBUG - HTTP 200 response from PUT http://127.0.0.1:32400/activities/?percentComplete=99.000000
Jun 06, 2020 11:58:30.412 [0x7f5b6f308300] DEBUG - Removing 0 media items that were left.
Jun 06, 2020 11:58:30.412 [0x7f5b6f308300] DEBUG - Removing 0 directories that were left.
Jun 06, 2020 11:58:30.422 [0x7f5b6f308300] DEBUG - HTTP requesting PUT http://127.0.0.1:32400/activities/?percentComplete=100
Jun 06, 2020 11:58:30.423 [0x7f5b6f308300] DEBUG - HTTP 200 response from PUT http://127.0.0.1:32400/activities/?percentComplete=100
Jun 06, 2020 11:58:30.423 [0x7f5b6f308300] DEBUG - Refreshing section 1 of type: 1
Jun 06, 2020 11:58:30.455 [0x7f5b64c95700] DEBUG - Refreshing 0 IDs.
Server Version#: Version 4.35.1
Player Version#:
