I updated Plex Server yest (Debian) and since then I have trouble authenticating through a browser. The Plex App works just fine, and I can log in using the web but I get no soup… BUT! I can watch what was showing yesterday!!! Perplexed…!
[plex_mo|637x500](upload:
//w04CAq6HrYQfWdvxW9GNhGskZ0B.jpeg)try app.plex.tv instead.
To add to Otto’s post,
Should you not regain access through that means, may I have manually collected Log files please?
Here you go! Thanks for the speedy reply.
Re: OttoKerner (not THAT Otto Kerner???) Yes- that works! Where linking via IP (or DNS) still rejects…
Logs attached.Logs.tar.gz (1.0 MB)
Then keep using it until the Plex Web version that is available there has been put into a server update.
Can do.
what else is running on this computer? Is it a VM? If a VM, it needs more resources (vCPU) and/or the database optimized.
Mar 16, 2019 23:38:57.916 [0x7f4a073fc700] ERROR - QueryParser: Invalid field 'onlyTransient' found, ignoring.
Mar 16, 2019 23:45:54.759 [0x7f49fb3ff700] WARN - SLOW QUERY: It took 270.000000 ms to retrieve 45 items.
Mar 16, 2019 23:46:00.894 [0x7f4a083fe700] WARN - SLOW QUERY: It took 260.000000 ms to retrieve 45 items.
Mar 16, 2019 23:46:06.665 [0x7f49fd7ff700] WARN - SLOW QUERY: It took 260.000000 ms to retrieve 45 items.
Mar 16, 2019 23:46:11.026 [0x7f4a083fe700] WARN - SLOW QUERY: It took 250.000000 ms to retrieve 45 items.
Mar 16, 2019 23:46:15.193 [0x7f49fabfe700] WARN - SLOW QUERY: It took 240.000000 ms to retrieve 45 items.
Mar 16, 2019 23:46:44.072 [0x7f49fc3ff700] ERROR - Extras: Preroll file didn't exist or couldn't be read: ''.
Mar 16, 2019 23:51:17.862 [0x7f49fc3ff700] WARN - Unable to load episode file ["seasons/1/episodes/0.xml"]
Mar 16, 2019 23:52:06.949 [0x7f49ef3f9700] WARN - SLOW QUERY: It took 1320.000000 ms to retrieve 54 items.
Mar 16, 2019 23:52:07.806 [0x7f49ef3f9700] WARN - SLOW QUERY: It took 300.000000 ms to retrieve 1 items.
Mar 16, 2019 23:52:34.890 [0x7f49f0bfc700] WARN - SLOW QUERY: It took 250.000000 ms to retrieve 10 items.
Mar 16, 2019 23:52:35.069 [0x7f49f0bfc700] WARN - SLOW QUERY: It took 430.000000 ms to retrieve 77 items.
Mar 16, 2019 23:52:35.161 [0x7f49f0bfc700] WARN - SLOW QUERY: It took 380.000000 ms to retrieve 65 items.
Mar 16, 2019 23:52:35.386 [0x7f49f0bfc700] WARN - SLOW QUERY: It took 490.000000 ms to retrieve 98 items.
Mar 16, 2019 23:52:35.880 [0x7f4a08bff700] ERROR - Extras: Preroll file didn't exist or couldn't be read: ''.
Mar 17, 2019 01:18:19.198 [0x7f4a0bbfe700] ERROR - Error issuing curl_easy_perform(handle): 28
Mar 17, 2019 01:18:19.198 [0x7f4a0bbfe700] ERROR - SSDP: Error parsing device schema for http://192.168.1.166:24995/dd.xml
Mar 17, 2019 02:04:53.456 [0x7f4a12bff700] ERROR - Thread: Uncaught exception running async task which was spawned by thread 0x7f4a063ff700: sqlite3_statement_backend::loadOne: database is locked
Mar 17, 2019 11:18:14.487 [0x7f4a073fc700] WARN - Sync: local sync directory "/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Cache/Transcode/Sync+" does not exist
Mar 17, 2019 15:18:58.288 [0x7f4a167ff700] WARN - LongPoll: Got error, closing.
Mar 17, 2019 15:21:06.301 [0x7f4a167ff700] WARN - LongPoll: Got error, closing.
Mar 17, 2019 15:27:04.103 [0x7f4a12bff700] WARN - SLOW QUERY: It took 280.000000 ms to retrieve 1 items.
Mar 17, 2019 15:27:04.171 [0x7f4a08bff700] WARN - SLOW QUERY: It took 370.000000 ms to retrieve 1 items.
Mar 17, 2019 15:27:13.653 [0x7f49f8bfe700] WARN - SLOW QUERY: It took 220.000000 ms to retrieve 1 items.
Mar 17, 2019 18:25:30.018 [0x7f4a07bfd700] WARN - SLOW QUERY: It took 300.000000 ms to retrieve 51 items.
Mar 17, 2019 18:41:22.051 [0x7f49f8bfe700] WARN - SLOW QUERY: It took 300.000000 ms to retrieve 51 items.
Mar 17, 2019 18:53:29.753 [0x7f49efbfe700] WARN - SLOW QUERY: It took 300.000000 ms to retrieve 38 items.
Mar 17, 2019 19:15:00.952 [0x7f4a083fe700] WARN - SLOW QUERY: It took 460.000000 ms to retrieve 14
Its a dedicated Plex Sever, literally nothing else running on it (2x4 for 8 cores at 3ghz and 32gb of Ram). Will optimize it and report back… Thanks for the help.
While Optimizing:
top - 14:24:24 up 3 days, 15:07, 4 users, load average: 0.27, 0.06, 0.02
Tasks: 280 total, 1 running, 279 sleeping, 0 stopped, 0 zombie
%Cpu(s): 6.6 us, 4.3 sy, 0.0 ni, 87.1 id, 2.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 32951004 total, 792076 free, 1039408 used, 31119520 buff/cache
KiB Swap: 33551356 total, 33551356 free, 0 used. 31401584 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25911 plex 20 0 2560716 134652 36600 S 83.2 0.4 0:25.77 Plex Media Serv
26312 trent 20 0 45060 3888 3028 R 1.0 0.0 0:01.06 top
2474 trent 20 0 1144212 37600 29940 S 0.7 0.1 2:13.58 gnome-settings-
24187 root 20 0 311984 38428 7432 S 0.7 0.1 10:11.67 fail2ban-server
1 root 20 0 205064 7344 5216 S 0.0 0.0 0:14.84 systemd
2 root 20 0 0 0 0 S 0.0 0.0 0:00.28 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 3:14.34 ksoftirqd/0
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
7 root 20 0 0 0 0 S 0.0 0.0 1:46.61 rcu_sched
8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
Which Xeon? It is conveniently absent from the CPUID info.
Processor Intel(R) Xeon(TM) CPU 3.00GHz
Well, post optimization it works about a third of the time (either by IP or DNS) but app.plex.tv works every time? Here are fresh logs after the db optimization.
Logs.tar.gz (1023.8 KB)
Also:
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel® Xeon™ CPU 3.00GHz
stepping : 4
microcode : 0x2
cpu MHz : 2992.638
cache size : 2048 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 2
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 6
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc pebs bts nopl pni dtes64 monitor ds_cpl vmx est cid cx16 xtpr pdcm lahf_lm kaiser tpr_shadow
bugs : cpu_meltdown spectre_v1 spectre_v2 spec_store_bypass l1tf
bogomips : 5985.27
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
Optimization works fine.
If the database is bigger than the CPU can support, SLOW QUERY will be the result because the tables are too big and cannot be accessed quickly enough.
You have shown me the contents of /proc/cpuinfo. I wish to know which model (part number) xeon.
5000 bogo mips reported tells me it is most likely one of the original and now-ancient processors.
The only thing I can find in that performance range is this.
https://www.cpubenchmark.net/cpu.php?cpu=Intel+Xeon+3.00GHz&id=1318
Is this the CPU?
Hahah! Almost certainly 
It’s a Dell Poweredge Something, a old pizza box I picked up- two of them, actually.
And yes, the db is largo (I backed it yest at 92gb). Why would that translate into patchy authentication? It serves (multiple) streams just fine and doesn’t really seem to stress, numerically at least, on anything else.
And this is the only problem I’ve had (period!) since I’ve installed it. It’s a dream. Slick, sensible, user friendly, very sane.
Actually I have 4 cores per cpu:
root@mediaserver0:~# cat /proc/cpuinfo |egrep -c processor
8
On Dell PowerEdge 2950 that makes it (per the spec sheet)
Quad-Core Intel Xeon 5300 sequence processors at up to 3.0GHz;
If that helps at all?
Here’s the kicker. That link I found shows 391 Passmarks.
PLEASE tell me you have more?
390 Passmarks isn’t even enough to melt an ice cube 
NAS boxes have a 700 passmark minimum to be on the Compaibility guide.
Hahaha! I’ll pop the top tonite if I get a chance and find out
Xeon X5365 Socket J , so two of these:
https://www.cpubenchmark.net/cpu.php?cpu=Intel+Xeon+X5365+%40+3.00GHz&id=1295
Ok. so that does explain a great deal. The per-thread performance is 1/2 of the typical ARMv7 NAS. With a metadata library of 92 GB, the physical DB must be substantial.
Do you have an idea of how many files are actually indexed?
e.g find /media/dir1 /media/dir2 (list them all here) -type f -print | wc -l
It will print the total number of files Plex has in its db.
25,000 Music, TV, Movie (about half music?) plus 2000 family videos. They play (and display when scrolling) just fine. The only hiccup is server resolution. app.plex.tv works 100% of the time- though which is good enough for me
