sqlite3 version 3.8.2 breaks digikam

[b3nmore]

Please update sqlite to a version > 3.8.2.

According to https://bugs.kde.org/show_bug.cgi?id=329697 sqlite3 version 3.8.2 causes crashes in digikam (and possibly other software) in various situations. Several reports confirm, that versions > 3.8.2 fix the issue.
I'm using the 3.8.4.3 package from debian testing right now and can't trigger crashes anymore.

Workaround:
Install sqlite3 > 3.8.2, e.g. you can manually install the corresponding deb packages from either utopic or debian.

[Andrejoh (andrejoh)]

Application: digikam (3.5.0)
KDE Platform Version: 4.11.4
Qt Version: 4.8.5
Operating System: Linux 3.12.6-300.fc20.x86_64 x86_64
Distribution (Platform): Fedora RPMs

-- Information about the crash:
When browsing albums, digiCam crashed. I was able to reproduce it once; it did not seem to be related to a specific album.

The crash can be reproduced sometimes.

-- Backtrace:
Application: digiKam (digikam), signal: Segmentation fault
Using host libthread_db library "/lib64/libthread_db.so.1".
[Current thread is 1 (Thread 0x7eff5fdedac0 (LWP 3182))]

Thread 5 (Thread 0x7eff598bf700 (LWP 3183)):
#0 0x0000003bd4a0eccd in recvmsg () from /lib64/libpthread.so.0
#1 0x0000003bdf208f31 in udev_monitor_receive_device () from /lib64/libudev.so.1
#2 0x0000003bf7c0ec6b in linux_udev_event_thread_main () from /lib64/libusb-1.0.so.0
#3 0x0000003bd4a07f33 in start_thread () from /lib64/libpthread.so.0
#4 0x0000003bd42f4ead in clone () from /lib64/libc.so.6

Thread 4 (Thread 0x7eff52d9c700 (LWP 3184)):
#0 0x0000003bd4a0bd20 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000003bdf67c906 in QWaitCondition::wait(QMutex*, unsigned long) () from /lib64/libQtCore.so.4
#2 0x00000000005e251e in Digikam::ScanController::run() ()
#3 0x0000003bdf67c3df in QThreadPrivate::start(void*) () from /lib64/libQtCore.so.4
#4 0x0000003bd4a07f33 in start_thread () from /lib64/libpthread.so.0
#5 0x0000003bd42f4ead in clone () from /lib64/libc.so.6

Thread 3 (Thread 0x7eff5259b700 (LWP 3185)):
#0 0x0000003bd4a0b1fe in pthread_mutex_unlock () from /lib64/libpthread.so.0
#1 0x0000003bd6a8a5d1 in g_mutex_unlock () from /lib64/libglib-2.0.so.0
#2 0x0000003bd6a494ae in g_main_context_iterate.isra.24 () from /lib64/libglib-2.0.so.0
#3 0x0000003bd6a496dc in g_main_context_iteration () from /lib64/libglib-2.0.so.0
#4 0x0000003bdf7b31a6 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /lib64/libQtCore.so.4
#5 0x0000003bdf78312f in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /lib64/libQtCore.so.4
#6 0x0000003bdf78347d in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /lib64/libQtCore.so.4
#7 0x0000003bdf679bdf in QThread::exec() () from /lib64/libQtCore.so.4
#8 0x0000003bdf763a93 in QInotifyFileSystemWatcherEngine::run() () from /lib64/libQtCore.so.4
#9 0x0000003bdf67c3df in QThreadPrivate::start(void*) () from /lib64/libQtCore.so.4
#10 0x0000003bd4a07f33 in start_thread () from /lib64/libpthread.so.0
#11 0x0000003bd42f4ead in clone () from /lib64/libc.so.6

Thread 2 (Thread 0x7eff51d9a700 (LWP 3187)):
#0 0x0000003bd4a0bd20 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000003bdf67c906 in QWaitCondition::wait(QMutex*, unsigned long) () from /lib64/libQtCore.so.4
#2 0x0000003c0bf6298a in Digikam::ParkingThread::run() () from /lib64/libdigikamcore.so.3
#3 0x0000003bdf67c3df in QThreadPrivate::start(void*) () from /lib64/libQtCore.so.4
#4 0x0000003bd4a07f33 in start_thread () from /lib64/libpthread.so.0
#5 0x0000003bd42f4ead in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7eff5fdedac0 (LWP 3182)):
[KCrash Handler]
#5 0x0000000000000...

[Caulier-gilles-9 (caulier-gilles-9)]

It crash in Qt SQlite plugin. There is no reason for that typically...

Gilles Caulier

[adaptee (adaptee)]

*** Bug 330104 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 330155 has been marked as a duplicate of this bug. ***

[Umvmac (umvmac)]

sorry I'm a new entry for bugtracking system, I would only help tio improve digikam
i use dk with two distro mint16kde and fedora 20 kde, with only one database localized in a separated formatting disk
I use sqlite not mysql
on mint digikam 3.4 go correctly (its seem) but in fedora with the last version 3.5 sometime crash
I have 100.000 photo, two dbase, one for work and one for hobby
when i use the flag or label, when I use workflow, there is not an exact reason or exact moment.
I note that the workflow, also in 3.4 and 3.5 is not perfect
I noticed that the workflow (button B) does not store the actions previously saved, and I have to set it again every time you open the action (conversion to jpeg-resize-watermark ...)
thanks that all
do you think that is bettere to compile youself digikam? or is the same to download from the repo?

[adaptee (adaptee)]

*** Bug 330302 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 330370 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 330633 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 330644 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 330674 has been marked as a duplicate of this bug. ***

[Tpr-3 (tpr-3)]

Crashes here on current master, this happened while trying to open a file to editor window:

Application: digiKam (digikam), signal: Segmentation fault
Using host libthread_db library "/usr/lib/libthread_db.so.1".
[Current thread is 1 (Thread 0x7f6e01e40980 (LWP 684))]

Thread 9 (Thread 0x7f6dd9d2a700 (LWP 689)):
#0 0x00007f6df47b387d in poll () from /usr/lib/libc.so.6
#1 0x00007f6decbe3908 in ?? () from /usr/lib/libusb-1.0.so.0
#2 0x00007f6df99730a2 in start_thread () from /usr/lib/libpthread.so.0
#3 0x00007f6df47bc32d in clone () from /usr/lib/libc.so.6

Thread 8 (Thread 0x7f6dd36ef700 (LWP 690)):
#0 0x00007f6df997703f in pthread_cond_wait@@GLIBC_2.3.2 () from /usr/lib/libpthread.so.0
#1 0x00007f6df55b9aa8 in wait (time=18446744073709551615, this=0x1d4b030) at thread/qwaitcondition_unix.cpp:86
#2 QWaitCondition::wait (this=<optimized out>, mutex=0x1d4af68, time=18446744073709551615) at thread/qwaitcondition_unix.cpp:158
#3 0x0000000000696d41 in Digikam::ScanController::run (this=0x1cf1a50) at /home/tpr/storage/kde/digikam-sc/core/digikam/database/scancontroller.cpp:725
#4 0x00007f6df55b95b5 in QThreadPrivate::start (arg=0x1cf1a50) at thread/qthread_unix.cpp:338
#5 0x00007f6df99730a2 in start_thread () from /usr/lib/libpthread.so.0
#6 0x00007f6df47bc32d in clone () from /usr/lib/libc.so.6

Thread 7 (Thread 0x7f6dd2eee700 (LWP 691)):
#0 0x00007f6df47b387d in poll () from /usr/lib/libc.so.6
#1 0x00007f6df115d584 in ?? () from /usr/lib/libglib-2.0.so.0
#2 0x00007f6df115d68c in g_main_context_iteration () from /usr/lib/libglib-2.0.so.0
#3 0x00007f6df56f5286 in QEventDispatcherGlib::processEvents (this=0x7f6dc40008c0, flags=...) at kernel/qeventdispatcher_glib.cpp:427
#4 0x00007f6df56c3b5f in QEventLoop::processEvents (this=this@entry=0x7f6dd2eedc20, flags=...) at kernel/qeventloop.cpp:149
#5 0x00007f6df56c3e05 in QEventLoop::exec (this=this@entry=0x7f6dd2eedc20, flags=...) at kernel/qeventloop.cpp:204
#6 0x00007f6df55b706d in QThread::exec (this=this@entry=0x1b01060) at thread/qthread.cpp:536
#7 0x00007f6df56a3ce8 in QInotifyFileSystemWatcherEngine::run (this=0x1b01060) at io/qfilesystemwatcher_inotify.cpp:256
#8 0x00007f6df55b95b5 in QThreadPrivate::start (arg=0x1b01060) at thread/qthread_unix.cpp:338
#9 0x00007f6df99730a2 in start_thread () from /usr/lib/libpthread.so.0
#10 0x00007f6df47bc32d in clone () from /usr/lib/libc.so.6

Thread 6 (Thread 0x7f6dd26ed700 (LWP 693)):
#0 0x00007f6df997703f in pthread_cond_wait@@GLIBC_2.3.2 () from /usr/lib/libpthread.so.0
#1 0x00007f6df55b9aa8 in wait (time=18446744073709551615, this=0x1e8d450) at thread/qwaitcondition_unix.cpp:86
#2 QWaitCondition::wait (this=<optimized out>, mutex=0x1e8dbd8, time=18446744073709551615) at thread/qwaitcondition_unix.cpp:158
#3 0x00007f6dfeecd9c0 in Digikam::ParkingThread::run (this=0x1e8dbc0) at /home/tpr/storage/kde/digikam-sc/core/libs/threads/threadmanager.cpp:119
#4 0x00007f6df55b95b5 in QThreadPrivate::start (arg=0x1e8dbc0) at thread/qthread_unix.cpp:338
#5 0x00007f6df99730a2 in start_thread () from /usr/lib/libpthread.so.0
#6 0x00007f6df47bc32d in clone () from /usr/lib/libc.so.6

Thread 5 (Thread 0x7f6dacff9700 (LWP 704)):
#0 0x00007f6df...

[Caulier-gilles-9 (caulier-gilles-9)]

It's not reproducible here...

digiKam version 4.0.0-beta3
Demosaic GPL2 pack support: No
Demosaic GPL3 pack support: No
Exiv2 can write to Jp2: Yes
Exiv2 can write to Jpeg: Yes
Exiv2 can write to Pgf: Yes
Exiv2 can write to Png: Yes
Exiv2 can write to Tiff: Yes
Exiv2 supports XMP metadata: Yes
LibCImg: 130
LibEigen: 3.1.2
LibExiv2: 0.23
LibJPEG: 80
LibJasper: 1.900.1
LibKDE: 4.10.5
LibKExiv2: 2.3.1
LibKGeoMap: 2.0.0
LibKdcraw: 2.4.2
LibLCMS: 2050
LibLensFun: 0.2.6-0
LibPGF: 6.13.45 - internal library
LibPNG: 1.5.13
LibQt: 4.8.5
LibRaw: 0.16.0-Alpha2
LibTIFF: LIBTIFF, Version 4.0.3 Copyright (c) 1988-1996 Sam Leffler Copyright (c) 1991-1996 Silicon Graphics, Inc.
Marble Widget: 0.15.1 (stable version)
Parallelized PGF codec: No
Parallelized demosaicing: Yes
RawSpeed codec support: No
Database backend: QSQLITE
Kipi-Plugins: 4.0.0-beta3
LibGphoto2: 2.5.2
LibKface: 3.0.0
LibKipi: 2.1.0
LibOpenCV: 2.4.3

[adaptee (adaptee)]

*** Bug 331220 has been marked as a duplicate of this bug. ***

[Amair-sob (amair-sob)]

After a recent Gentoo Linux update I also had lots of those crashes. It really drove me nuts because they all happened by simply selecting an image of a folder and it didn't take many clicks (sometimes 2-3 were enough).
Searching the Internet soon showed the right direction: sqlite 3.8

After downgrading sqlite 3.8.2 to 3.7.17 everything is fine again. No more crashes!

So I wonder what sqlite the OP uses.

Best regards,
Andreas

[Andrejoh (andrejoh)]

sqlite-3.8.2-1.fc20.x86_64

[Amair-sob (amair-sob)]

@André Johansen: Already tried to downgrade sqlite to 3.7.17?

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 332100 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333243 has been marked as a duplicate of this bug. ***

[Px79-2 (px79-2)]

I can confirm experiences of Andreas Mair in comment #13:
I also use Gentoo Linux. Since a few weeks, digikam crashes at all kinds of actions: Editing photos, assigning tags, ...

KDE crash handler always lists sqlite:
  Thread 1 (Thread 0x7f6245ec5800 (LWP 1870)):
  [KCrash Handler]
  #6 0x00000000036ed770 in ?? ()
  #7 0x00007f62310d0dae in sqlite3MemCompare (pMem1=<optimized out>, pMem2=0x3ea0728, pColl=0x4a647b8) at sqlite3.c:60468
  #8 0x00007f62310d10dd in sqlite3VdbeRecordCompare (nKey1=18, pKey1=0x7f62242528e9, pPKey2=0x7ffff2e9cbe0) at sqlite3.c:64160
  #9 0x00007f62310f277b in sqlite3BtreeMovetoUnpacked (pRes=<optimized out>, biasRight=<optimized out>, intKey=<optimized out>, pIdxKey=<optimized out>, pCur=<optimized out>) at sqlite3.c:55075
  #10 sqlite3BtreeMovetoUnpacked (pCur=0x42fc920, pIdxKey=0x7ffff2e9cbe0, intKey=0, biasRight=<optimized out>, pRes=0x7ffff2e9cbd0) at sqlite3.c:54960
  #11 0x00007f62310fde0e in sqlite3VdbeExec (p=0xaf72d78) at sqlite3.c:70166
  #12 0x00007f623110645f in sqlite3Step (p=0xaf72d78) at sqlite3.c:64826
  ...

Looking at my emerge.log, I did an update of "dev-db/sqlite-3.7.17" to "dev-db/sqlite-3.8.2" 8 weeks ago.

> After downgrading sqlite 3.8.2 to 3.7.17 everything is fine again. No more crashes!
Thanks for the tip! By today, there is no more "sqlite-3.7.x" in portage tree. So I will try the current top up-to-date version "dev-db/sqlite-3.8.4.3".

[Px79-2 (px79-2)]

I filed a bug report at gentoo's bugtracker, too: https://bugs.gentoo.org/show_bug.cgi?id=507394

[adaptee (adaptee)]

*** Bug 333389 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 333642 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333671 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333660 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333741 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333700 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333791 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333792 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333790 has been marked as a duplicate of this bug. ***

[Pierre-metzner (pierre-metzner)]

Created attachment 86274
New crash information added by DrKonqi

digikam (3.5.0) on KDE Platform 4.13.0 using Qt 4.8.6

- What I was doing when the application crashed:

I add Tags to potos. But digicam crashes als in other situations. I have this problem after the update to Kubuntu 14.04.

-- Backtrace (Reduced):
#6 0x00007fbcf3bc3da9 in sqlite3MemCompare (pMem1=pMem1@entry=0x7fffecb86cf0, pMem2=<optimized out>, pColl=0x8695a98) at sqlite3.c:60484
#7 0x00007fbcf3bc3f63 in sqlite3VdbeRecordCompare (nKey1=17, pKey1=0x7fbcdc342557, pPKey2=pPKey2@entry=0x7fffecb87008) at sqlite3.c:64162
#8 0x00007fbcf3bd8579 in sqlite3BtreeMovetoUnpacked (pCur=0xb3d6418, pIdxKey=0x7fffecb87008, intKey=0, biasRight=<optimized out>, pRes=0x7fffecb86ff0) at sqlite3.c:55077
#9 0x00007fbcf3c00848 in sqlite3VdbeExec (p=p@entry=0xa9dda78) at sqlite3.c:70345
#10 0x00007fbcf3c08ed7 in sqlite3Step (p=0xa9dda78) at sqlite3.c:64828

[Caulier-gilles-9 (caulier-gilles-9)]

It sound like a binary compatibility issue with sqlite package against digiKam (through Qt4 Sqlite plugin). digiKam is not linked to Sqlite directly.

A lots of people report the same problem at the same time. Nothing has changed in digiKam DB interface since a long time. So for me, it's a side effect in packaging, perhaps in Qt4, perhaps in Sqlite, i don't know.

Crash is not reproducible here under Mageia 3 and OSX (through updated macport)

Which Sqlite version is used ?
Which distro is used ?
Which Qt4 version is used ?

Gilles Caulier

[Pierre-metzner (pierre-metzner)]

Dear Gilles Caulier,

thanks for the answer.

I belive it's a problem with the database. When I make changes in the tags, a process starts and after a while DigiKam crashes.

I have installed:
sqlite3 --> 3.8.2 2013-12-06 14:53:30
qt --> 4.8.5
distro --> Kubuntu 14.04

Pierre Metzner

[Marcel-wiesweg (marcel-wiesweg)]

Some users have clearly pointed the problem to an update SQLite 3.7 -> 3.8.
There could be incompatibilities with the Qt SQLite driver, I would not assume that the problem can be in any digikam code - multiple code paths from within digikam lead through the Qt SQL driver to a crash in a common location.
valgrind may or may not give some further information.

[Ki-mech (ki-mech)]

(In reply to comment #30)
Same problem here with versions

$ sqlite3 -version
3.8.2 2013-12-06 14:53:30

Ubuntu 14.04 LTS

libqtcore4 has version 4.8.5

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 333952 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 333953 has been marked as a duplicate of this bug. ***

[adaptee (adaptee)]

*** Bug 333976 has been marked as a duplicate of this bug. ***

[b3nmore (b3nmore)]

I manually added the corresponding issue for digikam (https://bugs.launchpad.net/ubuntu/+source/digikam/+bug/1315932), but it seems, that most reports aggregate on the kde bug tracker.
In order to motivate a rise of the importance level and to show that there are a lot of users affected, I list the duplicates of the above mentioned report until today, which were filed by ubuntu users:
https://bugs.kde.org/show_bug.cgi?id=333243
https://bugs.kde.org/show_bug.cgi?id=333389
https://bugs.kde.org/show_bug.cgi?id=333642
https://bugs.kde.org/show_bug.cgi?id=333671
https://bugs.kde.org/show_bug.cgi?id=333660
https://bugs.kde.org/show_bug.cgi?id=333741
https://bugs.kde.org/show_bug.cgi?id=333700
https://bugs.kde.org/show_bug.cgi?id=333791
https://bugs.kde.org/show_bug.cgi?id=333792
https://bugs.kde.org/show_bug.cgi?id=333790
https://bugs.kde.org/show_bug.cgi?id=333952
https://bugs.kde.org/show_bug.cgi?id=333953
https://bugs.kde.org/show_bug.cgi?id=333976
https://bugs.kde.org/show_bug.cgi?id=334017
https://bugs.kde.org/show_bug.cgi?id=334042
https://bugs.kde.org/show_bug.cgi?id=333787
https://bugs.kde.org/show_bug.cgi?id=334186
https://bugs.kde.org/show_bug.cgi?id=334189
https://bugs.kde.org/show_bug.cgi?id=334310
https://bugs.kde.org/show_bug.cgi?id=334344
https://bugs.kde.org/show_bug.cgi?id=334350
https://bugs.kde.org/show_bug.cgi?id=334443
https://bugs.kde.org/show_bug.cgi?id=334712
https://bugs.kde.org/show_bug.cgi?id=334718
https://bugs.kde.org/show_bug.cgi?id=334852
https://bugs.kde.org/show_bug.cgi?id=334853

[Adam Porter (alphapapa)]

Please fix this in Trusty. It's extremely frustrating to have Digikam crash when I'm in the middle of organizing photos, especially since it's not a bug in Digikam itself. Trusty is going to be around for years, so this really needs to be fixed. And Digikam is probably not the only software crashing because of this issue.

[Adam Porter (alphapapa)]

By the way, since this is a bug, causing crashes, I don't think it's appropriate for this to be marked Wishlist. If the fix happens to be upgrading the minor version, so be it. It's still a bug.

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 344216 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 344299 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 344587 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 345044 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 345402 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 345907 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 347054 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 347107 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 347340 has been marked as a duplicate of this bug. ***

[Benedikt Balian (bnbphotofr)]

Created attachment 92487
New crash information added by DrKonqi

digikam (4.0.0) on KDE Platform 4.14.2 using Qt 4.8.6

- What I was doing when the application crashed:

Upon selecting a new album digiKam crashes 5 times out of 10. This happens especially when the album I just selected is stil generating thumbnails.

-- Backtrace (Reduced):
#6 0x00007f9ac91d0da9 in sqlite3MemCompare (pMem1=pMem1@entry=0x7fff2e5c2b90, pMem2=<optimized out>, pColl=0x137c098) at sqlite3.c:60484
#7 0x00007f9ac91d0f63 in sqlite3VdbeRecordCompare (nKey1=18, pKey1=0x7f9ab411c1af, pPKey2=pPKey2@entry=0x7fff2e5c2e90) at sqlite3.c:64162
#8 0x00007f9ac91e5579 in sqlite3BtreeMovetoUnpacked (pCur=0x430c220, pIdxKey=0x7fff2e5c2e90, intKey=0, biasRight=<optimized out>, pRes=0x7fff2e5c2e80) at sqlite3.c:55077
#9 0x00007f9ac920d9c5 in sqlite3VdbeExec (p=p@entry=0x500ebe8) at sqlite3.c:70168
#10 0x00007f9ac9215ed7 in sqlite3Step (p=0x500ebe8) at sqlite3.c:64828

[Cfeck (cfeck)]

Ben, and you also get these crashes if you upgrade sqlite3 package to version 3.8.4 or newer, as is suggested in the comments of this bug report?

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 347450 has been marked as a duplicate of this bug. ***

[Benedikt Balian (bnbphotofr)]

(In reply to Christoph Feck from comment #134)
> Ben, and you also get these crashes if you upgrade sqlite3 package to
> version 3.8.4 or newer, as is suggested in the comments of this bug report?

I did update sqlite3 to the latest version available on my distro. The crash still happens, on a less regular bases though.

It happens mainly when am switching albums while the album I am in still loads thumbnails.

[Caulier-gilles-9 (caulier-gilles-9)]

This is not enough to update sqlite. The qt-sqlite plugin must be updated too.

Gilles Caulier

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 341424 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 347786 has been marked as a duplicate of this bug. ***

[Otto-daemon (otto-daemon)]

First I tried to update some single packages in synaptic as also
described in some comments. In the end I made a mistake and practically
my complete GUI was deinstalled. At best I am a script kid...
After a new install of ubuntu 14.04, the problem was still comparable.
Now I tried the ppa made by Matthias Andree (Comment 119). This worked
very well for me too. Digikam is now stable!
Thanks a lot to Matthias!

Am Sonntag, den 10.05.2015, 08:28 +0000 schrieb Gilles Caulier:
> https://bugs.kde.org/show_bug.cgi?id=329697
>
> Gilles Caulier <email address hidden> changed:
>
> What |Removed |Added
> ----------------------------------------------------------------------------
> CC| |<email address hidden>
>
> --- Comment #138 from Gilles Caulier <email address hidden> ---
> *** Bug 341424 has been marked as a duplicate of this bug. ***
>

[cellstorm (cellstorm-brainity-deactivatedaccount)]

>This is not enough to update sqlite. The qt-sqlite plugin must be updated too.

I did this, package is available here:
http://openartist.org/debian/trusty64/libqt4-sql-sqlite_4.8.5+git192-g085f851+dfsg-2ubuntu5_amd64.deb

It's just a plain rebuild of the whole qt package, with version number pushed to ubuntu5
( for people who want to try themselves:
      apt-get source libqt4-sql-sqlite
      sudo apt-get build-dep libqt4-sql-sqlite
      cd qt4*
      fakeroot dpkg-buildpackage -d -j4 -uc -us
 beware, needs hours and nearly 15gb of hdd space.
)

It is built with sqlite from Matthias Andree 's ppa, so propably it's a good idea to install this first:

sudo add-apt-repository ppa:matthias-andree/trusty-fixes
sudo apt-get update && sudo apt-get upgrade

[Benedikt Balian (bnbphotofr)]

Created attachment 93046
New crash information added by DrKonqi

digikam (4.0.0) on KDE Platform 4.14.2 using Qt 4.8.6

Selecting a picture in an album

It reproduces sometimes and is not related to any specific album.

-- Backtrace (Reduced):
#7 0x00007fe71a6d7dac in sqlite3MemCompare (pMem1=pMem1@entry=0x7fffc4a3c1f0, pMem2=<optimized out>, pColl=0x10d01118) at sqlite3.c:60484
#8 0x00007fe71a6d7f63 in sqlite3VdbeRecordCompare (nKey1=18, pKey1=0x7fe7041e026f, pPKey2=pPKey2@entry=0x7fffc4a3c4f0) at sqlite3.c:64162
#9 0x00007fe71a6ec579 in sqlite3BtreeMovetoUnpacked (pCur=0x110cfed0, pIdxKey=0x7fffc4a3c4f0, intKey=0, biasRight=<optimized out>, pRes=0x7fffc4a3c4e0) at sqlite3.c:55077
#10 0x00007fe71a7149c5 in sqlite3VdbeExec (p=p@entry=0x1226c408) at sqlite3.c:70168
#11 0x00007fe71a71ced7 in sqlite3Step (p=0x1226c408) at sqlite3.c:64828

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 350130 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 351374 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 351521 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 352174 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 352313 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 355903 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 355950 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 356282 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 356598 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 357421 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 358337 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 358356 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 358488 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 358829 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 358832 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 359540 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 359977 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 360665 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 363736 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 364153 has been marked as a duplicate of this bug. ***

[Caulier-gilles-9 (caulier-gilles-9)]

*** Bug 374472 has been marked as a duplicate of this bug. ***