494272 - Toolbars Internet Search stops working: formhistory.sqlite gets corrupted after standby

Status: RESOLVED INCOMPLETE

(Toolkit :: Form Manager, defect)

Description

[Daniel]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)

It happens often that I can't start the search by the toolbars internet search function in the top right corner of Firefox (before entering a search term of course), neither with return-key or by clicking on the magnifying glass.
It doesn't matter which searchenigne is selected, so its completely unusable.

Reproducible: Sometimes

Steps to Reproduce:
I found out: it happens every time when I leave Firefox open while I taking a  break being away from my PC and returning back after ~10min, when I move my mouse or press some key the pc has to return first from it's powersaving mode (default Windows 7 settings), the harddisks begin to spin up and screen turns on. Starting from this moment the search-function is broken, not always but often. Reopening Firefox doesn't' fix it.

I didn't had this issue on versions < Windows 7 (2000/XP) on the same pc so it has something to how Windows 7 powersaving-mode is handled by Firefox. I tried disabling the function for turn off the harddisks in Windows 7, but it didn't help.
Actual Results:  
It doesn't start the search, no error message.

Expected Results:  
You know what should happen when I press the magnifier glass ;)

My Firefox Profiles are saved on the same partition than Firefox, but Firefox and the profiles are not on the same harddisk than Windows 7.
-Firefox and profiles are saved on a IDE harddisk within the same NTFS partition.
-Windows 7 on SATA HDD with NTFS.

As workaround closing Firefox and deleting formhistory.sqlite does fix this problem always, until the failure happens again on next break I take.

So it seems formhistory.sqlite gets corrupted when Windows 7 gets into Powersaving-Mode and this is the reason the search function stops working.

If I could attach formhistory.sqlite you could see whats going wrong.

Comment 1

[Daniel]

I uploaded both, the corrupted file formhistory.sqlite.corrupt and a working fresh one formhistory.sqlite to my webspace so you can analyze why the the corrupted one is not working and take steps against corrupting them or handle it right:

http://x-coder.de/formhistory.sqlite.corrupt
http://x-coder.de/formhistory.sqlite

Comment 2

[Henrik Skupin [:whimboo][⌚️UTC+2]]

Daniel, the the corrupt file really corrupt? For me it works fine with the following steps:

1. Create a fresh profile and start once
2. Close Firefox and replace formhistory.sqlite with the corrupt one
3. Start Firefox
4. Press Cmd/Ctrl+K, enter a search term and press Enter

It always starts a search with Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)

Can you please try those steps on your own?

Comment 3

[Daniel]

You are right, the file seems to be ok now, I tested it now without creating a new profile. Odd, I checked it twice before I uploaded it by doing the same steps you described. Tomorrow I will upload a new one.

Comment 4

[Daniel]

I figured out now: If the search is not working and I move formhistory.sqlite out of the profile-dir and open Firefox a new one will be rewritten and the search will be work again.

If I close Firefox and move the "corrupt" formhistory.sqlite back into profile-dir and replace the newly written with the "corrupt" one, the search is still working. So it seems that the corruption is not directly in formhistory.sqlite but it's related to it so deleting formhistory.sqlite causes Firefox to change something in another file which fixes then the bug.

The Question is which file/configuration gets modified too when formhistory.sqlite gets rewritten?

Comment 5

[Henrik Skupin [:whimboo][⌚️UTC+2]]

I cannot answer that for now but lets try the following steps. Create a fresh profile and run it once. After shutdown of Firefox exchange all the files with the ones from the broken profile. Start Firefox with the new profile. Does the problem still occur? If yes, you should try to remove file by file and do restarts in-between to see which file has a side-effect here.

Comment 6

[aravindm]

Please update if you are still experiencing this and did the steps mentioned in comment 5 helped you.

Comment 7

[Daniel]

Copying whole files and subfolders to the new profiles folder fixed the issue for the new profile. I work now with the new profile and will tell you when/if the problem occurs again.

What I don't get is why the new profile will work now with exact the same files than in the broken one. Should the broken search now not be in the new profile because of copying each file into new profiles folder?

Comment 8

[Henrik Skupin [:whimboo][⌚️UTC+2]]

What happens if you copy back all files? Please make a backup of the files in the old profile first.

Comment 9

[Wayne Mery (:wsmwk)]

no feedback from reporter, so => incomplete
if you still see this, please reopen the bug.