676996 - Repeated corruption of places.sqlite

Status: RESOLVED INCOMPLETE

(Firefox :: Bookmarks & History, defect)

Description

[Krueger Industrial Smoothing]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0.1) Gecko/20100101 Firefox/5.0.1
Build ID: 20110707182747

Steps to reproduce:

Using Firefox for normal everyday browsing.


Actual results:

places.sqlite becomes corrupt almost daily, causing me to lose all browsing history.


Expected results:

places.sqlite should not become corrupt.

Comment 1

[Krueger Industrial Smoothing]

I have stopped using Firefox 7.02a and reverted to Firefox 5.0 to see if the problem goes away.  I experienced corruption of places.sqlite a couple of times with early betas of Firefox 4.0 but it now seems to be happening almost daily with all nightly builds of Firefox 7.02a.

Comment 2

[(mostly gone) XtC4UaLL [:xtc4uall]]

You can give Places Maintenance Extension (https://addons.mozilla.org/en-US/firefox/addon/places-maintenance/) a Try.

After fixing the Database run Firefox extension-less/in Safe-Mode and see if the Corruption happens again.

Comment 3

[Tim (fmdeveloper)]

Reporter -> Any update? Is this still an issue with Firefox 9? Did you do the steps in comment 2?

Comment 4

[Tim (fmdeveloper)]

Closing bug as Incomplete - if you are still experiencing this issue or have more information to provide feel free to post back here and we can re-open the bug. You can also get assistance by visiting the Firefox help site -> https://support.mozilla.com/en-US/kb/ask

Comment 5

[Krueger Industrial Smoothing]

(In reply to XtC4UaLL [:xtc4uall] from comment #2)
> You can give Places Maintenance Extension
> (https://addons.mozilla.org/en-US/firefox/addon/places-maintenance/) a Try.
> 
> After fixing the Database run Firefox extension-less/in Safe-Mode and see if
> the Corruption happens again.

I installed this extension.  Every time I run it, it says that the database is corrupt.  Previously, I was only having corruption issues approximately every third or fourth time I started Firefox.

Comment 6

[Krueger Industrial Smoothing]

(In reply to Tim (fmdeveloper) from comment #4)
> Closing bug as Incomplete - if you are still experiencing this issue or have
> more information to provide feel free to post back here and we can re-open
> the bug. You can also get assistance by visiting the Firefox help site ->
> https://support.mozilla.com/en-US/kb/ask

I am still experiencing this problem with Firefox 9.01. (And with every version since 4.0)

It appears that the corruption of 'places.sqlite' is happening when Firefox **** down, i.e., the file appears to be OK when I exit, but the next time I run Firefox it is corrupted.  This does not happen *EVERY* time I run Firefox but approximately every third or fourth time.  

Since Firefox 4.0 I have had to make a regular practice of always making a copy of 'places.sqlite' before exiting Firefox so that I have a replacement when it becomes corrupted.

Comment 7

[(mostly gone) XtC4UaLL [:xtc4uall]]

Within the corrupted States, when the Database is reported sane, have you used any Bookmark/History related Addons?

Against what Version of Firefox did you experience the Issue now?

Comment 8

[Marco Bonardo [:mak]]

Do you have the profile on disk? Or are you using some sort of network disk for it?
It's strange that it keeps corrupting, to me looks like there may be some hardware problem, did you test memory with something like MemTest86?
Did you try doing a clean reinstal, thus uninstall and completely remove the Mozilla firefox folder from Program Files, then reinstall. I wonder if you may be using the wrong libmozsqlite for whatever reason...

Comment 9

[Edmund Craske]

At work here we are having general issues with places.sqlite corruption on Windows 7 in a domain environment using roaming profiles with folder redirection. I'm not sure if this is so much a Firefox bug as an SQLite bug or indeed actually a Windows 'feature' - our workaround is to change our profiles to be on local disk instead of part of our roaming profile.

Comment 10

[Marco Bonardo [:mak]]

(In reply to Edmund Craske from comment #9)
> At work here we are having general issues with places.sqlite corruption on
> Windows 7 in a domain environment using roaming profiles with folder
> redirection. I'm not sure if this is so much a Firefox bug as an SQLite bug
> or indeed actually a Windows 'feature' - our workaround is to change our
> profiles to be on local disk instead of part of our roaming profile.

See bug 719952 and its dependencies.

Comment 11

[Marco Bonardo [:mak]]

not enough information to reproduce, likely bug 719952