[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4289
  • Last Modified:

Huge SQLite files in Firefox profiles

I'm the IT manager for a company of about 35 users.  We use Folder Redirection (group policy on Win2003 Servers) for users My Docs, App Data, and Desktop.

I recently noticed space getting eaten up at a rapid pace so I started investigating and found the culprit to be HUGE SQLite files in a few users Firefox profile folders.

I have already deleted them, but I wanted to post this here so people could help me figure out why it's happening.

The two files were SEARCH.SQLITE and URLCLASSIFIER2.SQLITE.

This only occurred with 4 of my users...no one else seemed to be affected.  On two of the profiles the search.sqlite file was huge, and the on the other two profiles, the urlclassifier2.sqlite file was huge.

When I say huge I mean hundreds of Gigs.  The four files I deleted were a total of 1.4 Terabytes!  The files were about 600gb, 300gb, 300gb, and 200gb.

Like I said, I just simply deleted them but wanted to post this here to begin a discussion about it because I didn't find ANY info on this subject on Google.
0
kzsigo
Asked:
kzsigo
  • 6
  • 5
1 Solution
 
Marc ZCommented:
Actually, the search.sqlite file has Information about the Search Plug-ins that that user has installed.
And the urlclassifier2.sqlite holds the info about the known Phishing Sites.
http://kb.mozillazine.org/Urlclassifier2.sqlite  <<< lots of good info there.

So, chances are they used quite a few custom Search Plug-ins, although my search.sqlite is only 8 kb. And my urlclassifier2.sqlite is only 4.62 MB.

1.4 Terabytes!?!?!?  Sounds like it can't update itself, but keeps adding to it.
0
 
Marc ZCommented:
One of the things you could try is to turn off the phishing filters in Tools->Options->Security and turn off the "Tell me if the site I am visiting is a suspected forgery" or change the options below it.
0
 
kzsigoAuthor Commented:
Thank you mtz1of4.

The link you listed gives me the information I need on the urlclassifier.sqlite, so thank you.  However, I'm going to keep this discussion open for awhile to see if we can get people who have had a similar problem or know the exact cause or a solution (like is it a bug).
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Marc ZCommented:
Your welcome.  If you see this continuously happening, perhaps you could help the developers.

I noticed this https://bugzilla.mozilla.org/show_bug.cgi?id=359145 regarding the Moving of the urlclassifier2.sqlite file. Unfortunately it doesn't mention the sizes you are discussing.
It sounds like they may have it fixed for Firefox 3, though.  And, you might want to make sure you are up to date on the latest version anyway.
0
 
kzsigoAuthor Commented:
This isn't exactly a solution, but I just ended up deleting the files & they haven't come back yet...also no one else has added to this topic saying that they had the same issue, so we'll just say the solution is to delete the files.  The links above from mtz1of4 give good info as to what the files are.
0
 
Marc ZCommented:
kzsigo,

Have you considered  a split of points, perhaps?
0
 
kzsigoAuthor Commented:
Okay, the points can be split.  Please award 125 points to mtz1of4 for his efforts & close this question.
0
 
Marc ZCommented:
Computer101,

I believe he would like a split.  See
 http:/Q_23123204.html#a21408163
0
 
kzsigoAuthor Commented:
yes i do, but the system won't let me award points to you & me.  It will let me split them between two other people, but not between myself & someone else.
0
 
kzsigoAuthor Commented:
I don't want to award myself points for a correct answer.  I want to refund half of my questions back to my account & award half of the points to mtz1of4.  How is that done?
0
 
kzsigoAuthor Commented:
This answer gave me info, but wasn't exactly a solution.  Thanks again mtz1of4!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now