I’m doing long overdue maintenance on my Plex , and I’ve fixed a number of issues with Transcoder and warnings and errors thanks to help from these forums.
The database errors are bothering me the most.
- I’ve done the optimize/restart/rescan procedure
- I cleaned bundles for good measure.
But I’m still getting the errors in the “Plex Media Server.log” below, among others. My log file is attached.
I’d love to get some additional ideas on possible ways to fix the issue! I did see mention of exporting / importing the sqlite db in another thread, but it didn’t contain instructions.
Nov 17, 2019 14:19:00.452 [0x7f7c1e0e1700] WARN - HTTP error requesting GET https://73-243-245-57.ac0d1388aa654f5ca7bc655a748e677b.plex.direct:15077/identity (0, No error) (Failed to connect to 73-243-245-57.ac0d1388aa654f5ca7bc655a748e677b.plex.direct port 15077: Connection refused)
Nov 17, 2019 14:19:15.995 [0x7f7be2e6b700] WARN - SLOW QUERY: It took 220.000000 ms to retrieve 50 items.
Nov 17, 2019 15:32:59.264 [0x7f91c4f52700] INFO - SQLITE3:(nil), 17, statement aborts at 57: [select * from metadata_items limit 1] database schema has changed
Nov 17, 2019 15:34:17.466 [0x7f923aacd700] WARN - Held transaction for too long (../Library/MetadataCollection.cpp:237): 0.110000 seconds
Nov 17, 2019 15:50:29.891 [0x7f91c552e700] WARN - QueryParser: Invalid field 'libraryHubsOnly' found, ignoring.
Server Version#: Version 1.18.2.2029
Player Version#: N/A
Database Size: 16.9MB ( downloaded file size ).
Running on
Synology DS918+ , Intel Celeron J3455 Processor
HW transcoding enabled
16GB RAM