No new items added to library will sync

Support
1

Issue description:

The last ‘new’ items showing up are the ones that were added ~3 months ago. I have added items since then, but when I hit ‘Sync’ they don’t show up. However, the app continues to work normally. I’m able to play the files, and able to cache files from the server for off-line play. It is just the syncing that seems to be broken.

Logs:

Upload description: gkzhukov

Additional information:

 

 

Reproduction steps:

 
I’ve tried syncing in the filter menu; in the settings; and by adding a second iteration of the same library. None of those options seem to have worked, unfortunately.
 

Media provider:

Plex

Screenshots:

     

2

Your log is empty.

I need log during a sync and with more details about what you see and what are the missing media.

3

Odd? I did a sync right before I uploaded it I thought. I just attempted two more syncs, and uploaded the logs immediately after, as gkzhukov1.

I see everything added up through Ruth Benedict - The Chrysanthemum and the Sword. The two files I just added which should be showing up are Lee Child’s Night School and The Secret.

4

Empty again, you need to enable logs, then sync then upload.

Else there’s nothing in them.

5

Sorry, I don’t see an ‘enable logs’? Is that debug mode? I toggled that and sent them again after another sync attempt. gkzhukov2

6

Yes as the help for getting debug logs explains.

Anyway

2024-09-16 09:30:37.768 Verbose/PlexLogger: <-- [431] <html><head><title>Internal Server Error</title></head><body><h1>500 Internal Server Error</h1></body></html>
2024-09-16 09:30:37.768 Verbose/PlexLogger: <-- [431] END HTTP (682ms, 109-byte body)
2024-09-16 09:30:37.769 Error/PlexLogger: Request Error: 500 [<html><head><title>Internal Server Error</title></head><body><h1>500 Internal Server Error</h1></body></html>]

The sync does not work as your server returns an error, you need to check Plex logs about why it fails and fix it. Often it’s a database bug and you can recover from plex admin optimize database.

7

Unfortunately Optimize database doesn’t seem to have fixed it… I’ll try the Plex support forum, but any other suggestions that you are aware of while I wait on that?

8

Since you do not give the error details from Plex logs I have no idea no sorry.

9

Yes, sorry, that would help, wouldn’t it… This bookends when I just hit sync, to when the logs seemed to pause adding new things.

Sep 19, 2024 10:30:22.425 [0x700005d7e000] Debug — [Req#1386a8] Setting container serialization range to [0, 999] (total=-1)
Sep 19, 2024 10:30:22.550 [0x700005d7e000] Debug — [Req#1386a8] It took 100.000000 ms to retrieve 1000 items.
Sep 19, 2024 10:30:22.624 [0x7000063a2000] Debug — Completed: [192.168.50.1:52202] 200 GET /library/sections/9/all?type=8 (9 live) #1386a8 TLS GZIP Page 0-999 200ms 33490 bytes (pipelined: 6)
Sep 19, 2024 10:30:22.854 [0x700005f8a000] Debug — Request: [192.168.50.1:52202 (Subnet)] GET /library/sections/9/all?type=8 (9 live) #1386b1 TLS Page 1000-1999 GZIP Signed-in Token (gkzhukov) (Google Pixel 6)
Sep 19, 2024 10:30:22.855 [0x700005f8a000] Debug — [Req#1386b1] Setting container serialization range to [1000, 1999] (total=-1)
Sep 19, 2024 10:30:22.871 [0x700005f8a000] Debug — [Req#1386b1] It took 10.000000 ms to retrieve 153 items.
Sep 19, 2024 10:30:22.884 [0x70000631f000] Debug — Completed: [192.168.50.1:52202] 200 GET /library/sections/9/all?type=8 (9 live) #1386b1 TLS GZIP Page 1000-1999 29ms 6353 bytes (pipelined: 7)
Sep 19, 2024 10:30:22.913 [0x700006cd8000] Warning — NetworkServiceBrowser: Error sending out discover packet from 169.254.193.124 to 239.255.255.250: No buffer space available
Sep 19, 2024 10:30:22.917 [0x700005d7e000] Debug — Request: [192.168.50.1:52202 (Subnet)] GET /library/sections/9/all?type=9 (9 live) #1386ba TLS Page 0-999 GZIP Signed-in Token (gkzhukov) (Google Pixel 6)
Sep 19, 2024 10:30:22.918 [0x700005d7e000] Debug — [Req#1386ba] Setting container serialization range to [0, 999] (total=-1)
Sep 19, 2024 10:30:23.424 [0x700005d7e000] Error — [Req#1386ba] SQLITE3:(nil), 1, statement aborts at 3110: [select distinct 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', metadata_items.metadata_type as 'metadata_items_metadata_type', metadata_items.guid as 'metadata_items_guid', metadata_items.slug as 'metadata_items_slug', metadata_items.hash as 'metadata_items_hash', metadata_items.media_item_count as 'metadata_items_media_item_count', metadata_items.title as 'metadata_items_title', metadata_items.title_sort as 'metadata_items_title_sort', metadata_items.original_title as 'metadata_items_original_title', metadata_items.studio as 'metadata_items_studio', metadata_items.rating as 'metadata_items_rating', metadata
Sep 19, 2024 10:30:23.426 [0x700005d7e000] Error — Got exception from request handler: sqlite3_statement_backend::loadRS: SQL logic error
Sep 19, 2024 10:30:23.427 [0x7000063a2000] Debug — Completed: [192.168.50.1:52202] 500 GET /library/sections/9/all?type=9 (9 live) #1386ba TLS GZIP Page 0-999 509ms 405 bytes (pipelined: 8)
Sep 19, 2024 10:30:29.472 [0x700005f8a000] Debug — Request: [192.168.50.1:52202 (Subnet)] GET /identity (9 live) #1386c7 TLS GZIP Signed-in Token (gkzhukov) (Google Pixel 6)
Sep 19, 2024 10:30:29.473 [0x7000063a2000] Debug — Completed: [192.168.50.1:52202] 200 GET /identity (9 live) #1386c7 TLS GZIP 0ms 455 bytes (pipelined: 9)
Sep 19, 2024 10:30:32.923 [0x700006219000] Warning — NetworkServiceBrowser: Error sending out discover packet from 169.254.193.124 to 239.255.255.250: No buffer space available
Sep 19, 2024 10:30:39.557 [0x700005f8a000] Debug — Request: [192.168.50.1:52202 (Subnet)] GET /identity (6 live) #1386cc TLS GZIP Signed-in Token (gkzhukov) (Google Pixel 6)
Sep 19, 2024 10:30:39.558 [0x7000063a2000] Debug — Completed: [192.168.50.1:52202] 200 GET /identity (6 live) #1386cc TLS GZIP 0ms 455 bytes (pipelined: 10)
10

Well yes Database seems corrupted, you can try to open it with a tool like DB explorer and see, but Plex support will be better to find out what part.