1453257 - bookmark sync fails: Error: Error(s) encountered during statement execution: datatype mismatch

Status: RESOLVED WORKSFORME

(Firefox :: Sync, defect)

Description

[James [silentj]]

Attachment: error-sync-1523440163279.txt

User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:59.0) Gecko/20100101 Firefox/59.0
Build ID: 20100101

Steps to reproduce:

Try to run firefox sync


Actual results:

an error is reported around bookmark syncing:

1523440162549	Sync.ErrorHandler	DEBUG	bookmarks failed: Error: Error(s) encountered during statement execution: datatype mismatch (resource://gre/modules/Sqlite.jsm:822:25) JS Stack trace: [e-mail]:822:25



Expected results:

sync should have completed successfully

Comment 1

[Lina Butler [:lina]]

Hi James! Sorry for the trouble. :-( Do you remember if you manually flipped `services.sync.engine.bookmarks.buffer` in about:config to `true`, or synced with a Nightly that's older than 15 days? Bug 1426556 is the likely culprit; it added a backward-incompatible schema change without a migration, since the feature is pref'd off. In retrospect, that wasn't a good idea.

Either way, you should be able to unstick Sync by closing Firefox, deleting `weave/bookmarks.sqlite` from your profile folder, and restarting.

Comment 2

[James [silentj]]

Yes, that is exactly what I have done. I have done both of those things, flipped the pref and have been away on holiday so my versions of nightly on different machines became quite out of date.

removing weave/bookmarks.sqlite has fixed the issue

Thanks!

Comment 3

[Lina Butler [:lina]]

Awesome, thanks, James!