sqlite3 version 3.8.2 breaks digikam

Bug #1317449 reported by b3nmore
284
This bug affects 63 people
Affects Status Importance Assigned to Milestone
SQLite
Won't Fix
High
digiKam
Won't Fix
High
digikam (Ubuntu)
Fix Released
Undecided
Rohan Garg
Trusty
Confirmed
Undecided
Rohan Garg
Utopic
Fix Released
Undecided
Rohan Garg
sqlite3 (Ubuntu)
Fix Released
Undecided
Rohan Garg
Trusty
Confirmed
Undecided
Rohan Garg
Utopic
Fix Released
Undecided
Rohan Garg

Bug Description

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.

Revision history for this message
In , Andrejoh (andrejoh) wrote :
Download full text (7.8 KiB)

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...

Read more...

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Gilles Caulier

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Umvmac (umvmac) wrote :

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?

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Tpr-3 (tpr-3) wrote :
Download full text (17.5 KiB)

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...

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Amair-sob (amair-sob) wrote :

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

Revision history for this message
In , Andrejoh (andrejoh) wrote :

sqlite-3.8.2-1.fc20.x86_64

Revision history for this message
In , Amair-sob (amair-sob) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Px79-2 (px79-2) wrote :

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".

Revision history for this message
In , Px79-2 (px79-2) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Pierre-metzner (pierre-metzner) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Pierre-metzner (pierre-metzner) wrote :

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

Revision history for this message
In , Marcel-wiesweg (marcel-wiesweg) wrote :

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.

Revision history for this message
In , Ki-mech (ki-mech) wrote :

(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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Frantisek Repkovsky (ferro-sk) wrote :

(In reply to comment #31)

Hello,

I confirm the issue in kubuntu 14.04 + sqlite + qt4. Digikam often crashes, mostly when working with tags.

Best regards

Frantisek

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Tpr-3 (tpr-3) wrote :

Has this been reported to an upstream (Qt/Sqlite?), perhaps they could have an idea what'd be the problem?

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

Hi Teemu,

No i think it don't have been yet reported as upstream.

Gilles

Revision history for this message
In , Nikita+kde (nikita+kde) wrote :

Created attachment 86363
New crash information added by DrKonqi

digikam (3.5.0) on KDE Platform 4.11.5 using Qt 4.8.5

- What I was doing when the application crashed:
Browsing albums. I confirm this started to frequently happen after upgrading sqlite from 3.7 to 3.8.

-- Backtrace (Reduced):
#7 0x00007fd62f57a566 in sqlite3MemCompare (pMem1=pMem1@entry=0x7fff88c12e30, pMem2=<optimized out>, pColl=0xef7948) at sqlite3.c:60482
#8 0x00007fd62f57a968 in sqlite3VdbeRecordCompare (nKey1=19, pKey1=0x7fd62417a018, pPKey2=pPKey2@entry=0x7fff88c13290) at sqlite3.c:64160
#9 0x00007fd62f59eeb7 in sqlite3BtreeMovetoUnpacked (pRes=<optimized out>, biasRight=<optimized out>, intKey=<optimized out>, pIdxKey=<optimized out>, pCur=<optimized out>) at sqlite3.c:55075
#10 sqlite3BtreeMovetoUnpacked (pCur=0x32880e0, pIdxKey=0x7fff88c13290, intKey=0, biasRight=<optimized out>, pRes=0x7fff88c13280) at sqlite3.c:54960
#11 0x00007fd62f5a777e in sqlite3VdbeExec (p=p@entry=0x114ebd8) at sqlite3.c:70166

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Mac-v (mac-v) wrote :

Since an auto-update to sqlite 3.8.3, this bug seems to have stopped occurring, in my Fedora 20 system.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

Hi Malcolm,

This what i suspected a lot...

Gilles Caulier

Revision history for this message
In , Px79-2 (px79-2) wrote :

I have similar results as Malcolm in comment #47:
Since I am using "dev-db/sqlite-3.8.4.3" (see comment #18), I been working several hours with digikam 3.5.0 by now and processing more than 640 picture without one single sqlite-crash as mentioned above. :)

So this problem seems to be limited to sqlite version 3.8.2.x.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Nikita+kde (nikita+kde) wrote :

Looks like dev-db/sqlite-3.8.4.3 fixed issues for me too.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

Ok thanks

I close this file as UPSTREAM

Gilles Caulier

Revision history for this message
In , Axel-krebs-m (axel-krebs-m) wrote :

Any recommendation?
-> migrate to mysql
-> downgrade sqlite,

e.g.?

Axel

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

It's a Sqlite bug. You must upgrate to new sqlite release, including an upgrate of QtSlqite plugin, else plroblem will not resolved for digiKam.

This a weird side-effect of downstream bug which downgrade stability of client application.

As Sqlite is used in a lots of appplication, i'm sure that digiKam is not the only one affected by this problem. Sqlite package will be certainly updated in your distro quickly...

No need to use Mysql here. Mysql interface in digiKam as old dysfunctions not yet fixed.

Gilles Caulier

tags: added: upgrade-software-version
Changed in sqlite3 (Ubuntu):
status: New → Triaged
importance: Undecided → Wishlist
Revision history for this message
In , b3nmore (b3nmore) wrote :

FYI, I reported this issue for ubuntu at https://bugs.launchpad.net/ubuntu/+source/digikam/+bug/1315932 and asked for updating sqlite3 at https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/1317449 . As a temporary workaround I use the sqlite3 (3.8.4) packages from debian testing, which solves this issue for me.

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
b3nmore (b3nmore) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Brylie Christopher Oxley (brylie) wrote :

Hi all,
If you use Ubuntu, or any derivative such as Kububtu, please mark "This bug affects me" by clicking on "Does this bug affect you?" on the following page:
https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/1317449

Revision history for this message
In , Adam Porter (alphapapa) wrote :

Done. Thanks, Brylie.

Revision history for this message
Adam Porter (alphapapa) wrote :

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.

Revision history for this message
Adam Porter (alphapapa) wrote :

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.

Changed in sqlite3 (Ubuntu):
status: Triaged → Confirmed
Revision history for this message
In , Adam Porter (alphapapa) wrote :

By the way, the Ubuntu bug is marked as a Wishlist bug since the fix seems to be upgrading the minor version of SQLite. However, since it's causing crashes, I believe it should be classified as a bug, not a wishlist item. Please also encourage Ubuntu to step up and fix this. Wishlist items in released distros tend to get ignored.

Changed in sqlite:
importance: Unknown → High
status: Unknown → Won't Fix
Revision history for this message
Jon Pawley (nz-jon) wrote : Re: Please update to a version > 3.8.2

It sounds to me that a minor upgrade in SQLite will stop these crashes from occurring. I don't understand why this wouldn't be fixed in Kubuntu 14.04...

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Changed in digikam:
importance: Unknown → High
status: Unknown → Won't Fix
Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , H Law (hlaw) wrote :

The same problem here. A similar extract:

Thread 1 (Thread 0x7f47e1b86840 (LWP 18412)):
[KCrash Handler]
#5 0x0000000000000052 in ?? ()
#6 0x00007f47c5eccdac in sqlite3MemCompare (pMem1=pMem1@entry=0x7fffb076d470, pMem2=<optimized out>, pColl=0x569c298) at sqlite3.c:60484
#7 0x00007f47c5eccf63 in sqlite3VdbeRecordCompare (nKey1=18, pKey1=0x7f47ac07489a, pPKey2=pPKey2@entry=0x7fffb076d770) at sqlite3.c:64162
#8 0x00007f47c5ee1579 in sqlite3BtreeMovetoUnpacked (pCur=0x54f45c0, pIdxKey=0x7fffb076d770, intKey=0, biasRight=<optimized out>, pRes=0x7fffb076d760) at sqlite3.c:55077
#9 0x00007f47c5f099c5 in sqlite3VdbeExec (p=p@entry=0x5dbce58) at sqlite3.c:70168
#10 0x00007f47c5f11ed7 in sqlite3Step (p=0x5dbce58) at sqlite3.c:64828
#11 sqlite3_step (pStmt=<optimized out>) at sqlite3.c:64894
#12 0x00007f47b28d211c in QSQLiteResultPrivate::fetchNext (this=this@entry=0x65e1ea0, values=..., idx=idx@entry=0, initialFetch=initialFetch@entry=true) at ../../../sql/drivers/sqlite/qsql_sqlite.cpp:235

I compiled digikam 4.0.0 from source. It was fine under ubuntu (12.10) but after upgrading to ubuntu 14.04 (sqlite 3.8.2) and recompiling, random crashes appeared. Since almost the same code base is used to compile in both cases, it could be confirmed that this is not an issue of digikam. (I have since made patches to other areas but should not be relevant to db access).
Will try upgrading sqlite.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
In , adaptee (adaptee) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

b3nmore (b3nmore)
no longer affects: sqlite3 (Ubuntu)
Revision history for this message
b3nmore (b3nmore) wrote : Re: Please update to a version > 3.8.2

Oops, accidentally deleted the affected package sqlite3 (ubuntu). Sorry for messing things up. But while we are at it, may be we can take advantage of the situation and raise the severity level to something higher than wishlist. The current version breaks virtually the usage of digikam in trusty and utopic and the major part of the kde bug reports concerns ubuntu.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in sqlite3 (Ubuntu):
status: New → Confirmed
Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
linuxwrangler (scrawford-pinpointresearch) wrote : Re: Please update to a version > 3.8.2

Crashing started after upgrade to 14.04. Same sqlite3 backtrace as others reported. I can sometimes process a photo or two before crashing but Digikam is essentially useless in this release. I'm now wondering if sqlite3 is also responsible for crashes in Firefox that I have been experiencing. No proof of that, yet, but investigating.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
linuxwrangler (scrawford-pinpointresearch) wrote :

I can confirm that the workaround mentioned in comment 62 (upgrading to Sqlite3 3.8.4 from Debian testing) works for me as well. Digikam has now been running for several days with no crashing through sleep/wake cycles, downloading several hundred photos while simultaneously processing raw, changing ratings, etc.

Revision history for this message
In , RJVB (rjvbertin) wrote :

Created attachment 87235
New crash information added by DrKonqi

digikam (4.0.0) on KDE Platform 4.13.1 using Qt 4.8.6

- What I was doing when the application crashed:
Another sample of the sql-related crash-when-opening-an-image-for-editing issue, on a freshly updated Kubuntu 14.04/KDE 4.13.1 system (Digikam was installed after said update).

-- Backtrace (Reduced):
#7 0x00007f1181b96dac in sqlite3MemCompare (pMem1=pMem1@entry=0x7fffe1e68ce0, pMem2=<optimized out>, pColl=0xa4ee338) at sqlite3.c:60484
#8 0x00007f1181b96f63 in sqlite3VdbeRecordCompare (nKey1=24, pKey1=0x7f11600979ae, pPKey2=pPKey2@entry=0x7fffe1e68fe0) at sqlite3.c:64162
#9 0x00007f1181bab579 in sqlite3BtreeMovetoUnpacked (pCur=0xadd9a50, pIdxKey=0x7fffe1e68fe0, intKey=0, biasRight=<optimized out>, pRes=0x7fffe1e68fd0) at sqlite3.c:55077
#10 0x00007f1181bd39c5 in sqlite3VdbeExec (p=p@entry=0x6b3e418) at sqlite3.c:70168
#11 0x00007f1181bdbed7 in sqlite3Step (p=0x6b3e418) at sqlite3.c:64828

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

Qt SQL driver need to be updated and also libsqlite. Updating digiKAm is not enough especially if packager don't take a care about this UPSTREAM problem..

As it have already said in this file, problem is located into sqlite implementation.

Gilles Caulier

Revision history for this message
In , RJVB (rjvbertin) wrote :

Anyone managed to find updated (4.8.6) Qt packages for (K)Ubuntu?

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
Steve Langasek (vorlon) wrote : Re: Please update to a version > 3.8.2

sqlite3 3.8.5-2ubuntu1 is now in utopic.

Changed in sqlite3 (Ubuntu):
status: Confirmed → Fix Released
Revision history for this message
b3nmore (b3nmore) wrote :

> sqlite3 3.8.5-2ubuntu1 is now in utopic.

Thanks. How about trusty?

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

b3nmore (b3nmore)
tags: added: trusty
Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

b3nmore (b3nmore)
Changed in sqlite3 (Ubuntu):
status: Fix Released → In Progress
Revision history for this message
b3nmore (b3nmore) wrote : Re: Please update to a version > 3.8.2

I took the liberty to changed the status from 'Fix Released' -> 'In Progress' to keep it in the open bug list. Since the issue remains for trusty, the majority of ubuntu users is still affected (as one can see by the still growing numbers of dups of kde bug tracker).

Revision history for this message
Chris (mail-christianmayer) wrote :

Please fix that ASAP, I can't really use digikam anymore due to it...

Changed in sqlite3 (Ubuntu):
status: In Progress → Confirmed
Revision history for this message
In , Rbk1rbk (rbk1rbk) wrote :

- What I was doing when the application crashed:

I was adding a new tag to a picture. For some time I ran digikam against mysql, then I migrated back to sqlite. Since then digikam is crashing frequently. Also I enabled face detection.
After migration from mysql to sqlite I hit an issue where tags were missing and digikam ran from a console reported, that there is no parent tag (-1). I changed parent tag from -1 to 0 (zero) in sqlite database, now tags are back.

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
Jason Robinson (jaywink) wrote : Re: Please update to a version > 3.8.2

This is really critical - digiKam on trusty is pretty much unusable due to crashes.

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
Tim Edwards (tkedwards) wrote :

I worked around this bug on trusty by downloading & installing the following utopic packages from packages.ubuntu.com:
libsqlite3-0_3.8.5-2ubuntu1_amd64.deb sqlite3_3.8.5-2ubuntu1_amd64.deb
libsqlite3-0_3.8.5-2ubuntu1_i386.deb sqlite3_3.8.5-2ubuntu1_i386.deb

Please fix the bug properly on trusty, it's very frustrating that digikam slideshows just crash without this workaround!

b3nmore (b3nmore)
summary: - Please update to a version > 3.8.2
+ sqlite version 3.8.2 breaks digikam
Changed in digikam (Ubuntu):
status: New → Confirmed
b3nmore (b3nmore)
description: updated
summary: - sqlite version 3.8.2 breaks digikam
+ sqlite3 version 3.8.2 breaks digikam
Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Christoph-maxiom (christoph-maxiom) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
A (bluehorizon) wrote :

So will you finally fix this PLEASE?

Rohan Garg (rohangarg)
Changed in digikam (Ubuntu):
assignee: nobody → Rohan Garg (rohangarg)
Changed in sqlite3 (Ubuntu):
assignee: nobody → Rohan Garg (rohangarg)
Revision history for this message
Matthias Klose (doko) wrote :

fixed in utopic (14.10). fix pending for trusty (14.04).

we usually don't update stable releases to new upstream releases. what is needed is to identify the patches needed from the new upstream version, and then apply these only.

A big help would be a test case not involving digikam at all.

Changed in digikam (Ubuntu Utopic):
status: Confirmed → Fix Released
Changed in digikam (Ubuntu Trusty):
assignee: nobody → Rohan Garg (rohangarg)
status: New → Confirmed
Changed in sqlite3 (Ubuntu Trusty):
assignee: nobody → Rohan Garg (rohangarg)
status: New → Incomplete
Changed in sqlite3 (Ubuntu Utopic):
status: Confirmed → Fix Released
Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
b3nmore (b3nmore) wrote :

> A big help would be a test case not involving digikam at all.

Not sure, how to provide such, since the exact cause is unknown.

However, here's a proposal: I've found only one closed ticket for the 3.8.2 branch [1]. Maybe it would be worth backporting the fix [2] and test, if it fixes the digikam issue.

[1] http://www.sqlite.org/cgi/src/tktview?name=520070ec7f
[2] http://www.sqlite.org/cgi/src/info/ac5852d6403c9c9628ca0aa7be135c702f000698

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
Chris Samuel (chris-csamuel) wrote :

I applied the patch that b3nmore mentions in comment #126 to sqlite3 from Trusty and built my own packages which I installed but sadly Digikam still crashes with that applied. :-(

Revision history for this message
Chris Samuel (chris-csamuel) wrote :

I can confirm that Tim Edwards suggestion of installing the sqlite3 packages from Utopic in comment #117 does indeed seem to resolve this issue.

Before Digikam could crash every few minutes whilst cycling through photos with just normal viewing.

After Digikam does not crash.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Changed in sqlite3 (Ubuntu Trusty):
status: Incomplete → Confirmed
Revision history for this message
Matthias Andree (matthias-andree) wrote :

So Ubuntu imports the upgraded SQlite in a now known-broken version, but refuses to fix the regression on the LTS Trusty because they cannot identify the failure-inducing patches. What kind of support is this if the LTS Version has critical regressions unfixed after half a year? I can work around this myself, but the majority of users can not.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Cfeck (cfeck) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Matthias Andree (matthias-andree) wrote :

(In reply to b3nmore from comment #58)
> FYI, I reported this issue for ubuntu at
> https://bugs.launchpad.net/ubuntu/+source/digikam/+bug/1315932 and asked for
> updating sqlite3 at
> https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/1317449 . As a
> temporary workaround I use the sqlite3 (3.8.4) packages from debian testing,
> which solves this issue for me.

I set up a PPA for Ubuntu 14.04 LTS that has a newer sqlite3 build. I made my life easy and just rebuilt the utopic unicorn src dpkg, and I do not intend to support this; it's a makeshift arrangement.
https://launchpad.net/~matthias-andree/+archive/ubuntu/trusty-fixes

Ubuntu packagers aren't helpful and are asking that someone isolates the fix from the upgraded sqlite3 package.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Cfeck (cfeck) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Benedikt Balian (bnbphotofr) wrote :

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

Revision history for this message
In , Cfeck (cfeck) wrote :

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?

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Benedikt Balian (bnbphotofr) wrote :

(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.

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Gilles Caulier

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Otto-daemon (otto-daemon) wrote :

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. ***
>

Revision history for this message
cellstorm (cellstorm-brainity-deactivatedaccount) wrote :

>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

Revision history for this message
In , Benedikt Balian (bnbphotofr) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

Revision history for this message
In , Caulier-gilles-9 (caulier-gilles-9) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.