Public bug reported:
Ubuntu version:
Description: Ubuntu 24.04.1 LTS
Release: 24.04
Package version:
libsqlite3-0:
Installed: 3.45.1-1ubuntu2
Candidate: 3.45.1-1ubuntu2
Version table:
*** 3.45.1-1ubuntu2 500
500 http://archive.ubuntu.com/ubuntu noble/main amd64 Packages
100 /var/lib/dpkg/status
libsqlite3 segfaults on running a particular query (which has not caused
a problem in previous releases of SQLite). It appears to be related to
having multiple "JOIN" statements in the query since removing one of
them does not show the problem but could equally be something else it
doesn't like about this particular query.
Steps to reproduce:
1. Create the database (using attached schema):
sqlite3 audio.db < sql-audio280.txt
2. Run query as follows:
sqlite3 audio.db "SELECT Song.SongTitle, Song.Duration, Song.CueStart,
Song.CueEnd,Song.NormaliseRLeft, Song.NormaliseRRight,
Song.FileDirectory, Song.FileName, Song.SongID,Artist.ArtistID,
Artist.ArtistName, Genre.GenreID, Genre.Genre, Album.AlbumID,
Album.AlbumTitle,Song.Year, Song.Notes, Song.Highlight, Song.Highlight2,
Song.ReplayGain, Song.ReplayGainSet FROM(Album INNER JOIN(Artist INNER
JOIN(Genre INNER JOIN Song ON Genre.GenreID = Song.GenreID) ON
Artist.ArtistID = Song.ArtistID) ON Album.AlbumID = Song.AlbumID);"
Result is consistently a segfault. Backtrace from gdb:
Program received signal SIGSEGV, Segmentation fault.
__strlen_avx2 () at ../sysdeps/x86_64/multiarch/strlen-avx2.S:76
warning: 76 ../sysdeps/x86_64/multiarch/strlen-avx2.S: No such file or
directory
(gdb) bt
#0 __strlen_avx2 () at ../sysdeps/x86_64/multiarch/strlen-avx2.S:76
#1 0x00007f0bc38c26e4 in sqlite3DbStrDup () from
/lib/x86_64-linux-gnu/libsqlite3.so.0
#2 0x00007f0bc38f2ef4 in ?? () from /lib/x86_64-linux-gnu/libsqlite3.so.0
#3 0x00007f0bc391c1be in sqlite3WalkSelect () from
/lib/x86_64-linux-gnu/libsqlite3.so.0
#4 0x00007f0bc38f1e6d in ?? () from /lib/x86_64-linux-gnu/libsqlite3.so.0
** Affects: sqlite3 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Touch seeded packages, which is subscribed to sqlite3 in Ubuntu.
https://bugs.launchpad.net/bugs/2087772
Title:
crash (segfault) in libsqlite3 running multi-join query
Status in sqlite3 package in Ubuntu:
New
Bug description:
Ubuntu version:
Description: Ubuntu 24.04.1 LTS
Release: 24.04
Package version:
libsqlite3-0:
Installed: 3.45.1-1ubuntu2
Candidate: 3.45.1-1ubuntu2
Version table:
*** 3.45.1-1ubuntu2 500
500 http://archive.ubuntu.com/ubuntu noble/main amd64 Packages
100 /var/lib/dpkg/status
libsqlite3 segfaults on running a particular query (which has not
caused a problem in previous releases of SQLite). It appears to be
related to having multiple "JOIN" statements in the query since
removing one of them does not show the problem but could equally be
something else it doesn't like about this particular query.
Steps to reproduce:
1. Create the database (using attached schema):
sqlite3 audio.db < sql-audio280.txt
2. Run query as follows:
sqlite3 audio.db "SELECT Song.SongTitle, Song.Duration, Song.CueStart,
Song.CueEnd,Song.NormaliseRLeft, Song.NormaliseRRight,
Song.FileDirectory, Song.FileName, Song.SongID,Artist.ArtistID,
Artist.ArtistName, Genre.GenreID, Genre.Genre, Album.AlbumID,
Album.AlbumTitle,Song.Year, Song.Notes, Song.Highlight,
Song.Highlight2, Song.ReplayGain, Song.ReplayGainSet FROM(Album INNER
JOIN(Artist INNER JOIN(Genre INNER JOIN Song ON Genre.GenreID =
Song.GenreID) ON Artist.ArtistID = Song.ArtistID) ON Album.AlbumID =
Song.AlbumID);"
Result is consistently a segfault. Backtrace from gdb:
Program received signal SIGSEGV, Segmentation fault.
__strlen_avx2 () at ../sysdeps/x86_64/multiarch/strlen-avx2.S:76
warning: 76 ../sysdeps/x86_64/multiarch/strlen-avx2.S: No such file or
directory
(gdb) bt
#0 __strlen_avx2 () at ../sysdeps/x86_64/multiarch/strlen-avx2.S:76
#1 0x00007f0bc38c26e4 in sqlite3DbStrDup () from
/lib/x86_64-linux-gnu/libsqlite3.so.0
#2 0x00007f0bc38f2ef4 in ?? () from /lib/x86_64-linux-gnu/libsqlite3.so.0
#3 0x00007f0bc391c1be in sqlite3WalkSelect () from
/lib/x86_64-linux-gnu/libsqlite3.so.0
#4 0x00007f0bc38f1e6d in ?? () from /lib/x86_64-linux-gnu/libsqlite3.so.0
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/2087772/+subscriptions
--
Mailing list: https://launchpad.net/~touch-packages
Post to : touch-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~touch-packages
More help : https://help.launchpad.net/ListHelp
