Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Sync fails sync Bookmarks on one PC only.

  • 11 replies
  • 1 has this problem
  • 1 view
  • Last reply by FredMcD

more options

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 :)

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 👍 0

All Replies (11)

more options

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.

more options

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

more options

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 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

Hi FredMcD,

Here's the latest sync log content:

https://pastebin.com/hGKxniWs

I haven't tried safe-mode with networking yet, I'll be sure to do that later today when I get home from work.

more options

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.

more options

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.

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.

more options

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.

more options

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.

more options
more options

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.

more options

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.

more options

That was very good work. Well done. Please flag your last post as Solved Problem so others will know.