Plex crashing on 1.23.2.4584

squashua83 · May 26, 2021, 6:51pm

Server Version#:1.23.2.4584-bdefd2026
Player Version#: N/A

I tried the steps here but didn’t help: Repair a Corrupt Database | Plex Support
Here is the output from that:

C:\Program Files (x86)\Plex\Plex Media Server>copy "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\ORIG4"
        1 file(s) copied.

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "DROP index 'index_title_sort_naturalsort'"

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "DELETE from schema_migrations where version='20180501000000'"

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" .dump > dumptest.sql

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" .dump > "J:\PLEX\Plex Media Server\Plug-in Support\Databases\dumptest.sql"

C:\Program Files (x86)\Plex\Plex Media Server>del "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db"

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" < "J:\PLEX\Plex Media Server\Plug-in Support\Databases\dumptest.sql"

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "PRAGMA integrity_check"
ok

C:\Program Files (x86)\Plex\Plex Media Server>

Here are some error logs I found. I cannot change the verbosity since the plex server crashes before I can change any settings.

Line 1003: May 26, 2021 11:22:49.983 [5840] ERROR - SafelyWriteFile: rename for '"J:\PLEX\Plex Media Server\Preferences.xml.tmp.2f9019c5-02e3-42b8-aaf0-080102740e5a"' failed: Access is denied
Line 2448: May 26, 2021 11:24:10.077 [11260] ERROR - SQLITE3:0xccb12849, 28, double-quoted string literal: "2021-05-30 05:00:00"
Line 2350: May 26, 2021 11:24:09.958 [11260] ERROR - PlexClient::downloadContainer: expected MediaContainer element, found html
Line 1108: May 26, 2021 11:24:02.621 [7680] ERROR - LPE: unknown item 59074.
Line 1109: May 26, 2021 11:24:02.621 [7680] ERROR - Sync: failed to generate query for path library://d78b3cc9-8d1d-485e-ad44-d84af8188fec/item/%2Flibrary%2Fmetadata%2F59074 in sync item 47380893
Line 1110: May 26, 2021 11:24:02.621 [7680] ERROR - Sync: empty sync set, unable to update status for sync list 49724214, sync item 47380893
Line 1116: May 26, 2021 11:24:02.622 [7680] ERROR - LPE: unknown item 59074.
Line 1117: May 26, 2021 11:24:02.622 [7680] ERROR - Sync: failed to generate query for path library://d78b3cc9-8d1d-485e-ad44-d84af8188fec/item/%2Flibrary%2Fmetadata%2F59074 in sync item 47380898
Line 1118: May 26, 2021 11:24:02.622 [7680] ERROR - Sync: empty sync set, unable to update status for sync list 49724214, sync item 47380898

Zer0Squared · May 26, 2021, 7:30pm

This isn’t going to help you but I’m just curious if you’re able to Optimize Database successfully? I cannot. It crashes my whole server and I’ve been trying these same steps for the past week trying to get my DB back to fast/working order.

squashua83 · May 26, 2021, 7:34pm

I cannot even keep the plex server application running long enough to try.

Zer0Squared · May 26, 2021, 7:34pm

Roger that.

squashua83 · May 26, 2021, 7:43pm

I found this Database Repair Error: no such collation sequence: icu_root which states you cannot use the normal sqlite3 which goes against the instructions in their own article I posted above. So I went through those processes using that information but it did not seem to help – STILL CRASHING. Although it did remove the errors I got with the sqlite3.exe I tried originially. Here is that output.

C:\Program Files (x86)\Plex\Plex Media Server>copy "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\ORIG4"
        1 file(s) copied.

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "DROP index 'index_title_sort_naturalsort'"

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "DELETE from schema_migrations where version='20180501000000'"

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" .dump > dumptest.sql

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" .dump > "J:\PLEX\Plex Media Server\Plug-in Support\Databases\dumptest.sql"

C:\Program Files (x86)\Plex\Plex Media Server>del "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db"

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" < "J:\PLEX\Plex Media Server\Plug-in Support\Databases\dumptest.sql"

C:\Program Files (x86)\Plex\Plex Media Server>"Plex SQLite.exe" "J:\PLEX\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "PRAGMA integrity_check"
ok

C:\Program Files (x86)\Plex\Plex Media Server>

squashua83 · May 26, 2021, 8:07pm

I have just tried restoring from a database backup from 5/21/2021 using these instructions Restore a Database Backed Up via 'Scheduled Tasks' | Plex Support

again no luck there. I am thinking my issue is not db-related?

Line 857: May 26, 2021 13:04:16.219 [3408] DEBUG - [JobRunner] Job running: "C:\Program Files (x86)\Plex\Plex Media Server\CrashUploader.exe" "--directory=J:\PLEX\Plex Media Server\Crash Reports\1.23.2.4584-bdefd2026" --version=1.23.2.4584-bdefd2026 --platform=Windows "--platformVersion=10.0 (Build 19042)" --serverUuid=6ed4ecea67009df1c31fc51cce3fd9df37a6ca23 --userId=JoshuaMyers6283@gmail.com --sentryUrl=https://sentry.io/api/1233455/minidump --sentryKey=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx --vendor=Microsoft --model=x64 --device=PC --allowRetries=0 
	Line 857: May 26, 2021 13:04:16.219 [3408] DEBUG - [JobRunner] Job running: "C:\Program Files (x86)\Plex\Plex Media Server\CrashUploader.exe" "--directory=J:\PLEX\Plex Media Server\Crash Reports\1.23.2.4584-bdefd2026" --version=1.23.2.4584-bdefd2026 --platform=Windows "--platformVersion=10.0 (Build 19042)" --serverUuid=6ed4ecea67009df1c31fc51cce3fd9df37a6ca23 --userId=JoshuaMyers6283@gmail.com --sentryUrl=https://sentry.io/api/1233455/minidump --sentryKey=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx --vendor=Microsoft --model=x64 --device=PC --allowRetries=0 
	Line 922: May 26, 2021 13:04:16.266 [0180] DEBUG - Jobs: 'C:\Program Files (x86)\Plex\Plex Media Server\CrashUploader.exe' exit code for process 9760 is 0 (success)
	Line 2051: May 26, 2021 13:04:17.082 [1484] DEBUG - Creating XML preference for 'sendCrashReports'.
	Line 4717: May 26, 2021 13:04:27.498 [2632] DEBUG - [JobRunner] Job running: "C:\Program Files (x86)\Plex\Plex Media Server\CrashUploader.exe" "--directory=J:\PLEX\Plex Media Server\Crash Reports\1.23.2.4584-bdefd2026" --version=1.23.2.4584-bdefd2026 --platform=Windows "--platformVersion=10.0 (Build 19042)" --serverUuid=6ed4ecea67009df1c31fc51cce3fd9df37a6ca23 --userId=JoshuaMyers6283@gmail.com --sentryUrl=https://sentry.io/api/1233455/minidump --sentryKey=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx --vendor=Microsoft --model=x64 --device=PC --allowRetries=0 
	Line 4717: May 26, 2021 13:04:27.498 [2632] DEBUG - [JobRunner] Job running: "C:\Program Files (x86)\Plex\Plex Media Server\CrashUploader.exe" "--directory=J:\PLEX\Plex Media Server\Crash Reports\1.23.2.4584-bdefd2026" --version=1.23.2.4584-bdefd2026 --platform=Windows "--platformVersion=10.0 (Build 19042)" --serverUuid=6ed4ecea67009df1c31fc51cce3fd9df37a6ca23 --userId=JoshuaMyers6283@gmail.com --sentryUrl=https://sentry.io/api/1233455/minidump --sentryKey=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx --vendor=Microsoft --model=x64 --device=PC --allowRetries=0

squashua83 · May 26, 2021, 8:14pm

Rolling back to “PlexMediaServer-1.23.1.4571-6119e8eed-x86” seems to have fixed my issue.

Moved off BETA update channel as 1.23.2.4584 caused me problems today.

system · August 24, 2021, 8:15pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Com.plexapp.plugins.library.db SQL corruption Plex Media Server server-mac	4	168	March 22, 2021
"There was an unexpected error loading this library" when accessing all movies- server bug? Plex Pass Betas	26	1260	January 8, 2020
Plex crashes two Tuesdays in a row General Discussions	1	88	January 7, 2020
Plex Server DB errors Constant Crashing Plex Media Server server-linux , server-docker	16	188	April 15, 2023
Database Corruption Desktops & Laptops server-linux	31	4462	January 8, 2020

Plex crashing on 1.23.2.4584

Related topics