[Digikam-devel] [Bug 192374] New: Severe Album and Images table corruption

[Dany]

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

           Summary: Severe Album and Images table corruption
           Product: digikam
           Version: unspecified
          Platform: Ubuntu Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: crash
          Priority: NOR
         Component: general
        AssignedTo: digikam-devel at kde.org
        ReportedBy: dany at natzo.com


Version:           0.10.0-1ubuntu3 (using KDE 4.2.1)
OS:                Linux
Installed from:    Ubuntu Packages

I recently moved my pictures from iMatch to Digikam 0.10.0-1ubuntu3 (Ubuntu
9.04 Jaunty).

My digikam4.db is about 11MB and contains the following items:

- 1 albumroot
- 444 albums
- 15323 images (tiff, jpg, dng) with built-in tags
- 242 tags
- 574 tagtree items

I was adding some tags to some of the pictures when Digikam crashed. However
this time when I restarted it back the library was empty...and I felt very bad!
I looked at the database content using an SQLite browser and found out that all
the pictures data have been corrupted in a snap.

Here is the result of my investigation.

** AlbumRoots Table **
"id","label","status","type","identifier","specificPath"
"1","ORIGINALS-DNG","0","1","volumeid:?uuid=DCA8EED3A8EEAB6A","/PHOTOS/ORIGINALS-DNG"

--> No problem on this one.


** Albums table **
"id","albumRoot","relativePath","date","caption","collection","icon"
"1","0","1-/","2009-03-01","","",""
"2","0","1-/1999-12","2009-01-14","","",""
"3","0","1-/1999-12/Scans","2009-04-24","","",""
"4","0","1-/2000-10","2008-07-15","","",""
"5","0","1-/2000-10/Fly_Surf","2009-04-25","","",""
"6","0","1-/2000-10/Le_Luc","2009-04-24","","",""
...
--> "albumRoot" column is corrupted (all rows)... it should be "1" not "0"
--> "relativePath" is corrupted (all rows)... i.e. "1-/1999-12/Scan" should be
"/1999-12/Scan"


** Images table **
"id","album","name","status","category","modificationDate","fileSize","uniqueHash"
"1","","1999-12_955_Noir.tif","3","1","2007-01-12T02:58:41","4328652","eaee50804f7ddfe244eebf2385c43a19"
"2","","1999-12_955_Rouge.tif","3","1","2007-01-12T02:58:43","4387788","8334c19a77cd95f56d7bebac262c5383"
"3","","1999-12_Bebe.tif","3","1","2009-04-25T22:46:20","5428320","4967c779c5f9fb63fcbf9e79c34ee07c"

--> "album" number has been wiped out for each image... how can this be
recovered besides reimporting the pictures?
--> "status" column is corrupted (all rows)...it should be "1" and not "3"


 Restoring some of the table to their original content almost fixed the problem
however the image table is still missing links to albums. I rescanned the album
and the pictures appeared again but then the database needed some cleaning
still contains orphaned entries.

I'm now so scared to use DigiKam again. Is there any way to have at least an
automatic backup of the database?

I'm sorry but I don't have any backtrace to show, only the corrupted database. 
Thank you
Dany

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.