[Digikam-devel] [Bug 272301] New: database corruption upon tag hierarchy removal
Ilia K.
mail4ilia at gmail.com
Tue May 3 03:46:48 BST 2011
https://bugs.kde.org/show_bug.cgi?id=272301
Summary: database corruption upon tag hierarchy removal
Product: digikam
Version: 2.0.0
Platform: Unlisted Binaries
OS/Version: Linux
Status: UNCONFIRMED
Severity: major
Priority: NOR
Component: Database
AssignedTo: digikam-devel at kde.org
ReportedBy: mail4ilia at gmail.com
Version: 2.0.0 (using KDE 4.6.2)
OS: Linux
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).
Reproducible: Always
Steps to Reproduce:
1. Create nested tags /tag1/tag2/tag3
2. Delete tag1 (this deletes tag2 & tag3 as well)
3. Restart digikam
Actual Results:
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).
Expected Results:
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
mailing list