Bug 375317

Summary:	MYSQL: digikam crashes during face recognition
Product:	[Applications] digikam	Reporter:	Kurpfaelzer <Stephan.Kranz>
Component:	Database-Mysql	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	crash	CC:	caulier.gilles
Priority:	NOR
Version:	5.4.0
Target Milestone:	---
Platform:	Microsoft Windows
OS:	Microsoft Windows
Latest Commit:	https://commits.kde.org/digikam/6a9fd9891a3ff341dc42fe36158cbf0101d513b6	Version Fixed In:	7.0.0

Description Kurpfaelzer 2017-01-19 20:22:53 UTC

I have installed digikam on several computers. On two computers, I am using MYSQL as database. On a third computer, I use digikams internal database. All photos are all located on a NAS.
Performing face recognition on the computer with the internal database, all went sucessful - I got mostly all pictures with faces on them.
But if I am using digikam connected to the MYSQL database, every time I'm trying to perform a face recognition digikam crashes.

Comment 1 caulier.gilles 2017-04-16 20:21:24 UTC

new 5.6.0 pre-release as bundle is available here :

https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM

Please check if this problem still reproducible with these versions.

Thanks in advance

Gilles Caulier

Comment 2 caulier.gilles 2017-06-22 21:43:20 UTC

digiKam 5.6.0 is now released and available as bundle for Linux, MacOS and Windows.

https://www.digikam.org/news/2017-06-21-5.6.0-release-announcement/

Can you check if problem still exists with this version ?

Thanks in advance

Gilles Caulier

Comment 3 Kurpfaelzer 2017-07-01 20:29:15 UTC

Unfortunattely, digikam still crashes during face recognition.
But I'm no longer sure whether this behavior really depends on MYSQL.

For version 5.6 (incl. pre-releases) I realized another curious behaviour:
if you select a special folder which should be searched for faces, digikam obviously starts to search in all folders (not only in the chosen one).

Sorry to give you this negative feedback but I think that it might help to improve digikam, which in fact is a great piece of software and I thank all developers for their great work!

Stephan

Comment 4 Maik Qualmann 2017-12-17 19:21:34 UTC

Git commit 6a9fd9891a3ff341dc42fe36158cbf0101d513b6 by Maik Qualmann.
Committed on 17/12/2017 at 19:20.
Pushed by mqualmann into branch 'master'.

delete threads from memory when they are finished
Related: bug 375035, bug 321784, bug 325712, bug 328732, bug 330227, bug 331912, bug 344661, bug 345395, bug 350549, bug 381877, bug 338249, bug 329651, bug 329091, bug 387821, bug 381222

M  +2    -1    NEWS
M  +25   -0    libs/database/dbjobs/dbjobsmanager.cpp
M  +35   -0    libs/iojobs/iojobsmanager.cpp

https://commits.kde.org/digikam/6a9fd9891a3ff341dc42fe36158cbf0101d513b6

Comment 5 caulier.gilles 2019-12-23 09:26:28 UTC

Problem is fixed with new 7.0.0-beta1 through this long story from this bug

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

You can test digiKam 7.0.0-beta1 with bundle available here:

https://download.kde.org/unstable/digikam/

Don't hesitate to give us a fresh feedback about his entry.

Thanks in advance

Gilles Caulier