[Digikam-devel] [digikam] [Bug 322642] New: Corrupt Tags table after digikam termination

[Philipp Hahn]

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

            Bug ID: 322642
           Summary: Corrupt Tags table after digikam termination
    Classification: Unclassified
           Product: digikam
           Version: 3.2.0
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: crash
          Priority: NOR
         Component: Database
          Assignee: digikam-devel at kde.org
          Reporter: pmhahn+kde at pmhahn.de

After a crash of digikam the Tags table was corrupted: the lft and rgt values
were inconsistend and several old tags were missing.
I was able to re-construct most of the table by hand.

Reproducible: Didn't try

Steps to Reproduce:
1. After GPS correlating several pictures I used the feature to reverse-tag
those pictures. For some new cities multiple tags were created.
2. I removed some of those duplicate tags.
3. Digikam consumed 100% for a very long time, so I termincated it
4. After a restart several tags were missing: As one country tag was removed,
all subtags were missing as well. They were still in the table, but
unreachable.



The Tags-table corruption is similar to Bug 298929. I was able to re-insert
most of the missing tags by hand and re-constructing the lft,rgt values by
following
<http://stackoverflow.com/questions/3623645/how-to-repair-a-corrupted-mptt-tree-nested-set-in-the-database-using-sql>

Bug 309061 describes a bug when deleting tags.

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