508119 - "ASSERTION: sqlite3_close failed" on shutdown involving moz_favicons

Status: RESOLVED DUPLICATE of bug 508394

(Firefox :: Bookmarks & History, defect)

Description

[Jesse Ruderman]

I get this most of the time when quitting Firefox on Mac.

WARNING: SQL statement 'SELECT f.data, f.mime_type FROM moz_favicons f WHERE url = ?1' was not finalized: file /Users/jruderman/central/storage/src/mozStorageConnection.cpp, line 509

###!!! ASSERTION: sqlite3_close failed. There are probably outstanding statements that are listed above!: 'srv == SQLITE_OK', file /Users/jruderman/central/storage/src/mozStorageConnection.cpp, line 522

Comment 1

[Drew Willcoxon :adw]

Bug 508394 is a dupe, but marking this one the dupe since there's a stack over there.

Comment 2

[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