Segmentation fault with sqlite 3.8.x

[Vamp898]

When i search for an Kanji and click on the result, tagainijisho crashes with an segfault

Example:

1. Open Tagaini
2. Filter for Characters
3. Go to JLPT
4. Cross N5
5. Click on any Kanji, for example 国
6. It crashes

Here is the backtrace

#0 0x00007ffff66d041f in sqlite3VdbeExec () from /usr/lib64/libsqlite3.so.0
#1 0x00007ffff66d59b8 in sqlite3_step () from /usr/lib64/libsqlite3.so.0
#2 0x00000000005566b8 in SQLite::Query::exec() ()
#3 0x0000000000537f96 in ASyncQuery::process() ()
#4 0x000000000053863e in ThreadedDatabaseConnection::processQueries() ()
#5 0x00007ffff6ab2c3e in QObject::event(QEvent*) () from /usr/lib64/qt4/libQtCore.so.4
#6 0x00007ffff73101cc in QApplicationPrivate::notify_helper(QObject*, QEvent*) () from /usr/lib64/qt4/libQtGui.so.4
#7 0x00007ffff7312662 in QApplication::notify(QObject*, QEvent*) () from /usr/lib64/qt4/libQtGui.so.4
#8 0x00007ffff6a996ed in QCoreApplication::notifyInternal(QObject*, QEvent*) () from /usr/lib64/qt4/libQtCore.so.4
#9 0x00007ffff6a9cba8 in QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) () from /usr/lib64/qt4/libQtCore.so.4
#10 0x00007ffff6ac7193 in postEventSourceDispatch(_GSource*, int (*)(void*), void*) () from /usr/lib64/qt4/libQtCore.so.4
#11 0x00007ffff5ccf514 in g_main_context_dispatch () from /usr/lib64/libglib-2.0.so.0
#12 0x00007ffff5ccf870 in g_main_context_iterate.isra.22 () from /usr/lib64/libglib-2.0.so.0
#13 0x00007ffff5ccf92c in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0
#14 0x00007ffff6ac732e in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4
#15 0x00007ffff6a9834f in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4
#16 0x00007ffff6a98630 in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4
#17 0x00007ffff699e2c0 in QThread::exec() () from /usr/lib64/qt4/libQtCore.so.4
#18 0x000000000053892d in DatabaseThread::run() ()
#19 0x00007ffff69a0a7c in QThreadPrivate::start(void*) () from /usr/lib64/qt4/libQtCore.so.4
#20 0x00007ffff5a7101b in start_thread () from /lib64/libpthread.so.0
#21 0x00007ffff609cdad in clone () from /lib64/libc.so.6

[Vamp898 (vamp898-ignaz)]

Ive seen several bugs for segmentation faults (for example in VLC or amarok) when Qt is compiled with glib support and this backtrace also looks like it have to do with the Glib stuff.

I compile again without glib support and re-check

[Vamp898 (vamp898-ignaz)]

Nope, backtrace looks a bit different but still crashes

#0 0x00007ffff66d741f in sqlite3VdbeExec () from /usr/lib64/libsqlite3.so.0
#1 0x00007ffff66dc9b8 in sqlite3_step () from /usr/lib64/libsqlite3.so.0
#2 0x00000000005566b8 in SQLite::Query::exec() ()
#3 0x0000000000537f96 in ASyncQuery::process() ()
#4 0x000000000053863e in ThreadedDatabaseConnection::processQueries() ()
#5 0x00007ffff6ab73de in QObject::event(QEvent*) () from /usr/lib64/qt4/libQtCore.so.4
#6 0x00007ffff7310f8c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () from /usr/lib64/qt4/libQtGui.so.4
#7 0x00007ffff7313422 in QApplication::notify(QObject*, QEvent*) () from /usr/lib64/qt4/libQtGui.so.4
#8 0x00007ffff6a9de8d in QCoreApplication::notifyInternal(QObject*, QEvent*) () from /usr/lib64/qt4/libQtCore.so.4
#9 0x00007ffff6aa1348 in QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) () from /usr/lib64/qt4/libQtCore.so.4
#10 0x00007ffff6acd2cf in QEventDispatcherUNIX::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4
#11 0x00007ffff6a9cb4f in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4
#12 0x00007ffff6a9ce30 in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4
#13 0x00007ffff69a2ba0 in QThread::exec() () from /usr/lib64/qt4/libQtCore.so.4
#14 0x000000000053892d in DatabaseThread::run() ()
#15 0x00007ffff69a527c in QThreadPrivate::start(void*) () from /usr/lib64/qt4/libQtCore.so.4
#16 0x00007ffff5da201b in start_thread () from /lib64/libpthread.so.0
#17 0x00007ffff60a3dad in clone () from /lib64/libc.so.6

[Vamp898 (vamp898-ignaz)]

Ok i got it, its because sqlite 3.8.0

If i downgrade sqlite to 3.7.17 no segmentation fault appears

[Gnurou (gnurou)]

Noticed that too while preparing 1.0.0. This is very likely a bug with SQLite. I have blacklisted this version to start. You can pass -DEMBED_SQLITE=1 to CMake to make compilation against a embedded 3.7.x version of SQLite.

I will try to report this upstream to SQLite. Also please note that bugs should now be reported on github, as launchpad is not used anymore: https://github.com/Gnurou/tagainijisho/issues