470270 - SQLITE_CORRUPT in some user Profiles

Status: RESOLVED DUPLICATE of bug 464486

(Firefox :: Bookmarks & History, defect)

Description

[Bruno Calvignac]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.4) Gecko/2008121523 Firefox/3.0.4 Flock/2.0.3pre
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.4) Gecko/2008121523 Firefox/3.0.4 Flock/2.0.3pre

Some of our Flock users are reporting problems that we traced back to a SQLITE_CORRUPT places.sqlite.

They tend to be on Windows and Flock version is based on Firefox 3.0.2.

We also experienced SQLITE_CORRUPT in our Flock RDF Sqlite database. This database has a fixed table structure that never changes.

Reproducible: Couldn't Reproduce




I can send you a couple of corrupted profiles if this can help you.

Comment 1

[Bruno Calvignac]

Unlike bug 404695, no places.sqlite.corrupt was created

Comment 2

[Nochum Sossonko [:Natch]]

See bug 464486 and bug 414715 for the work being done for 3.1, firefox had also been swamped with these reports.

Comment 3

[Bruno Calvignac]

Thank you very much Natch.

Comment 4

[Marco Bonardo [:mak]]

sqlite_corrupt can actually happen not using PRAGMA synchronous=FULL, we actually are using normal, corruption is usually caused by power failure, io errors or (maybe) strange crashes... notice also some old sqlite version could contain some bug that in certain circumstances could cause corruption, latest version (IIRC used in 3.05 and 3.1) corrects some of them.

Comment 5

[Marco Bonardo [:mak]]

Bruno, do you need this separate bug or can we dupe it to bug 464486 since are practically investigating the same issue?

Comment 6

[Bruno Calvignac]

Yes, we can mark it as duplicate. Thanks

Comment 7

[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