[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


           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