Sync stuck on "Waiting to download"

Not sure if what I am about to say has been mentioned anywhere, but I have been having considerably miserable time trying to sync content and wanted to add what worked for my Pixel 1 phone.

I happened to see a few threads in this post that mention issues with sqllite and/or metadata databases. On an absolute whim, I decided to try to “Analyze” the file in Plex which I was trying to sync to my mobile mobile.

Upon completing analysis of the file and re-initiated the sync process, it synced up very quickly. I am going to try this on some more files.

Did I just get lucky or can this somehow be something contributing to the issues?

UPDATE: i think it was just luck lol.

Sync still not working for me. Worked for a short while after a clean up and fresh install but now getting the all to familiar “Waiting to Download” issue again.

As a plex pass user I can’t belive that this issue has been allowed to persist for years now

I know that the guys have been trying to fix sync, but it is still broken and I have the latest server build and android client. Plex has detected that a new episode is available and has done something as the programme now appears in the bottom half of the sync screen. However, when you click on the programme icon no episodes are displayed. I have seen this same issue many times before. All other programmes that I have configured to sync are working OK.

Anyone else still having problems

@goodjob can you please provide some up to date client logs?

in case there are also server aspects - please see my post about diagnostics Sync stuck on "Waiting to download"

I’ve turned on logging so will forward if I see the issue again. The problem show is now available offline though when you click on the show on the Downloads & sync configuration screen the downloaded show doesn’t appear. Downloads for other shows do appear.

I am running my plex server on Ubuntu (1.13.9.5439) and everything is always stuck at “waiting to download” on all my android device (7.7.2.7701). transcoding is fine.

Where do I attach the client log?

I have the exact same issue on two android devices (latest app; latest server version).

Logs are provided more than enough.

I’m at my wits end with this app. Trying to be patient, knowing all too well the frustration of fixing someone else’s code, but sync is a core feature and selling point and as far as I can tell it’s never worked reliably. What’s worse, after the latest Android app update, now while it wallows in the “waiting to download” state, its trying to melt down my battery. How has this gotten worse?

And if I have to reinstall the android app again, I may be out. Each install is a good 45+ active minutes of syncing my playlists, setting up download rules for my podcasts (and then babysitting the download process as it usually makes a mess of things), etc.

With that out of the way, the logs for my “waiting to download” state basically repeat a stack trace that leads with this message:

Stacktrace: com.plexapp.plex.net.sync.db.core.DatabaseManager$OperationError: com.plexapp.plex.net.sync.db.core.DatabaseError: org.sqlite.database.sqlite.SQLiteException: no such collation sequence: naturalsort (code 257): , while compiling: DELETE FROM metadata_items WHERE id=?

I see posts mentioning a server reinstall due to a corrupt DB, but everything is working fine in the browser app, and android mobile is working fine other than sync. Any way past this?

It’s also still throwing the same stack trace every 500ms, 10 minutes after I cancelled the failed sync job in-app. I sorta appreciate the tenacity :smiley: , but how about a failed attempt limit? This thing wants to see fire…

Please provide your entire log file. 1 Stack trace doesn’t mean much without the content of everything else going on around it.

For sync issues where there is a server and client actions, it is always best to get logs from both sides plus screenshots of the issue

For the logs i have already linked to a post that refers to the articles covering server and client logs here Sync stuck on "Waiting to download" - #248 by sa2000

Been having this issue on and off for a while now. Had it on ios and now it’s less stable in the android version. Frustrating because when it works it’s great.
It’s been stuck on “waiting to download” and eating through my battery making the phone very hot. Sometimes it invisibly syncs things without updating the progress bars, sometimes it doesn’t.
I’m trying to sync a playlist of recently added music and an artist. Seems like the latest version broke something for me. Would love to avoid reinstalling things if possible.
If I do need to reinstall the app I’d probably roll back to a more stable version, does anyone have a recommendation which android version had the best sync reliability? Feel like one or two releases ago I decided to stop updating but can’t remember for sure.

Thanks, see logs attached.

Plex Media Server Logs_2018-11-25_12-55-43.zip (2.6 MB)
plex-log-thatwascool.zip (2.1 MB)

I’ve played around with this quite a bit looking for a pattern. Thought I had it narrowed down to instances where my phone screen shuts off (locking phone) before sync complete, but later disproved that. Then i thought it was when I was doing music syncs that included transcodes, but disproved that as well. The only real pattern I can discern is if I do a small sync that takes under a minute or so, it usually completes. Much more complex than that and it eventually reaches perpetual “Waiting to download” status and I have to Force Stop the app to prevent meltdown.

I agree with ‘thatwascool’ that the prior android version was more reliable. Glad to hear in the newsletter this issue is getting some attention though, and thanks to those working on it.

Here are my logs.
Server version 1.13.9.5456 for Thecus NAS:
Plex Media Server Logs_2018-11-25_17-12-09.zip (3.7 MB)
Android device:
Manufacturer: samsung
Device: heroqltevzw
Model: SM-G930V
Product: heroqltevzw
Version: 8.0.0
plex-log-ironmonk.zip (3.0 MB)

Thanks for the logs. I can see database errors on the android that relate to sync. I will discuss this with the development team

Further to my earlier post, this is now being looked into by the development team

1 Like

Update:

(As a preface, I have Plex mobile set to only sync on WiFi.) Twice over the past two days, when returning home to WiFi range, upon opening Plex mobile the sync that failed in my earlier posted logs resumed and started syncing items again. It didn’t resume to completion in either case, however (the first time, it stalled out as before, and the second time I had to leave before completion). Checked again today after getting home, and the sync has not resumed - its returned to the “Waiting to download” status in the mobile app sync page (“Updating information” is the message in the pull-down android notification).

Would updated logs be helpful?

There is no harm in having extra logs.

The earlier issue appears to be a timing problem where sync process is starting too early on launch

Ah ok, perhaps some DB corruption from too many hands in the pot on app launch.

Current logs for the same sync:

Plex Media Server Logs_2018-11-27_20-21-16.zip (4.2 MB)
plex-log-ironmonk.zip (2.0 MB)

FYI I have not yet performed the latest Plex Android version update. If it contains relevant changes, I’ll be happy to retest; just haven’t had time to view the changelog.

thatwascool:
Been having this issue on and off for a while now. Had it on ios and now it’s less stable in the android version. Frustrating because when it works it’s great.
It’s been stuck on “waiting to download” and eating through my battery making the phone very hot. Sometimes it invisibly syncs things without updating the progress bars, sometimes it doesn’t.
I’m trying to sync a playlist of recently added music and an artist. Seems like the latest version broke something for me. Would love to avoid reinstalling things if possible.
If I do need to reinstall the app I’d probably roll back to a more stable version, does anyone have a recommendation which android version had the best sync reliability? Feel like one or two releases ago I decided to stop updating but can’t remember for sure.
Thanks, see logs attached.
Plex Media Server Logs_2018-11-25_12-55-43.zip (2.6 MB)
plex-log-thatwascool.zip (2.1 MB)

Rolling back to 7.4 fixed this for me immediately, not sure whether I had to delete all the synced content or not but I did.
First I tried 7.7 and 7.6 to no avail before jumping back to 7.4 so will stay here until forced to update or there’s a confirmed fix for this.