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:
[hidden email]
ReportedBy:
[hidden email]
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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Locked
