1426632 - Global Search Messages no longer works because of sqlite dependency with linux. Blanks search results and TypeError: nounDef is undefined

Status: RESOLVED INVALID

(Thunderbird :: Search, defect)

Description

[patrick]

User Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:57.0) Gecko/20100101 Firefox/57.0
Build ID: 20171203111003

Steps to reproduce:

Typed in a keyword and clicked on a search.


Actual results:

A new blank search panel opened, there were no search results. The console logged the following error:

TypeError: nounDef is undefined                                                                                                                                                                                                                                                                                             
-- Exception object --                                                                                                                                                                                                                                                                                                      
*                                                                                                                                                                                                                                                                                                                           
-- Stack Trace --                                                                                                                                                                                                                                                                                                           
gloda_ns_newQuery@resource:///modules/gloda/gloda.js:1901:5                                                                                                                                                                                                                                                                 
GlodaMsgSearcher_buildFulltextQuery@resource:///modules/gloda/msg_search.js:260:17                                                                                                                                                                                                                                          
GlodaMsgSearcher_getCollection@resource:///modules/gloda/msg_search.js:306:18                                                                                                                                                                                                                                               
glodaFacetTabType_openTab@chrome://messenger/content/glodaFacetTab.js:50:25                                                                                                                                                                                                                                                 
openTab@chrome://messenger/content/tabmail.xml:565:11                                                                                                                                                                                                                                                                       
doSearch@chrome://messenger/content/search.xml:248:15                                                                                                                                                                                                                                                                       



Expected results:

The panel displays the search results and no errors appear in the console

Comment 1

[patrick]

This problem has been there for some time, but I never got round to reporting it. My current thunderbird version is 52.5.0 (64 bit). I tried deleting the search index file
global-messages-db.sqlite
It was never rebuilt.

I tried creating a new profile, downloading all my messages. The same issue occurred, note the search index file was created but is empty (0 size).

Comment 2

[Jorg K (CEST = GMT+2)]

Very unusual. You're on FreeBSD. That platform isn't officially supported and it looks like you have a faulty build:
   TypeError: nounDef is undefined

Comment 3

[patrick]

It used to work. I built it from the ports collection, does that means it is supported by FreeBSD?

Comment 4

[Wayne Mery (:wsmwk)]

(In reply to patrick from comment #3)
> It used to work. I built it from the ports collection, does that means it is
> supported by FreeBSD?

URL?

It does sound like it is not our problem

Comment 5

[patrick]

I have reported this with FreeBSD at

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=224968

Comment 6

[patrick]

Seems like my sqlite install did not have the FTS3 extension. This is what caused the problem. After I reinstalled sqlite with this extension it all works.

I'm not sure how often this is likely to affect people (my install is pretty unique), but it would be nice if thunderbird gave a more explicit error when this happens. If the error had mentioned that sqlite was missing the FTS3 extension I would probably have been able to figure out the issue myself.

Thanks to everyone for responding to my bug report.

Comment 7

[Wayne Mery (:wsmwk)]

Patrick, thanks for the feedback.

Ryan has an interest in dependencies which break linux users.  I could swear there are other bug reports, like sqlite version conflicts, but I can't find them just now.  Perhaps they are filed in the toolkit storage component.