I did

$ echo .dump | sqlite3 ~/.shotwell/data/photo.db | grep 
IMG_6016_CR2_shotwell.jpg
INSERT INTO "TombstoneTable" 
VALUES(862,'/home/roland/Pictures/CanonT1i-images/2012/06/05/IMG_6016_CR2_shotwell.jpg',4635334,NULL,1340417401,0);
INSERT INTO "TombstoneTable" 
VALUES(3083,'/home/roland/Pictures/CanonT1i-images/2012/06/05/IMG_6016_CR2_shotwell.jpg',4635334,'1b96783ac21dbdf66181828b8b49dbcb',1340417401,0);
INSERT INTO "BackingPhotoTable" 
VALUES(1573,'/home/roland/Pictures/CanonT1i-images/2012/06/05/IMG_6016_CR2_shotwell.jpg',1339313673,4635334,3465,5202,1,0,1339313673);

so indeed there are two rows in the TombstoneTable with the same
filename but different instance ids.

Is this a violation of the design of the database?  No idea exactly how
things got into this state, except that I did delete some shotwell-
generated files to clear up disk space at some point.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1016859

Title:
  shotwell crashes on startup

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/shotwell/+bug/1016859/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to