Sqlite 3.31.0 breaks firefox and thunderbird

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Sqlite 3.31.0 breaks firefox and thunderbird

Bernhard Rosenkraenzer
Hi,
after updating sqlite to 3.31.0, both firefox and thunderbird crash on startup (rebuilding them against the newer sqlite doesn't help).
Backtrace:
(gdb) bt
#0  0x00007ffff1b9fe20 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#1  0x00007ffff1b993d2 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#2  0x00007fffef3afdf5 in pagerOpenWal () from /usr/lib64/libsqlite3.so.0
#3  0x00007fffef398e76 in sqlite3BtreeBeginTrans () from /usr/lib64/libsqlite3.so.0
#4  0x00007fffef3ed074 in sqlite3InitOne () from /usr/lib64/libsqlite3.so.0
#5  0x00007fffef3f105e in sqlite3Pragma () from /usr/lib64/libsqlite3.so.0
#6  0x00007fffef3b44ea in yy_reduce () from /usr/lib64/libsqlite3.so.0
#7  0x00007fffef397df0 in sqlite3RunParser () from /usr/lib64/libsqlite3.so.0
#8  0x00007fffef3968a9 in sqlite3Prepare () from /usr/lib64/libsqlite3.so.0
#9  0x00007fffef396171 in sqlite3LockAndPrepare () from /usr/lib64/libsqlite3.so.0
#10 0x00007fffef3881cf in sqlite3_exec () from /usr/lib64/libsqlite3.so.0
#11 0x00007ffff1b93ddc in ?? () from /usr/lib64/firefox-71.0/libxul.so
#12 0x00007ffff1b934a4 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#13 0x00007ffff1b938eb in ?? () from /usr/lib64/firefox-71.0/libxul.so
#14 0x00007ffff1ba2be2 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#15 0x00007ffff1626619 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#16 0x00007ffff16347b8 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#17 0x00007ffff1530f1f in ?? () from /usr/lib64/firefox-71.0/libxul.so
#18 0x00007ffff1533006 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#19 0x00007ffff18a5dca in ?? () from /usr/lib64/firefox-71.0/libxul.so
#20 0x00007ffff18757b8 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#21 0x00007ffff152f0b5 in ?? () from /usr/lib64/firefox-71.0/libxul.so
#22 0x00007ffff77f6979 in ?? () from /lib64/libnspr4.so
#23 0x00007ffff7f8a031 in start_thread () from /lib64/libpthread.so.0
#24 0x00007ffff7b6f4df in clone () from /lib64/libc.so.6

The Debian guys have also observed this:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=949644
(and also don't have a fix yet).

Any ideas?

Best regards
bero

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Sqlite 3.31.0 breaks firefox and thunderbird

Richard Hipp-3
On 1/23/20, Bernhard Rosenkraenzer <[hidden email]> wrote:
> Hi,
> after updating sqlite to 3.31.0, both firefox and thunderbird crash on
> startup (rebuilding them against the newer sqlite doesn't help).

Is this related to https://bugzilla.mozilla.org/show_bug.cgi?id=1607902

> Backtrace:
> (gdb) bt
> #0  0x00007ffff1b9fe20 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #1  0x00007ffff1b993d2 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #2  0x00007fffef3afdf5 in pagerOpenWal () from /usr/lib64/libsqlite3.so.0
> #3  0x00007fffef398e76 in sqlite3BtreeBeginTrans () from
> /usr/lib64/libsqlite3.so.0
> #4  0x00007fffef3ed074 in sqlite3InitOne () from /usr/lib64/libsqlite3.so.0
> #5  0x00007fffef3f105e in sqlite3Pragma () from /usr/lib64/libsqlite3.so.0
> #6  0x00007fffef3b44ea in yy_reduce () from /usr/lib64/libsqlite3.so.0
> #7  0x00007fffef397df0 in sqlite3RunParser () from
> /usr/lib64/libsqlite3.so.0
> #8  0x00007fffef3968a9 in sqlite3Prepare () from /usr/lib64/libsqlite3.so.0
> #9  0x00007fffef396171 in sqlite3LockAndPrepare () from
> /usr/lib64/libsqlite3.so.0
> #10 0x00007fffef3881cf in sqlite3_exec () from /usr/lib64/libsqlite3.so.0
> #11 0x00007ffff1b93ddc in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #12 0x00007ffff1b934a4 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #13 0x00007ffff1b938eb in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #14 0x00007ffff1ba2be2 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #15 0x00007ffff1626619 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #16 0x00007ffff16347b8 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #17 0x00007ffff1530f1f in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #18 0x00007ffff1533006 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #19 0x00007ffff18a5dca in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #20 0x00007ffff18757b8 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #21 0x00007ffff152f0b5 in ?? () from /usr/lib64/firefox-71.0/libxul.so
> #22 0x00007ffff77f6979 in ?? () from /lib64/libnspr4.so
> #23 0x00007ffff7f8a031 in start_thread () from /lib64/libpthread.so.0
> #24 0x00007ffff7b6f4df in clone () from /lib64/libc.so.6
>
> The Debian guys have also observed this:
> https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=949644
> (and also don't have a fix yet).
>
> Any ideas?
>
> Best regards
> bero
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Sqlite 3.31.0 breaks firefox and thunderbird

Warren Young
In reply to this post by Bernhard Rosenkraenzer
On Jan 23, 2020, at 8:33 AM, Bernhard Rosenkraenzer <[hidden email]> wrote:
>
> The Debian guys have also observed this:
> https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=949644
> (and also don't have a fix yet).
>
> Any ideas?

Can you bisect SQLite to narrow the range here?  This release had an unusually long period to cook, so without a bisect, you’re kind of asking for someone to remember what they changed months ago.

Method:

1. Check out SQLite source from Fossil: https://sqlite.org/src/

2. fossil bisect reset ; fossil bisect bad   (marks tip-of-trunk as “bad”)

3. fossil bisect good version-3.30.1   (or whatever version you last tested as “good”)

At that point, the source tree will contain a version halfway between tip-of-trunk and the version you marked “good” with the third command.  Build it, test it, then say either “fossil bisect bad” or “fossil bisect good” depending on whether it crashes again.

By my count, there have been 551 checkins between those two releases, so a bisect should take roughly 9 tries to find the culprit:

$ fossil timeline after version-3.30.1 -t ci -n 0 | grep -c '^[0-9]'
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Sqlite 3.31.0 breaks firefox and thunderbird

Ferdinand
Thank you for the suggestion, Warren.

Bisect first pointed to commit df51ae19c1aa4c26, but sometime after that this segfault seemed to be fixed, a second bisect blamed commit 2ae77bd233570834:

https://www.sqlite.org/src/info/2ae77bd233570834

I've attached a backtrace from a crash at this commit.

Cheers,
Ferdinand

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

backtrace (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: ?==?utf-8?q? Sqlite 3.31.0 breaks firefox and thunderbird

Bernhard Rosenkraenzer
In reply to this post by Richard Hipp-3
On Thursday, January 23, 2020 17:00 CET, Richard Hipp <[hidden email]> wrote:
 
> On 1/23/20, Bernhard Rosenkraenzer <[hidden email]> wrote:
> > Hi,
> > after updating sqlite to 3.31.0, both firefox and thunderbird crash on
> > startup (rebuilding them against the newer sqlite doesn't help).
>
> Is this related to https://bugzilla.mozilla.org/show_bug.cgi?id=1607902

Hi,
thanks for the pointer - it's indeed caused by that, and the fix mentioned there works (after some tweaking to make it apply on top of current firefox and thunderbird releases).

If anyone needs it, here's the fix adapted to current firefox and thunderbird releases.
https://github.com/OpenMandrivaAssociation/firefox/blob/master/firefox-72.0.2-sqlite-3.31.patch
https://github.com/OpenMandrivaAssociation/thunderbird/blob/master/thunderbird-68.4.1-sqlite-3.31.patch

ttyl
bero

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users