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

[Frantisek Repkovsky (ferro-sk)]

(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

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

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

[adaptee (adaptee)]

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

[adaptee (adaptee)]

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

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

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

[Tpr-3 (tpr-3)]

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

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

Hi Teemu,

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

Gilles

[Nikita+kde (nikita+kde)]

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

[Christoph-maxiom (christoph-maxiom)]

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

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

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

[Mac-v (mac-v)]

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

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

Hi Malcolm,

This what i suspected a lot...

Gilles Caulier

[Px79-2 (px79-2)]

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.

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

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

[Christoph-maxiom (christoph-maxiom)]

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

[adaptee (adaptee)]

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

[adaptee (adaptee)]

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

[Nikita+kde (nikita+kde)]

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

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

Ok thanks

I close this file as UPSTREAM

Gilles Caulier

[Axel-krebs-m (axel-krebs-m)]

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

e.g.?

Axel

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

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

[b3nmore (b3nmore)]

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.

[adaptee (adaptee)]

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

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

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

[Christoph-maxiom (christoph-maxiom)]

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

[adaptee (adaptee)]

*** Bug 334853 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

[adaptee (adaptee)]

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

[adaptee (adaptee)]

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

[Brylie Christopher Oxley (brylie)]

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

[Adam Porter (alphapapa)]

Done. Thanks, Brylie.

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

[Adam Porter (alphapapa)]

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.

[Jon Pawley (nz-jon)]

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

[adaptee (adaptee)]

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

[adaptee (adaptee)]

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

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

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

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

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

[Christoph-maxiom (christoph-maxiom)]

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

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

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

[adaptee (adaptee)]

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

[adaptee (adaptee)]

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

[H Law (hlaw)]

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.

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

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

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

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

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

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

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

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

[Christoph-maxiom (christoph-maxiom)]

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

[adaptee (adaptee)]

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

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

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

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

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

[b3nmore (b3nmore)]

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.

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

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

[Christoph-maxiom (christoph-maxiom)]

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

[Launchpad Janitor (janitor)]

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

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

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

[linuxwrangler (scrawford-pinpointresearch)]

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.

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

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

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

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

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

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

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

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

[linuxwrangler (scrawford-pinpointresearch)]

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.

[RJVB (rjvbertin)]

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

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

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

[RJVB (rjvbertin)]

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

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

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

[Steve Langasek (vorlon)]

sqlite3 3.8.5-2ubuntu1 is now in utopic.

[b3nmore (b3nmore)]

> sqlite3 3.8.5-2ubuntu1 is now in utopic.

Thanks. How about trusty?

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

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

[Christoph-maxiom (christoph-maxiom)]

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

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

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

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

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

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

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

[b3nmore (b3nmore)]

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

[Chris (mail-christianmayer)]

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

[Rbk1rbk (rbk1rbk)]

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

[Christoph-maxiom (christoph-maxiom)]

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

[Jason Robinson (jaywink)]

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

[Christoph-maxiom (christoph-maxiom)]

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

[Tim Edwards (tkedwards)]

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!

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

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

[Christoph-maxiom (christoph-maxiom)]

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

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

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

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

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

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

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

[A (bluehorizon)]

So will you finally fix this PLEASE?

[Matthias Klose (doko)]

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.

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

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

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

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

[b3nmore (b3nmore)]

> 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

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

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

[Chris Samuel (chris-csamuel)]

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

[Chris Samuel (chris-csamuel)]

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.

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

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

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

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

[Matthias Andree (matthias-andree)]

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.

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

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

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

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

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

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

[Cfeck (cfeck)]

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

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

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

[Matthias Andree (matthias-andree)]

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

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

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

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

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

[Cfeck (cfeck)]

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

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

*** Bug 343243 has been marked as a duplicate of this 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. ***