519466 - lost all passwords

Status: RESOLVED WORKSFORME

(Toolkit :: Password Manager, defect)

Description

[Dietrich Ayala (:dietrich)]

using trunk nightlies, i've lost all passwords a couple of times in the last week (or thereabouts). i've had a few crashes during that time.

i have no STR at the moment, just wanted to get this on the radar.

Comment 1

[Justin Dolske [:Dolske]]

Do you still have a signons.sqlite? Is there stuff in it?

Comment 2

[Justin Dolske [:Dolske]]

mconnor noted that mozStorage defaults to "PRAGMA synchronous = NORMAL", we could flip this to = FULL...

http://www.sqlite.org/pragma.html

Comment 3

[Paul O'Shannessy [:zpao] (not bugmail, email directly)]

(In reply to comment #2)
> mconnor noted that mozStorage defaults to "PRAGMA synchronous = NORMAL", we
> could flip this to = FULL...

Mine is set to FULL. That could be because mine is the original signons.sqlite and maybe we hadn't set synchronous=normal yet?

> http://www.sqlite.org/pragma.html

That seems to imply that pragma only really helps with OS crashes.

It also says FULL is slower. Right now that's not an issue, but with more writes happening in bug 465636, it might? Though signons.sqlite is tiny compared to places, so its likely negligible.

Comment 4

[Daniel Veditz [:dveditz]]

Is this bug going anywhere useful at this point? WFM.

Comment 5

[Paul O'Shannessy [:zpao] (not bugmail, email directly)]

My new signons db is still synchronous = full (which doesn't really make sense).

Either way, it doesn't seem like this has been much of an issue since it came up

Comment 6

[Paul O'Shannessy [:zpao] (not bugmail, email directly)]

(In reply to comment #5)
> My new signons db is still synchronous = full (which doesn't really make
> sense).

FWIW, I now know that PRAGMA synchronous is set on each connection, so when I was opening my db via the command line, that was sqlite3 setting synchronous = full, not firefox.