1434199 - Bookmark sync failing with "bookmarks failed: Error: Error(s) encountered during statement execution: database disk image is malformed"

Status: RESOLVED WORKSFORME

(Firefox :: Sync, defect)

Description

[Marc Hoellinger]

Attachment: logs.rar

User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:58.0) Gecko/20100101 Firefox/58.0
Build ID: 20180118215408

Steps to reproduce:

I have no bookmarks on my Windows client since version 57.
I have in my sync account bookmarks that should come from my MAC client. I have the latest version installed on both devices.

My sync account has the mail address [e-mail].

Attached you will find all log files
I have already tried to uninstall the Windows client and manually remove all Temp files and restore the sync after reinstalling. There is no error in the connection, but the bookmarks do not appear.

On my mobile (iOS) Firefox I also see no bookmarks, so it may be that the problem may be s.MAC Client

Comment 1

[Marc Hoellinger]

i try it again ... 
but there is a little mistake in Bug Details

i try it on MAC ... there are all bookmarks
i try it on iOS and there are all bookmarks 

only on Windows there is no bookmark (Tested with 58.0.1 64bit)

Comment 2

[Marc Hoellinger]

??

Comment 3

[Mark Hammond [:markh] [:mhammond]]

Sadly the Windows machine appears to have a corrupt sqlite file. What's strange about this is that Places is supposed to detect and handle this, although I suspect that the database isn't so corrupt that it fails to open, but is corrupt enough for certain operations to succeed.

Mak, is there anything you'd like to ask here? ie, would the sqlite files from the profile be at all useful to you?

sadly we've lost exact stacks in the sync log - all we have is:
> 2018-01-22 07:27:48.177000 (00:00:25.480)	Sync.ErrorHandler	DEBUG	bookmarks failed: Error: Error(s) encountered during statement execution: database disk image is malformed (resource://gre/modules/Sqlite.jsm:810:25) JS Stack trace: [e-mail]:810:25

Comment 4

[Marco Bonardo [:mak]]

(In reply to Mark Hammond [:markh] from comment #3)
> although I suspect that the database isn't so corrupt that it fails to open,
> but is corrupt enough for certain operations to succeed.
> 
> Mak, is there anything you'd like to ask here? ie, would the sqlite files
> from the profile be at all useful to you?

Unfortunately there isn't much I can do with a physically corrupt file. You are right that it may be a corruption only detected at runtime and not on opening.
We do such checks in the weekly maintenance, but we know that idle-daily doesn't fire coherently for all the users, and this could be one of those cases.
What would probably help is bug 1220723.

Comment 5

[Mark Hammond [:markh] [:mhammond]]

The attached logs have from 22nd Jan to 30th Jan - IIUC, places maintenance runs weekly or so. So hopefully this might magically fix itself in the next day or 2 (and if not, a corrupt file might then be interesting to work out why).

Marc, thanks for reporting! Can you please keep an eye on things for the next few days, and if the problem persists upload a new snapshot of your logs?

Comment 6

[Marco Bonardo [:mak]]

note, it's possible to force maintenance from about:support

Comment 7

[Marc Hoellinger]

ticket can close

--> about:support <-- Works fine

Comment 8

[Mark Hammond [:markh] [:mhammond]]

Thanks for the update!