[Digikam-devel] [Bug 272301] New: database corruption upon tag hierarchy removal

[Ilia K.]

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.