Great, the script completed this time. Thanks! Let me look at my libraries and re-scan them.
My apologies for being all bumble-fingered
Any help is appreciated. Don’t sweat it.
I have unfortunate findings to report. I think my PMS crashes when scanning my TV library.
Here’s what I did:
docker compose down plex
docker compose run -it plex bash
(for the DBRepair steps)docker compose up -d plex
docker compose logs -f plex
- Visit localhost:32400
- Scan Movies (everything seems fine, 5 movies show, yay)
- Scan TV (lots of spinners and 4 shows appear, unfortunately, I should have 6 shows)
- See logs, see crash.
- Grep errors in crash report.
juanca@PLAYAPRO servarr % cat plex/Library/Application\ Support/Plex\ Media\ Server/Crash\ Reports/1.32.7.7621-871adbd44/PLEX\ MEDIA\ SERVER/2219268c-dba7-4768-61e0e895-21c6f341.dmp.log | grep ERROR
Nov 26, 2023 00:50:30.336 [139804539931448] ERROR - [Req#7e] Unknown metadata type: folder
Nov 26, 2023 00:50:30.339 [139804563921720] ERROR - [Req#67] Unknown metadata type: folder
Nov 26, 2023 00:50:32.520 [139804581792568] ERROR - [Req#9d] Unknown metadata type: folder
Nov 26, 2023 00:50:32.528 [139804530170680] ERROR - [Req#9e] Unknown metadata type: folder
Nov 26, 2023 00:50:34.003 [139804539931448] ERROR - [Req#a1] Unknown metadata type: folder
Nov 26, 2023 00:50:34.011 [139804563921720] ERROR - [Req#6f] Unknown metadata type: folder
Nov 26, 2023 00:50:44.225 [139804581792568] ERROR - Unknown metadata type:
Nov 26, 2023 00:50:49.306 [139804544936760] ERROR - [Req#147] Unknown metadata type: folder
Nov 26, 2023 00:50:49.316 [139804542827320] ERROR - [Req#14b] Unknown metadata type: folder
Nov 26, 2023 00:50:51.763 [139804523273016] ERROR - SQLITE3:0x80000001, 26, statement aborts at 53: [select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', metadata_items.audience_rating as 'metadata_items_audience_rating
Nov 26, 2023 00:50:51.763 [139804523273016] ERROR - Thread: Uncaught exception running async task which was spawned by thread 139804507540280: sqlite3_statement_backend::loadOne: file is not a database
Nov 26, 2023 00:50:51.765 [139804523273016] ERROR - SQLITE3:0x80000001, 26, statement aborts at 53: [select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', metadata_items.audience_rating as 'metadata_items_audience_rating
Nov 26, 2023 00:50:51.766 [139804523273016] ERROR - Thread: Uncaught exception running async task which was spawned by thread 139804507540280: sqlite3_statement_backend::loadOne: file is not a database
Nov 26, 2023 00:50:51.831 [139804523273016] ERROR - SQLITE3:0x80000001, 26, statement aborts at 53: [select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', metadata_items.audience_rating as 'metadata_items_audience_rating
Nov 26, 2023 00:50:51.831 [139804523273016] ERROR - Thread: Uncaught exception running async task which was spawned by thread 139804507540280: sqlite3_statement_backend::loadOne: file is not a database
Nov 26, 2023 00:50:51.834 [139804523273016] ERROR - SQLITE3:0x80000001, 26, statement aborts at 53: [select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', metadata_items.audience_rating as 'metadata_items_audience_rating
Nov 26, 2023 00:50:51.834 [139804523273016] ERROR - Thread: Uncaught exception running async task which was spawned by thread 139804507540280: sqlite3_statement_backend::loadOne: file is not a database
Nov 26, 2023 00:50:52.581 [139804505430840] ERROR - [Req#199] SQLITE3:0x80000001, 11, database corruption at line 72267 of [a29f994989]
Nov 26, 2023 00:50:52.581 [139804505430840] ERROR - [Req#199] SQLITE3:0x80000001, 11, statement aborts at 4: [DELETE FROM 'main'.'fts4_metadata_titles_icu_docsize' WHERE docid = ?] database disk image is malformed
Nov 26, 2023 00:50:52.581 [139804505430840] ERROR - [Req#199] SQLITE3:0x80000001, 11, statement aborts at 10: [update metadata_items set refreshed_at=? where id=?] database disk image is malformed
Nov 26, 2023 00:50:52.792 [139804505430840] ERROR - Got exception from request handler: sqlite3_statement_backend::loadOne: database disk image is malformed
Nov 26, 2023 00:50:52.792 [139804505430840] ERROR - downloadContainer: expected MediaContainer element, found html
Nov 26, 2023 00:50:52.792 [139804505430840] ERROR - IntroDetector: Failed to get metadata for: /data/media/tv/Altered Carbon/Season 2/Altered Carbon - S02E01 - Phantom Lady WEBDL-1080p.mkv
Nov 26, 2023 00:50:53.394 [139804513868600] ERROR - [CreditsDetectionManager] SQLITE3:0x80000001, 11, database corruption at line 69165 of [a29f994989]
Nov 26, 2023 00:50:53.394 [139804513868600] ERROR - [CreditsDetectionManager] SQLITE3:0x80000001, 11, statement aborts at 61: [update media_parts set media_item_id=:media_parts_media_item_id,directory_id=:media_parts_directory_id,hash=:media_parts_hash,open_subtitle_hash=:media_parts_open_subtitle_hash,file=:media_parts_file,'index'=:media_parts_index,size=:media_parts_size,duration=:media_parts_duration,created_at=:media_parts_created_at,updated_at=:media_parts_updated_at,deleted_at=:media_parts_deleted_at,extra_data=:media_parts_extra_data where id=:media_parts_id] database disk image is malformed
Nov 26, 2023 00:50:53.396 [139804513868600] ERROR - [CreditsDetectionManager] Exception inside transaction (inside=1) (/data/jenkins/server/3535737052/Library/Scanner/CreditsDetector/CreditsDetectorManager.cpp:278): sqlite3_statement_backend::loadOne: database disk image is malformed
Nov 26, 2023 00:50:53.408 [139804513868600] ERROR - Thread: Uncaught exception running async task which was spawned by thread 139804501211960: sqlite3_statement_backend::loadOne: database disk image is malformed
why are you using docker compose
? No no …
-
You can create the container with compose but not manage it
-
docker start plex / docker stop plex
-
docker exec -it plex bash (the repair)
I will need your DB and logs ZIP file for the engineer.
I’ll open a PM to you for them.
I use a docker-compose.yml
file to easily manage the volume and network settings. AFAIK, it should be the same, just easier.
Sounds good, I’ll continue in our PMs
Here’s my dockerplex
script.
Very basic but gets the job done via docker run
.
I have several of these for the different images I need create.
I tweak/edit them as needed before creating the container.
[chuck@lizum docker.1990]$ cat dockerplex
sudo docker stop plex
sudo docker rm plex
# Remove old image if exists
Image="$(sudo docker images | grep -i plex | awk '{print $3}')"
if [ "$Image" != "" ]; then
sudo docker stop plex
sudo docker stop plex
sudo docker rm plex
sudo docker rmi -f $Image
fi
sudo docker run \
-d \
--name plex \
--network=host \
-e PLEX_CLAIM="claim-J3YbuBpaBhE9oJS1jsma" \
-e TZ="EST" \
-e LANG="en_US.UTF-8" \
-e PLEX_UID=1000 \
-e PLEX_GID=1000 \
-e PUID=1000 \
-e PGID=1000 \
-h dockerplex \
-v /sata/dockerplex:/config \
-v /sata/dockerplex/tmp:/tmp \
-v /sata/dockerplex/transcode:/transcode \
-v /vie:/data \
-v /glock:/glock \
--device=/dev/dri:/dev/dri \
plexinc/pms-docker:plexpass
#docker start plex
#docker update --restart=unless-stopped plex
[chuck@lizum docker.1991]$
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.