Server Version#: 4.8.4
Player Version#: Web Client
This is the problem I’m getting. I have done “service plexmediaserver restart” multiple times, I get the images, and then it goes right back to this. Can you help?
Edit: I have restarted, updated, and more. I am loading in the web by IP address directly, not through app.plex.tv plex logs 20191025 1948.txt (90.1 KB)
Also, my daughter just told me she can get on her user profile on our plex server. However, my wife and I (the primary user profile) cannot.plexlogs.tar.gz (4.6 MB)
I found the problem. The database is damaged/corrupted.
Oct 25, 2019 13:44:41.293 [0x7f229b7fe700] DEBUG - It took 60.000000 ms to retrieve 50 items.
Oct 25, 2019 13:44:41.359 [0x7f229b7fe700] DEBUG - It took 130.000000 ms to retrieve 50 items.
Oct 25, 2019 13:44:41.392 [0x7f229b7fe700] ERROR - SQLITE3:(nil), 11, database corruption at line 65066 of [bf8c1b2b7a]
Oct 25, 2019 13:44:41.392 [0x7f229b7fe700] ERROR - SQLITE3:(nil), 11, statement aborts at 41: [select metadata_items.id as 'metadata_items_id', metadata_items.library_section_id as 'metadata_items_library_section_id', metadata_items.parent_id as 'metadata_items_parent_id', metad
Oct 25, 2019 13:44:41.401 [0x7f229b7fe700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Oct 25, 2019 13:44:41.405 [0x7f22b2cec700] DEBUG - Completed: [192.168.1.175:53728] 500 GET /library/recentlyAdded (13 live) TLS GZIP 821ms 405 bytes (pipelined: 1)
Oct 25, 2019 13:44:41.437 [0x7f2221ffb700] ERROR - SQLITE3:(nil), 11, database corruption at line 65066 of [bf8c1b2b7a]
Oct 25, 2019 13:44:41.437 [0x7f2221ffb700] ERROR - SQLITE3:(nil), 11, statement aborts at 96: [select grandparents.id,metadata_item_views.originally_available_at,metadata_item_views.parent_index,metadata_item_views.`index`,max(viewed_at),grandparents.library_section_id from meta
Oct 25, 2019 13:44:41.439 [0x7f2221ffb700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Oct 25, 2019 13:44:41.441 [0x7f22b2cec700] DEBUG - Completed: [192.168.1.175:53723] 500 GET /library/onDeck (13 live) TLS GZIP 967ms 405 bytes (pipelined: 2)
On Linux, the database is located /var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases
@ChuckPa I ran that and it somehow bricked my server. I’m glad it’s a VM, as I was able to quickly roll back. I genuinely don’t know what’s going on, now. Here’s what I have from my ssh session before the checkpoint restore.
root@plex2:~# service plexmediaserver status
● plexmediaserver.service - Plex Media Server
Loaded: loaded (/lib/systemd/system/plexmediaserver.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Sat 2019-10-26 13:47:33 EDT; 1min 44s ago
Process: 1352 ExecStart=/bin/sh -c PLEX_MEDIA_SERVER_INFO_VENDOR="(grep ^NAME= /etc/os-release | awk -F= "{print \$2}" | tr -d \" )" PLEX_MEDIA_SERVER_INFO_DEVICE="PC" PLEX_MEDIA_SERVER_INFO_MODEL="(uname -m)" PLEX_MEDIA_SERVER_I
Process: 1344 ExecStartPre=/bin/sh -c /usr/bin/test -d “{PLEX_MEDIA_SERVER_APPLICATION_SUPPORT_DIR}" || /bin/mkdir -p "{PLEX_MEDIA_SERVER_APPLICATION_SUPPORT_DIR}” (code=exited, status=0/SUCCESS)
Main PID: 1352 (code=exited, status=255)
Oct 26 13:47:33 plex2 systemd[1]: plexmediaserver.service: Service hold-off time over, scheduling restart.
Oct 26 13:47:33 plex2 systemd[1]: plexmediaserver.service: Scheduled restart job, restart counter is at 3.
Oct 26 13:47:33 plex2 systemd[1]: Stopped Plex Media Server.
Oct 26 13:47:33 plex2 systemd[1]: plexmediaserver.service: Start request repeated too quickly.
Oct 26 13:47:33 plex2 systemd[1]: plexmediaserver.service: Failed with result ‘exit-code’.
Oct 26 13:47:33 plex2 systemd[1]: Failed to start Plex Media Server.