404565 - Bookmarks not loaded, "places.sqlite.corrupt" files generated

Status: RESOLVED DUPLICATE of bug 408443

(Firefox :: Bookmarks & History, defect)

Description

[Russell Gilbert]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9b1) Gecko/2007110904 Firefox/3.0b1

I just installed 3.0b1 on XP and none of my bookmarks from 2.0.0.9 are loaded. Looking in the profile directory, I see that it's generating lots of files like the following, all zero length:

places.sqlite.corrupt
places.sqlite-1.corrupt
places.sqlite-2.corrupt
places.sqlite-3.corrupt
places.sqlite-4.corrupt
[...]
places.sqlite-182.corrupt
places.sqlite-183.corrupt

It seems to be creating about 10 of these per minute while I have 3.0b1 running.

The "places.sqlite" file is 379 KB and seems to be fine in 2.0.0.9. I used the SQLite Database Browser for Windows to view the places.sqlite file and I don't see any problems. When I browse the data in the moz_places table, it shows exactly 900 entries. I wonder if the size of the file has something to do with the problem.

Reproducible: Always

Steps to Reproduce:
1. Start Firefox 3.0b1 on a machine that normally runs 2.0.0.9 with bookmarks.
2. Notice that no bookmarks are available.
3. Notice "places.sqlite.corrupt" files in profile directory.

Comment 1

[Russell Gilbert]

More info:

The star to the right of the location box is grayed out.  Pressing Ctrl-D or selecting "Bookmark this page" from the Bookmarks menu does nothing.  Also I see that when I type in a URL (www.somewhere.com) and press enter, the page comes up but the spinning circle on the tab never stops spinning, and the location bar never inserts the http:// in front of the URL.  Also the History menu never shows any entries, and the location bar doesn't show the URL in the MRU list.

Comment 2

[Marco Bonardo [:mak]]

close firefox, ***make a backup of your profile folder***, then try to delete all places.* files you find there. then restart firefox and wait for it to fully load... does the same happen?
notice that 2.0.0.9 does not use places.sqlite at all

Comment 3

[Russell Gilbert]

Yes, that fixed the problem.  I now have all bookmarks, and all of the other problems mentioned above are gone.  Thanks!

Comment 4

[Nitin (vfwlkr)]

Resolving as WFM based on comment 3

Comment 5

[(not reading, please use [e-mail] instead)]

reopening.

heads up, I think I saw this earlier today with the following scearnio:

run fx3a2, create a profile.
now run fx3b2

assuming you don't have a build with the fix for bug #408443, you'll hit this bug and you'll get the bookmarks not loaded problem and get places.sqlite.corrupt files.

let me double check, but I think this is really a dup of bug #408443

Comment 6

[(not reading, please use [e-mail] instead)]

russell, did you ever try out granparadiso / ff3 alpha 2, alpha 3, alpha 4?

Comment 7

[(not reading, please use [e-mail] instead)]

fwiw, I think this is a dup.

going from a2 -> b2 (but should happen with a2 -> a5,a6,b1 as well), my bookmarks are not loaded and more importantly, I get about 5 places.sqlite.corrupt files (all 0 bytes) each time I visit a link.

marking as a dup, but would still like to hear from russell if he ever ran a2, a3 or a4 before trying b1.

note, see also bug #408751, nsNavHistory::Init is fragile, which is related.

Comment 8

[Ria Klaassen (not reading all bugmail)]

Isn't this bug 404695 ?

Comment 9

[(not reading, please use [e-mail] instead)]

> Isn't this bug 404695 ?

or, #404695 could also be a dup of bug #408443

Comment 10

[Russell Gilbert]

Seth, no, I never tried granparadiso.  I don't remember installing any version of ff3 before beta1, but I can't be positive.  Looking in the registry under "HKEY_LOCAL_MACHINE\SOFTWARE\Mozilla", I only see keys for "Mozilla Firefox 2.0.0.11" and "Mozilla Firefox 3.0b1", if that helps.

Comment 11

[(not reading, please use [e-mail] instead)]

Russell, thanks for the quick response.

would you mind trying out a trunk build from 12/18 or later with the fix for bug #408443?

Comment 12

[Russell Gilbert]

Seth, I tried 3.0b2 today, and it seems to be fine.  When I first loaded it, it had the bookmarks as they were when I tried 3.0b1 a while back, and not the latest changes I'd made while using 2.0.0.11.  I assume this is as expected.  I then shutdown 3.0b2, deleted the places.sqlite file, and restarted it.  It rebuilt the file with the latest bookmarks, with no problems.

I don't know if this is really a fair test of the original problem, but maybe it helps.

Comment 13

[Gervase Markham [:gerv]]

Bug 451915 - move Firefox/Places bugs to Firefox/Bookmarks and History. Remove all bugspam from this move by filtering for the string "places-to-b-and-h".

In Thunderbird 3.0b, you do that as follows:
Tools | Message Filters
Make sure the correct account is selected. Click "New"
Conditions: Body   contains   places-to-b-and-h
Change the action to "Delete Message".
Select "Manually Run" from the dropdown at the top.
Click OK.

Select the filter in the list, make sure "Inbox" is selected at the bottom, and click "Run Now". This should delete all the bugspam. You can then delete the filter.

Gerv