[digikam] [Bug 317210] New: delete image removes file, but does not remove thumbnails

[bugzilla_noreply]

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

--- Comment #33 from [hidden email] ---
Using digiKam 5.0.0, I did the following with MySQL DB:

1)Add photos in a new album.
2)In thumbnails view, move multiple images to Trash.

In UI: The images are no more visible in Thumbnails view.

In DB:
After adding images, they're visible correctly in Images table.
After deletion, images still present in DB but with album column = "NULL". If
we restore these images, then NULL entries remains in the table, and new rows
are added for those images.

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

[bugzilla_noreply]

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

--- Comment #34 from [hidden email] ---
It's clear. The table in DB must be cleaned properly. That all..

Probably the same dysfunction must exist with sqlite.

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

[bugzilla_noreply]

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

--- Comment #35 from [hidden email] ---
What's happen if you delete an album as well ? All item entries in DB are
properly removed ?

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

[bugzilla_noreply]

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

--- Comment #36 from [hidden email] ---
I think that what happens now is partially right. 'Cause when an item is "Moved
to trash", it is just removed and not permanently deleted. So it is right to
exist in table with album=NULL

The issue lies when that item is "permanently" deleted and there's no change in
the Images table.

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

[bugzilla_noreply]

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

Mario Frank <[hidden email]> changed:

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

--- Comment #37 from Mario Frank <[hidden email]> ---
Hi, I just uploaded a patch in https://bugs.kde.org/show_bug.cgi?id=374591 that
introduces garbage collection as maintenance stage. This cleans the core,
thumbs and recognition db from stale entries. But be advised: The patch is
still in testing phase. I did some tests on my own databases and had no
problems. But just to be sure, backup your databases before you test.

--
You are receiving this mail because:
You are the assignee for the bug.

[bugzilla_noreply]

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

--- Comment #38 from [hidden email] ---
New 5.5.0 AppImage is done with garbage database collector patches.
Uploading to GDrive is under progress. It will be online in few minutes at
usual
place :

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

New database Garbage Collector options are there :

https://www.flickr.com/photos/digikam/32549923912/in/dateposted-public/
https://www.flickr.com/photos/digikam/32549923632/in/dateposted-public/

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.

[bugzilla_noreply]

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

Mario Frank <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|UNCONFIRMED                 |RESOLVED
   Version Fixed In|                            |5.5.0
      Latest Commit|                            |https://commits.kde.org/dig
                   |                            |ikam/834221c8d1300bbdd4ae78
                   |                            |e345cdc0fce3e92be8

--- Comment #39 from Mario Frank <[hidden email]> ---
Git commit 834221c8d1300bbdd4ae78e345cdc0fce3e92be8 by Mario Frank.
Committed on 09/02/2017 at 20:51.
Pushed by mfrank into branch 'master'.

Updated the news. The newly introduced garbage collection gets rid of
thumbnails in DB that are not referenced by any image any more.
FIXED-IN: 5.5.0

M  +2    -1    NEWS

https://commits.kde.org/digikam/834221c8d1300bbdd4ae78e345cdc0fce3e92be8

--
You are receiving this mail because:
You are the assignee for the bug.