Arch Linux

firefox-esr 68.4.2 works well here too. Please report this to the sqlite devs upstream and look out for a fix.

I confirm the issue, there is also a thread on the sqlite-users mailing list: https://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/msg118698.html There is no complete bisect yet, but at least a pointer to a Mozilla bug report that has some more information: https://bugzilla.mozilla.org/show_bug.cgi?id=1607902

Experiencing this issue as well. Firefox Developer 73b08 (from firefox-developer-edition package) launches fine on both.

Firefox uses a bundled sqlite. Thunderbird could be switched to use the bundled sqlite temporarily.

https://hg.mozilla.org/try/rev/8d7104bac33729b4da67954b07fb08371df39bd8 possible fix for firefox could be adapted to thunderbird.

There is a patch for this at https://github.com/OpenMandrivaAssociation/thunderbird/blob/master/thunderbird-68.4.1-sqlite-3.31.patch

Since this seems to be a bug in Thunderbird rather than in SQLite, this bug should probably be reassigned to anthraxx.

It looks like Thunderbird itself is not going to be patched (at least in the short term).

This commit was introduced in sqlite today to fix this.
https://github.com/sqlite/sqlite/commit/532b0d23fd80082a8706ec683b1c7afed26ee6c4

It looks like Debian is going the route of applying this commit ^ to sqllite rather than modifying thunderbird.

I've just tested an sqlite package built from fossil checkout 34ab760689fd493eda482e856047708d74e769a01cc90b69da456d79ffe39aea, and it solves the issue for me (tested with thunderbird 68.4.2-1).

The sqlite developer who has written/committed the above mentioned fix in sqlite's fossil tree has explicitly asked for feedback about whether his fix works, so he can push out a new sqlite release ASAP. Would be nice if more people could test this and provide him with feedback here:

https://bugzilla.mozilla.org/show_bug.cgi?id=1607902#c21

Here's a PKGBUILD (based upon the PKGBUILD of the original sqlite 3.31.0-1 package from the testing repository) that can be used to build your own sqlite package with upstream's fix included.

Just make sure you have the "devtools" package installed, then put the PKGBUILD into an empty directory, cd into the directory and run "testing-x86_64-build -c" as normal user (you will be asked for your sudo password in the process). Building the sqlite package group took less than 5 minutes on my laptop, but this may slightly vary depending on your hardware.

Please give feedback as to whether the fix works for you or not:

https://bugzilla.mozilla.org/show_bug.cgi?id=1607902#c21

Thunderbird does appear to work with sqlite built from the attached PKGBUILD - thanks for putting that together.

Looks like sqlite 3.31.1 has already been tagged and should soon be out.

With sqlite 3.31.1-1 thunderbird no longer segfaults on my end, cheers!
EDIT: I totally fucked up with the closure request and copied the wrong line, shame on me..