Malformed database entry?

[Lucidic15]

After running the windows version to copy a user, when I start plex in unraid, I am getting the following log. I have gone back to a backup for now.

Attached is the Crash Report that the log mentions

A note to make, if it matters. I did copy the db file to my desktop, from unraid, run the script on it, the paste it back to unraid location.

2025-08-26 02:01:55,820 DEBG 'plexmediaserver' stdout output:
Generated new chapter thumbnails for Episode 26.

2025-08-26 02:01:56,193 DEBG 'plexmediaserver' stdout output:
Generated new chapter thumbnails for Unseen Bits #2.

2025-08-26 04:45:47,141 WARN received SIGTERM indicating exit request
2025-08-26 04:45:47,141 DEBG killing plexmediaserver (pid 76) with signal SIGTERM
2025-08-26 04:45:47,141 INFO waiting for plexmediaserver to die
2025-08-26 04:45:48,148 DEBG fd 9 closed, stopped monitoring <POutputDispatcher at 23141250603664 for <Subprocess at 23141251965888 with name plexmediaserver in state STOPPING> (stdout)>
2025-08-26 04:45:48,148 DEBG fd 11 closed, stopped monitoring <POutputDispatcher at 23141250243536 for <Subprocess at 23141251965888 with name plexmediaserver in state STOPPING> (stderr)>
2025-08-26 04:45:48,148 WARN stopped: plexmediaserver (exit status 143)
2025-08-26 04:45:48,148 DEBG received SIGCHLD indicating a child quit
Created by...
___.   .__       .__
\_ |__ |__| ____ |  |__   ____ ___  ___
 | __ \|  |/    \|  |  \_/ __ \\  \/  /
 | \_\ \  |   |  \   Y  \  ___/ >    <
 |___  /__|___|  /___|  /\___  >__/\_ \
     \/        \/     \/     \/      \/
   https://hub.docker.com/u/binhex/

2025-08-26 04:47:10.662477 [info] Host is running unRAID
2025-08-26 04:47:10.674917 [info] System information: Linux LucidRaid 6.1.118-Unraid #1 SMP PREEMPT_DYNAMIC Thu Nov 21 15:54:38 PST 2024 x86_64 GNU/Linux
2025-08-26 04:47:10.687592 [info] Image tags: BASE_RELEASE_TAG=2025060101,IMAGE_RELEASE_TAG=1.41.7.9823-1-05
2025-08-26 04:47:10.706831 [info] PUID defined as '99'
2025-08-26 04:47:10.728064 [info] PGID defined as '100'
2025-08-26 04:47:10.942016 [info] UMASK defined as '000'
2025-08-26 04:47:10.955836 [info] Permissions already set for '/config'
2025-08-26 04:47:10.981770 [info] Deleting files in /tmp (non recursive)...
2025-08-26 04:47:11.001195 [info] TRANS_DIR defined as '/config/transcode'
2025-08-26 04:47:11.020893 [info] SHARED_NETWORK not defined (via -e SHARED_NETWORK), defaulting to 'no'
2025-08-26 04:47:11.034812 [info] Starting Supervisor...
2025-08-26 04:47:12,326 INFO Included extra file "/etc/supervisor/conf.d/plexmediaserver.conf" during parsing
2025-08-26 04:47:12,326 INFO Set uid to user 0 succeeded
2025-08-26 04:47:12,349 INFO RPC interface 'supervisor' initialized
2025-08-26 04:47:12,349 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2025-08-26 04:47:12,349 INFO supervisord started with pid 19
2025-08-26 04:47:13,351 INFO spawned: 'plexmediaserver' with pid 76
2025-08-26 04:47:13,351 INFO reaped unknown pid 20 (exit status 0)
2025-08-26 04:47:13,388 DEBG 'plexmediaserver' stderr output:
Plex Media Server is already running. Will not start...

2025-08-26 04:47:13,390 DEBG fd 9 closed, stopped monitoring <POutputDispatcher at 22379497953936 for <Subprocess at 22379499381696 with name plexmediaserver in state STARTING> (stdout)>
2025-08-26 04:47:13,390 DEBG fd 11 closed, stopped monitoring <POutputDispatcher at 22379497593808 for <Subprocess at 22379499381696 with name plexmediaserver in state STARTING> (stderr)>
2025-08-26 04:47:13,390 WARN exited: plexmediaserver (exit status 1; not expected)
2025-08-26 04:47:13,390 DEBG received SIGCHLD indicating a child quit
2025-08-26 04:47:14,391 INFO spawned: 'plexmediaserver' with pid 82
2025-08-26 04:47:14,428 DEBG 'plexmediaserver' stderr output:
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2048

2025-08-26 04:47:14,465 DEBG 'plexmediaserver' stderr output:
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Plex Media Server/Crash Reports/1.41.7.9823-59f304c16/PLEX MEDIA SERVER/c2c39910-d1db-4124-763d0d93-86642fc8.dmp

2025-08-26 04:47:14,467 DEBG 'plexmediaserver' stderr output:
/home/nobody/start.sh: line 33:    85 Aborted                 "${PLEX_MEDIA_SERVER_HOME}/Plex Media Server"

2025-08-26 04:47:14,760 DEBG fd 9 closed, stopped monitoring <POutputDispatcher at 22379497593808 for <Subprocess at 22379499381696 with name plexmediaserver in state STARTING> (stdout)>
2025-08-26 04:47:14,760 DEBG fd 11 closed, stopped monitoring <POutputDispatcher at 22379497466640 for <Subprocess at 22379499381696 with name plexmediaserver in state STARTING> (stderr)>
2025-08-26 04:47:14,760 WARN exited: plexmediaserver (exit status 134; not expected)
2025-08-26 04:47:14,760 DEBG received SIGCHLD indicating a child quit
2025-08-26 04:47:16,762 INFO spawned: 'plexmediaserver' with pid 96
2025-08-26 04:47:16,780 DEBG 'plexmediaserver' stderr output:
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2048

2025-08-26 04:47:16,794 DEBG 'plexmediaserver' stderr output:
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Plex Media Server/Crash Reports/1.41.7.9823-59f304c16/PLEX MEDIA SERVER/535b35e2-84f0-4353-dcb569a8-b13bd18e.dmp

2025-08-26 04:47:16,795 DEBG 'plexmediaserver' stderr output:
/home/nobody/start.sh: line 33:    99 Aborted                 "${PLEX_MEDIA_SERVER_HOME}/Plex Media Server"

2025-08-26 04:47:17,052 DEBG fd 9 closed, stopped monitoring <POutputDispatcher at 22379497466640 for <Subprocess at 22379499381696 with name plexmediaserver in state STARTING> (stdout)>
2025-08-26 04:47:17,052 DEBG fd 11 closed, stopped monitoring <POutputDispatcher at 22379498047248 for <Subprocess at 22379499381696 with name plexmediaserver in state STARTING> (stderr)>
2025-08-26 04:47:17,052 WARN exited: plexmediaserver (exit status 134; not expected)
2025-08-26 04:47:17,052 DEBG received SIGCHLD indicating a child quit
2025-08-26 04:47:20,057 INFO spawned: 'plexmediaserver' with pid 110
2025-08-26 04:47:20,075 DEBG 'plexmediaserver' stderr output:
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2048

2025-08-26 04:47:20,088 DEBG 'plexmediaserver' stderr output:
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Plex Media Server/Crash Reports/1.41.7.9823-59f304c16/PLEX MEDIA SERVER/1250d034-4540-4ccc-6d191fb1-524e0bfc.dmp

2025-08-26 04:47:20,090 DEBG 'plexmediaserver' stderr output:
/home/nobody/start.sh: line 33:   113 Aborted                 "${PLEX_MEDIA_SERVER_HOME}/Plex Media Server"

2025-08-26 04:47:20,090 DEBG fd 9 closed, stopped monitoring <POutputDispatcher at 22379497837696 for <Subprocess at 22379499381696 with name plexmediaserver in state STARTING> (stdout)>
2025-08-26 04:47:20,090 DEBG fd 11 closed, stopped monitoring <POutputDispatcher at 22379497840144 for <Subprocess at 22379499381696 with name plexmediaserver in state STARTING> (stderr)>
2025-08-26 04:47:20,090 WARN exited: plexmediaserver (exit status 134; not expected)
2025-08-26 04:47:20,090 DEBG received SIGCHLD indicating a child quit
2025-08-26 04:47:20,090 INFO gave up: plexmediaserver entered FATAL state, too many start retries too quickly

.RateLimit.json

[cetteup]

Was the server running when you copied the db file back? And does the mentioned crash report contain any additional details?

I really want to get way from directly making changes to the database, but I need to find the time to make the required changes.

[Lucidic15]

I probably copied it to my desktop while it was running, but shut down and placed it back when it was off.

I actually took your secret and re-wrote it in C# and it worked fine, so maybe it was a fluke on my end when using your version.