[Digikam-devel] [Bug 272301] New: database corruption upon tag hierarchy removal
mail4ilia at gmail.com
Tue May 3 03:46:48 BST 2011
Summary: database corruption upon tag hierarchy removal
Platform: Unlisted Binaries
AssignedTo: digikam-devel at kde.org
ReportedBy: mail4ilia at gmail.com
Version: 2.0.0 (using KDE 4.6.2)
I'm running digikam 2.0-beta4 from philip5 PPA for Kubuntu 10.10.
I use mysql 5.1 database from Ubuntu 10.04 as DB storage. My collection has
right now 30-50 tags and several thousands photos (thank goodness I have all
metadata in files!).
When non-leaf tag is deleted, other tags may be deleted from the database or
become unreachable from the root (which hides them in GUI). I guess it may be a
bug in SQL queries (e.g. deletion triggers and maybe interaction between them,
or missed locking).
Steps to Reproduce:
1. Create nested tags /tag1/tag2/tag3
2. Delete tag1 (this deletes tag2 & tag3 as well)
3. Restart digikam
Some or all tags are missing due to inconsistent Tags table (and maybe others).
I haven't noticed other tags being affected if instead of step 2 above I delete
tag3, then tag2, then tag1 (i.e. each time delete a leaf tag).
All non-related tags are unaffected
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Digikam-devel