I've recently noticed lots of error-sync logs in the %APPDATA%\Mozilla\Firefox\Profiles\<My Profile>\weave\logs folder. My sync is set up to handle Bookmarks and Hi… (read more)
I've recently noticed lots of error-sync logs in the %APPDATA%\Mozilla\Firefox\Profiles\<My Profile>\weave\logs folder. My sync is set up to handle Bookmarks and History only.
I have 4 devices, 2 PCs - both Firefox 56.0.2 32-bit and 2 Android devices (latest Firefox, not sure of version). All 4 were previously set to sync together, Bookmarks/History.
One of the PCs (Windows 7 x64) - has the logs, but I've read numerous articles online on how to fix Sync myself or correct a corrupted places.sqlite database as that's what the error log seems to be suggesting is wrong.
Running check integrity against places.sqlite gives me this:
> Task: checkIntegrity - Unable to check database integrity > Task: checkCoherence - The task queue was cleared by an error in another task. > Task: expire - The task queue was cleared by an error in another task. > Task: vacuum - The task queue was cleared by an error in another task. > Task: stats - The task queue was cleared by an error in another task. > Task: _refreshUI - The task queue was cleared by an error in another task.
I have tried to repeat the process in safe mode and with a clear (new) profile - the issue persists. I have deleted places.sqlite (after making a backup) to see if sync suddenly starts working - but the bookmark related issue simply returns.
I have signed out on all devices, changed my sync password and logged in on just the PCs (for now until the problem is resolved). I have deleted all bookmarks on the 'problem' PC, then re-imported them from Internet Explorer on the other PC, then reactivated sync - this seems to initially work but once the 'problem' PC has the bookmarks, it tries to sync them and the errors return.
The error in question appears to be this:
1527797240532 Sync.Engine.Bookmarks WARN Error while backing up bookmarks, but continuing with sync: Error: Error(s) encountered during statement execution: database disk image is malformed (resource://gre/modules/Sqlite.jsm:823:25) JS Stack trace: handleCompletion@Sqlite.jsm:823:25 1527797240534 Sync.BrowserIDManager DEBUG _ensureValidToken already has one 1527797240543 Sync.Engine.Bookmarks DEBUG Successfully wrote previousFailed.
I can supply the entire file if required or put it on pastebin.
The only real issue I'm having is that I simply want my history/bookmarks (but nothing else) shared between all my devices that use Firefox, be it quantum or 56.0.2.
I have not tried Firefox Quantum (as numerous add-ons I use are unsupported and I didn't want to simply switch without a road back). I did try Firefox 52.0.8 ESR but the first thing it did was delete my places.sqlite so I wasn't able to reproduce the problem I'm having as I don't want to lose my history data (bookmarks are stored primarily in IE for convenience and simply imported when I need them as I use 'PlainOldFavorites' extension).
This looks like a bug with firefox sync or a corrupt file, but since I've cleared places.sqlite and let FF recreate it, I'm at a loss. If you need any further information to help solve this, I'm happy to provide as much as possible.
Thanks for any suggestions you can offer :)