Bug 672068 – =mail-client/thunderbird-60.3.0[system-sqlite] indexing broken ("TypeError: nounDef is undefined" and "TypeError: this.asyncConnection is null")

• Product: Gentoo Linux
• Status: RESOLVED DUPLICATE

[Description Johannes Buchner 2018-11-27 16:49:06 UTC]

Created attachment 556460 [details]
emerge --info output

I have the same problem as reported here:
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=224968

There is some issue with the mail indexing (from IMAP in my case). It re-downloads every time. I reported upstream here: https://bugzilla.mozilla.org/show_bug.cgi?id=1510309

The freebsd bug suggests there may be an issue with the sqlite settings, namely that FTS3_TOKEN=on should be set.

My thunderbird USE flags are: 
dbus pulseaudio startup-notification system-harfbuzz system-icu system-jpeg system-libvpx system-sqlite wifi

Note: system-sqlite -- I guess that may be my problem.

Trying to recompile without it now.

[Comment 1 Johannes Buchner 2018-11-27 17:34:21 UTC]

Thunderbird needs FTS3_TOKENIZER enabled, otherwise the use flag system-sqlite does not work. 

Sqlite 3.11 disabled it by default, that's why this does not work anymore.
( https://www.sqlite.org/releaselog/3_11_0.html says: "Backwards Compatibility:
Because of continuing security concerns, the two-argument version of of the seldom-used and little-known fts3_tokenizer() function is disabled unless SQLite is compiled with the SQLITE_ENABLE_FTS3_TOKENIZER. " )


I am not sure what solution is best. FTS3_TOKENIZER should probably not be enabled by default for all sqlite installs, as sqlite upstream discourages it.

a) remove system-sqlite use flag in thunderbird.
b) add a use flag enabling FTS3_TOKENIZER to sqlite. This flag should then be triggered by thunderbird[system-sqlite].

For myself, I will disable system-sqlite.

[Comment 2 Ian Stakenvicius (RETIRED) 2018-11-28 17:56:12 UTC]

Thank you for looking into this.

I was pushing a pref to disable global-search if system-sqli

te was enabled, but it seems that the effects of this issue goes beyond that now.  Ideally thunderbird and others should stop using FTS3_TOKENIZER, but the bug that indicates development of newer alternatives hasn't seen much movement and shows a rather low priority:  https://bugzilla.mozilla.org/show_bug.cgi?id=1425333

At this point, likely p.u.mask'ing the flag is the best approach until upstream addresses the issue.  We already have problems in the gentoo repo with sqlite's secure-delete flag, I don't want to add another one.

[Comment 3 Arfrever Frehtes Taifersar Arahesis 2018-11-28 21:16:03 UTC]

*** This bug has been marked as a duplicate of bug 583156 ***