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

Status: RESOLVED FIXED

(Thunderbird :: Search, defect)

Description

[Karanbir Singh]

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.

Comment 1

[Karanbir Singh]

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.

Comment 2

[Karanbir Singh]

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.