Dropbox is stuck syncing after an update, what can I do?

Hello all, I earlier supplied what I thought was a complete solution to this syning issue.

It revolved around using the cloud online-only files system of comerical level accounts *1, unlinking, moving content to a save location, syning using cloud only files, stopping the app, moving content back in over the cloud files, then restarting the app, and havbing it worj its way through the change in files from cloud to real, for the most part this works or did on our system of 700K+ files @ 2+TB size.

However one of the machines syncing that lot does a few more folders than the others. It stores a backups folder that is Selectively Synced to only sync to that machine this is so Dropbox holds a additional backup (of the backups) of these files. I noticed today while still doing its job anbd syning active changes it was never able to complete syning like the other machines had days before. So I ran up my trusty OpenFileView app to see what files its accessing and I found it reading its way through 4 files (it does this as it reindex/compares the content to its checksum lists & it processes multiple files at once doing this) each one of the files was over 4GB, and when it reached the end of one, it just started reading the same file again, this repeated over and over again with out end (hours later still the same files).

My resolve to this was to move the content out of dropbox it was looping on (i removed the whole backups folder which was full of these files) I am yet to reinsert them but suspect this will be fine as it wont bn a reindex/compare but arather a new file added index, which i hope will work fine. Once the files were removed the indexing moved on and is heading towards completing with the index count reapearing and dropping steadly.

While observing this now working through different files, I saw it a few times hit other 4GB files and seem to stutter on them repeatedly reading them at least once sometimes more, but then moving on.

It appears that it might be a edge event when  all 4 of the files it is processing are over 4GB the end result being a stuck here situation when it never leaves that spot.

I would again suggest the app OpenedFilesView http://www.nirsoft.net/utils/opened_files_view.html v1.86 x64 and target it to look at "dropbox" or files in your dropbox folder path, this will show you what files its processing at that time. Our Folder path ios F:\Dropbox by the way dont use that unless its yours also.

One thing to note, dropbox was designed to sync from the smallest to the largest files, so that it can have the largest number of files in sync as quick as possible, in the most cases it does this, however that means it needs to order all the files you have and that function seems to crash if you have to many files and at that time it then proceeds on with what ever the lists order is at the time, hence why it jumps up to 4GB+ files but then is doing 1GB+ files and is as i type doing some in the 100's of meg size, and some smaller but they are hard to spot as they dont always appear in the OpenedFileView as they take so little time to do they are gone before it refreshes. 

I will report again once it completes sync on what the result of reinsterting the BACKUPS folder is, this holds 55 files at 250GB ranging from <1mb to <16gb

(< 16gb as i had to split them to ensure OneDrive/SharePoint can also upload them)

I HOPE THIS INFO MAY HELP OTHERS WITH SYNING ISSUES.

Dave.

*1 if you have a free account and your stuck syning stop crying, simply uninstall the app and then reinstall. You dont have enough content for a real issue on syncing.