User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:220.127.116.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:18.104.22.168pre) 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.
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.
updating to : Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:22.214.171.124pre) Gecko/20090914 Shredder/3.0b4pre has fixed the issue.