Sam,
You might want to take a look at whatever else is going on.
Mar 06, 2019 18:27:02.546 [0x7f6eb62f5700] DEBUG - Completed: [192.168.20.64:46738] 200 GET /photo/:/transcode/?height=215&minSize=0&url=http%3A%2F%2F127.0.0.1%3A32400%2Flibrary%2Fmedia%2F92375%2FchapterImages%2F13&width=215 (65 live) TLS GZIP 16ms 2541 bytes (pipelined: 16)
Mar 06, 2019 18:27:02.552 [0x7f6e067fc700] WARN - SLOW QUERY: It took 2500.000000 ms to retrieve 22 items.
Mar 06, 2019 18:27:02.558 [0x7f6e067fc700] DEBUG - It took 30.000000 ms to retrieve 108 items.
Slow DB happens from time to time. It’s been that way for at least a year. I have to manually optimize to get it to go away for a while and then a few months later it comes back. Thanks for pointing it out and having sa2000 take a look.
Edit… also that is when it crashed so it maybe related. If you look at the trace back at the end it refers to the DB being busy
Edit2… By related I mean the crash caused the slow DB to happen.
I had another crash. To add to my previous statement I ran 1.14.1.5488-cc260c476 for well over 60 days straight with over 13500 sessions with no issues/crashes.
Crash Report:
Mar 07, 2019 11:17:38.300 [0x7f34457fa700] DEBUG - Job running: '/usr/lib/plexmediaserver/CrashUploader' '--directory=/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Crash Reports/1.15.1.710-ece95b3a1' '--version=1.15.1.710-ece95b3a1' '--platform=Linux' '--platformVersion=7 (Core)' '--serverUuid=1a4bbb9f4c29a0125c69c390d74c8fe1ce7277b1' '--userId=REMOVED' '--sentryUrl=https://sentry.io/api/1233455/minidump' '--sentryKey=a3e2688bd169450d821535e4c3a607bf' '--vendor=CentOS Linux' '--model=x86_64' '--device=PC'
Mar 07, 2019 11:17:38.336 [0x7f346a042700] DEBUG - Jobs: '/usr/lib/plexmediaserver/CrashUploader' exit code for process 25195 is 0 (success)