[digikam] [Bug 329697] New: digiKam crash when browsing albums

[Jekyll Wu]

https://bugs.kde.org/show_bug.cgi?id=329697

Jekyll Wu <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #39 from Jekyll Wu <[hidden email]> ---
*** Bug 334042 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Jekyll Wu]

https://bugs.kde.org/show_bug.cgi?id=329697

Jekyll Wu <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #40 from Jekyll Wu <[hidden email]> ---
*** Bug 333787 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #41 from Gilles Caulier <[hidden email]> ---
*** Bug 334105 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Teemu Rytilahti]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #42 from Teemu Rytilahti <[hidden email]> ---
Has this been reported to an upstream (Qt/Sqlite?), perhaps they could have an
idea what'd be the problem?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #43 from Gilles Caulier <[hidden email]> ---
Hi Teemu,

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

Gilles

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Nikita Melnichenko-2]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #44 from Nikita Melnichenko <[hidden email]> ---
Created attachment 86363
  --> https://bugs.kde.org/attachment.cgi?id=86363&action=edit
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

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Christoph Feck]

https://bugs.kde.org/show_bug.cgi?id=329697

Christoph Feck <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #45 from Christoph Feck <[hidden email]> ---
*** Bug 334186 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=329697

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #46 from Gilles Caulier <[hidden email]> ---
*** Bug 334189 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Malcolm Beckett]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #47 from Malcolm Beckett <[hidden email]> ---
Since an auto-update to sqlite 3.8.3, this bug seems to have stopped occurring,
in my Fedora 20 system.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #48 from Gilles Caulier <[hidden email]> ---
Hi Malcolm,

This what i suspected a lot...

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Peter Albrecht-2]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #49 from Peter Albrecht <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=329697

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #50 from Gilles Caulier <[hidden email]> ---
*** Bug 334310 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Christoph Feck]

https://bugs.kde.org/show_bug.cgi?id=329697

Christoph Feck <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #51 from Christoph Feck <[hidden email]> ---
*** Bug 334344 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Jekyll Wu]

https://bugs.kde.org/show_bug.cgi?id=329697

Jekyll Wu <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #52 from Jekyll Wu <[hidden email]> ---
*** Bug 334350 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Jekyll Wu]

https://bugs.kde.org/show_bug.cgi?id=329697

Jekyll Wu <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #53 from Jekyll Wu <[hidden email]> ---
*** Bug 334443 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Nikita Melnichenko-2]

https://bugs.kde.org/show_bug.cgi?id=329697

Nikita Melnichenko <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|[hidden email] |

--- Comment #54 from Nikita Melnichenko <[hidden email]> ---
Looks like dev-db/sqlite-3.8.4.3 fixed issues for me too.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=329697

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |RESOLVED
         Resolution|---                         |UPSTREAM

--- Comment #55 from Gilles Caulier <[hidden email]> ---
Ok thanks

I close this file as UPSTREAM

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Axel Krebs]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #56 from Axel Krebs <[hidden email]> ---
Any recommendation?
-> migrate to mysql
-> downgrade sqlite,

e.g.?

Axel

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #57 from Gilles Caulier <[hidden email]> ---
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

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[b3nmore]

https://bugs.kde.org/show_bug.cgi?id=329697

--- Comment #58 from [hidden email] ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel