671540 - firefox freezes when deleting history

Status: RESOLVED DUPLICATE of bug 466421

(Firefox :: Bookmarks & History, defect)

Description

[Jithin Emmanuel]

User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.122 Safari/534.30

Steps to reproduce:

I wanted to delete some history items because I suspected that I have too may and it was slowing down my browser. I opened the bookmark manager (Cmd + shift + B) and on History I searched for keyword "bouncer". There were around 3000 entries. I selected all and deleted


Actual results:

Firefox froze with high CPU usage. I let it me like this for 5 mins and had to kill it.
From top 

44816  firefox-bin  99.6  08:30.31 25/1 1    193  1419+ 362M+  110M   482M+  458M+  3943M+ 44816 249   running  501  332417+    1784    179672      87230       748269+    244648+    165376+    502 



Expected results:

It should have deleted peacefully and let me continue my work.

Comment 1

[Jithin Emmanuel]

I tried again an ran for 15 mins and this time it did finish.

Comment 2

[(mostly gone) XtC4UaLL [:xtc4uall]]

Maybe Database Corruption?

You can run

Components.utils.import("resource://gre/modules/PlacesDBUtils.jsm"); PlacesDBUtils.checkAndFixDatabase();

in the Error Console and see if the Database is okay.

Comment 3

[Marco Bonardo [:mak]]

Which version of Firefox are we talking about?

Comment 4

[Jithin Emmanuel]

Database is fine. I am using Firefox 6. As I mentioned in comment 1 the operation did finish though it took some 15-20 mins. Is that normal for roughly 3000 entries.
Also all these entries were searched for a particular keyword and then deleted.

Comment 5

[Marco Bonardo [:mak]]

Well, you are not just removing 3000 entries, since each of them has multiple visits attached, it may have been more than 10 thousands... But this should still not block clearly!

Btw I'd first like to understand first what made you think history was slowing down your browser. Ideally there should be no need for the user to clean manually, what are your computer specs?
could you install this addon https://addons.mozilla.org/en-US/firefox/addon/places-maintenance/ and give me output of a "statistics" test?

Comment 6

[Marco Bonardo [:mak]]

I suspect the fact you had a search open may have slowdown things too, since at each removal it's likely the view was updated and the searchterm matched again.

Comment 7

[Jithin Emmanuel]

The output looks same as what I encountered when I ran the command mentioned in comment 2.

> Integrity check
+ The database is sane
> Reindex
+ The database has been reindexed
> Orphans expiration
+ Database cleaned up
> Coherence check
+ The database is coherent
> Vacuum
Initial database size is 51200 KiB
+ The database has been vacuumed
Final database size is 51200 KiB
> Statistics
Database size is 51200 KiB
user_version is 11
page_size is 32768
cache_size is 7372
journal_mode is wal
synchronous is 1
History can store a maximum of 120795 unique pages
Table moz_places has 73644 records
Table moz_historyvisits has 102352 records
Table moz_inputhistory has 871 records
Table moz_bookmarks has 558 records
Table moz_bookmarks_roots has 5 records
Table moz_keywords has 14 records
Table sqlite_sequence has 2 records
Table moz_favicons has 1590 records
Table moz_annos has 19 records
Table moz_anno_attributes has 9 records
Table moz_items_annos has 72 records
Table sqlite_stat1 has 15 records
Table moz_jump_tracker has 841 records
Index sqlite_autoindex_moz_inputhistory_1
Index sqlite_autoindex_moz_bookmarks_roots_1
Index sqlite_autoindex_moz_keywords_1
Index sqlite_autoindex_moz_favicons_1
Index sqlite_autoindex_moz_anno_attributes_1
Index moz_places_faviconindex
Index moz_places_hostindex
Index moz_places_visitcount
Index moz_places_frecencyindex
Index moz_places_lastvisitdateindex
Index moz_historyvisits_placedateindex
Index moz_historyvisits_fromindex
Index moz_historyvisits_dateindex
Index moz_bookmarks_itemindex
Index moz_bookmarks_parentindex
Index moz_bookmarks_itemlastmodifiedindex
Index moz_places_url_uniqueindex
Index moz_places_guid_uniqueindex
Index moz_bookmarks_guid_uniqueindex
Index moz_annos_placeattributeindex
Index moz_items_annos_itemattributeindex
Trigger moz_bookmarks_beforedelete_v1_trigger