Sync fails sync Bookmarks on one PC only.
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 :)
Chosen solution
UPDATE:
I've found the cause of my problem is a corrupted favicons.sqlite. I discovered this after copying a known good profile and grafting parts of the corrupted profile onto it - small chunks at a time.
Deleting the favicons.sqlite or renaming it or using any other version seems to correct the issue and things are syncing and behaving as they should.
Thank you all for your help and I hope someone else finds this useful.
Read this answer in context 👍 0All Replies (11)
Hi, you can check your add-ons here : https://alternativeto.net/ for alternatives for 57+
Please open this URL : https://support.mozilla.org/en-US/kb/forum-response-firefox-sync-verification-email-faq At the bottom of the page you will find information to create a bugzilla account please do so and follow instructions. Thank You.
Please let us know if this solved your issue or if need further assistance.
I called for more help.
Sync We need to look at the sync logs. Type about:sync-log<enter> in the address bar.
Open the last file created and Copy its contents Now Paste it into this forum.
arkane78 said
Running check integrity against places.sqlite gives me this:
> Task: checkIntegrity
- Unable to check database integrity
One possible reason is the file is being used by another program.
Start your Computer in safe mode with network support. Then start Firefox. Run the test. Is the problem still there?
http://encyclopedia2.thefreedictionary.com/Linux+Safe+Mode Starting Any Computer In Safe Mode; Free Online Encyclopedia
Pkshadow said
Hi, you can check your add-ons here : https://alternativeto.net/ for alternatives for 57+ Please open this URL : https://support.mozilla.org/en-US/kb/forum-response-firefox-sync-verification-email-faq At the bottom of the page you will find information to create a bugzilla account please do so and follow instructions. Thank You. Please let us know if this solved your issue or if need further assistance.
Hi Pkshadow,
Why do I need to create a bugzilla account?
I'm happy to create one but the page you direct you to suggests that if my e-mail address is inaccessible - I should create a bugzilla account, but my e-mail addresses aren't inaccessible.
FredMcD said
I called for more help.
Sync We need to look at the sync logs. Type about:sync-log<enter> in the address bar.
Open the last file created and Copy its contents Now Paste it into this forum.
arkane78 said
Running check integrity against places.sqlite gives me this:
> Task: checkIntegrity
- Unable to check database integrityOne possible reason is the file is being used by another program.
Start your Computer in safe mode with network support. Then start Firefox. Run the test. Is the problem still there?
http://encyclopedia2.thefreedictionary.com/Linux+Safe+Mode Starting Any Computer In Safe Mode; Free Online Encyclopedia
Hi FredMcD,
Here's the latest sync log content:
I haven't tried safe-mode with networking yet, I'll be sure to do that later today when I get home from work.
HI, only blockquote was is actually needed please : https://www.w3schools.com/tags/tag_blockquote.asp
Yes I do know what the page says. Please make the bugzilla account click then put your error messages in that there is also the other link and it will get a Supervisor to look at it as Support has no access to the servers and what ever else needs to be done to get your account working and syncing. properly.
You can post here as long as you would like but unfortunately we can not act on any of it. Thank You.
There is a problem with the places.sqlite database.
1527833092926 Sync.Engine.Bookmarks WARN Error while building GUID map, skipping all other incoming items: 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 1527833092926 Sync.Engine.Bookmarks WARN Reconciliation failed: aborting incoming processing. 1527833093215 Sync.Engine.Bookmarks DEBUG Records that failed to apply: menu 1527833093481 BookmarkSyncUtils DEBUG pushChanges: Processed change records: {"skipped":6276,"updated":0,"tombstones":0} 1527833093482 Sync.Status DEBUG Status for engine bookmarks: error.engine.reason.unknown_fail 1527833093482 Sync.Status DEBUG Status.service: success.status_ok => error.sync.failed_partial 1527833093482 Sync.ErrorHandler DEBUG bookmarks failed: 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 1527833093482 Sync.Telemetry TRACE observed weave:engine:sync:error bookmarks
If "Verify Integrity" on the "Help -> Troubleshooting Information" (about:support) page cannot repair places.sqlite then remove all places.sqlite files in the Firefox profile folder. Firefox will rebuild places.sqlite and restore the bookmarks from a recent JSON backup in the bookmarkbackups folder.
- keep a backup copy of places.sqlite in case a new places.sqlite database has to be created
- http://kb.mozillazine.org/Unable_to_process_the_backup_file_-_Firefox
You can use the button on the "Help -> Troubleshooting Information" (about:support) page to go to the current Firefox profile folder or use the about:profiles page.
- Help -> Troubleshooting Information -> Profile Directory:
Windows: Show Folder; Linux: Open Directory; Mac: Show in Finder - http://kb.mozillazine.org/Profile_folder_-_Firefox
Hi cor-el,
Thanks for your help - the Verify Integrity command does indeed fail when I try it - so I've deleted all places.sqlite files that I can find in the profile and will monitor the situation.
UPDATE:
It seems even with a new places.sqlite database, verify integrity still fails but I've yet to see if sync fails or not. I'm going to hazard a guess and say it probably will and that it's something to do with the profile itself, rather than places.sqlite - but I can't think of what that could be.
Will update with more information as I find it.
Use these links to create a new profile. Use this new profile as is. Is the problem still there?
http://kb.mozillazine.org/Profile_folder_-_Firefox#Navigating_to_the_profile_folder
https://support.mozilla.org/en-US/kb/profile-manager-create-and-remove-firefox-profiles
https://support.mozilla.org/en-US/kb/how-run-firefox-when-profile-missing-inaccessible
https://support.mozilla.org/en-US/kb/back-and-restore-information-firefox-profiles
Type about:profiles<enter> in the address bar.
UPDATE:
I have run sync successfully on a copied version of the other PC profile, using the places.sqlite from my original PC profile.
I have confirmed that sync works as expected (albeit after a little trial and error). This leads me to conclude that my main profile is corrupted, yet I don't know exactly how or why.
I can continue to update this thread with any new findings or I can simply mark it as solved as the issue looks to be a corrupted profile.
Chosen Solution
UPDATE:
I've found the cause of my problem is a corrupted favicons.sqlite. I discovered this after copying a known good profile and grafting parts of the corrupted profile onto it - small chunks at a time.
Deleting the favicons.sqlite or renaming it or using any other version seems to correct the issue and things are syncing and behaving as they should.
Thank you all for your help and I hope someone else finds this useful.
That was very good work. Well done. Please flag your last post as Solved Problem so others will know.