Bug 421808 - Ignored directory does not clean up database
Summary: Ignored directory does not clean up database
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Albums-ItemGroup (show other bugs)
Version: 7.0.0
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-05-20 05:58 UTC by Marcel
Modified: 2020-05-30 11:17 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 7.0.0
Sentry Crash Report:


Attachments
Example of empty icons 1 (71.41 KB, image/jpeg)
2020-05-20 05:58 UTC, Marcel
Details
Example of empty icons 2 (134.63 KB, image/jpeg)
2020-05-20 05:58 UTC, Marcel
Details
Example of multiple icons on same place without mouseover (132.10 KB, image/png)
2020-05-20 05:59 UTC, Marcel
Details
Example of multiple icons on same place with mouseover (51.65 KB, image/jpeg)
2020-05-20 06:00 UTC, Marcel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Marcel 2020-05-20 05:58:03 UTC
SUMMARY
"Ignored directories" does remove all ignored albums, but does not ignore previous artefacts from this pictures. 

Artefacts are produces from:
- Detect faces (in the folder Unknown)
- Similarity
- ...

All works fine again when removing the ignored directory

STEPS TO REPRODUCE
1. Produce artefacts (e.g. Face detection)
2. Ignore that folder with detected faces
3. Look to artefacts (e.g. person unknown)

OBSERVED RESULT
The current behaviour is, that this artefacts still exists but with very strange GUI affects:
- No album titles
- Spacing is wrong (lots of empty place holders)
- Multiple icons on same place (according to mouse position)
- ..

EXPECTED RESULT
Artefacts from Ignored directories must be removed from the database

SOFTWARE/OS VERSIONS
digikam-7.0.0-rc-20200516T134714-x86-64.appimage on Ubuntu 20.04

ADDITIONAL INFORMATION
Comment 1 Marcel 2020-05-20 05:58:32 UTC
Created attachment 128622 [details]
Example of empty icons 1
Comment 2 Marcel 2020-05-20 05:58:51 UTC
Created attachment 128623 [details]
Example of empty icons 2
Comment 3 Marcel 2020-05-20 05:59:52 UTC
Created attachment 128624 [details]
Example of multiple icons on same place without mouseover
Comment 4 Marcel 2020-05-20 06:00:12 UTC
Created attachment 128625 [details]
Example of multiple icons on same place with mouseover
Comment 5 Maik Qualmann 2020-05-20 06:43:09 UTC
I did a quick test here with the Windows version and SQLite DB. I cannot reproduce the problem. When I add a folder to the ignored folder, all faces in "Unknown" disappear. Which database type do you use? MySQL or SQlite?

Maik
Comment 6 Marcel 2020-05-20 06:53:10 UTC
The problem is with SQLite. I recently migrated from MySQLServer, but I guess this should not produce that problem. Anyway, if I do not ignore that folder any more the artefacts can be used without a new face detection.
Comment 7 Maik Qualmann 2020-05-20 06:58:30 UTC
If the ignored folder contains subfolders, these are not hidden.

Maik
Comment 8 Marcel 2020-05-20 07:08:05 UTC
The Ignores folder is on the root location of the project and contains indeed subfolders. This subfolders gets ignored from the project but not from the artefacts.
Comment 9 Maik Qualmann 2020-05-20 19:53:16 UTC
Git commit 38229aeb27252a1ba2bbaa6e6153e9e185828c99 by Maik Qualmann.
Committed on 20/05/2020 at 19:51.
Pushed by mqualmann into branch 'master'.

fix delete all sub albums of ignored directories
FIXED-IN: 7.0.0

M  +2    -1    NEWS
M  +7    -3    core/libs/database/collection/collectionscanner_scan.cpp

https://invent.kde.org/graphics/digikam/commit/38229aeb27252a1ba2bbaa6e6153e9e185828c99
Comment 10 Maik Qualmann 2020-05-20 20:15:26 UTC
Note: to clean up the database again, the best way is to add the ignored directories first and then ignore them again.

Maik
Comment 11 Maik Qualmann 2020-05-21 04:39:55 UTC
Git commit c15243b34c723a024905c70649f305e3fe97b284 by Maik Qualmann.
Committed on 21/05/2020 at 04:37.
Pushed by mqualmann into branch 'master'.

the path level solution is better

M  +8    -8    core/libs/database/collection/collectionscanner_scan.cpp

https://invent.kde.org/graphics/digikam/commit/c15243b34c723a024905c70649f305e3fe97b284
Comment 12 Marcel 2020-05-30 11:17:26 UTC
I confirm that this problem is solved. Thank you.