[Digikam-devel] [digikam] [Bug 322642] New: Corrupt Tags table after digikam termination
Philipp Hahn
pmhahn+kde at pmhahn.de
Sun Jul 21 07:59:41 BST 2013
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.
More information about the Digikam-devel
mailing list