updating from Gecko/20090910 to Gecko/20090913 causes 'Search everywhere' to stop working

RESOLVED FIXED

Status

Thunderbird
Search
RESOLVED FIXED
8 years ago
8 years ago

People

(Reporter: Karanbir Singh, Unassigned)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

8 years ago
User-Agent:       Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.0.11) Gecko/2009061613 CentOS/3.0.11-2.el5.centos Firefox/3.0.11
Build Identifier: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.1.4pre) Gecko/20090913 Shredder/3.0b4pre

running nightly builds, with auto updates turned on. 

'Search Everywhere' was turned on automatically with update to 20090910 and the index's were built. Verified working fine. 

However, autoupdate moved me over to 20090913 and this functionality is now broken. The config states:
mailnews.database.global.indexed.enabled | boolean | true

and from the UI, 'Advanced' Tab, in the 'General' section - 'Enable Global Search and Indexer' is selected. I also see :
$ cd ~/.thunderbird/<profile>$ ll | grep 'global.*sqlite'
-rw-r--r--  1 kbsingh kbsingh 2147483648 Sep 14 21:25 global-messages-db.sqlite
-rw-r--r--  1 kbsingh kbsingh     692984 Sep 14 21:25 global-messages-db.sqlite-journal

Reproducible: Always

Steps to Reproduce:
1. Install Gecko/20090910
2. Wait for index's to build
3. Verify 'Search Everywhere' is functional
4. Update to Gecko/20090913
5. Verify 'Search Everywhere' is now non functional
Actual Results:  
Entering any text into the search box, with the search option set to 'Search Everywhere' results in 0 matches. All other search options continue to work. eg. Setting search option to 'Subject Filter' and entering some text, brings up the right results. with the same option set to 'Search Everywhere' no results are found


I've been running the nightly builds for a few months with very little changes to the configs, so should be getting the default changes online. 

Also worth noting is that I've now had a few dozen emails in the last hour or so and the global.*sqlite files do not seem to be updating.
(Reporter)

Comment 1

8 years ago
Opening the file as a db directly in sqlite results in:

$ file global-messages-db.sqlite 
global-messages-db.sqlite: SQLite database (Version 3)

$ sqlite3 global-messages-db.sqlite
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .tables
Error: malformed database schema - near "VIRTUAL": syntax error

is it possible that the db has got itself into a bad shape ? I've tried to look for what the schema of this db should be, and completely failed at finding anything relevant.
(Reporter)

Comment 2

8 years ago
updating to : Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.1.4pre) Gecko/20090914 Shredder/3.0b4pre

has fixed the issue.
Status: UNCONFIRMED → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.