kzsigo
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Marc Z
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.
ASKER
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).
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).
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.
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.
ASKER
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.
kzsigo,
Have you considered a split of points, perhaps?
Have you considered a split of points, perhaps?
ASKER
Okay, the points can be split. Please award 125 points to mtz1of4 for his efforts & close this question.
ASKER
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.
ASKER
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?
ASKER
This answer gave me info, but wasn't exactly a solution. Thanks again mtz1of4!