GNOME Bugzilla – Bug 572309
f-spot crashes and destroys photos.db when / is full.
Last modified: 2009-02-19 22:19:02 UTC
Steps to reproduce: 1. Fill your / partition with random data until it's full. 2. Launch f-spot : it crashes (see stack trace) 3. See for yourself : the photos.db file is now only 3 kbytes in size. 4. f-spot will refuse to launch with the same error until there is some room on / 5. If you make room, the next launch will be successful but with a warning message and a new blank database. Stack trace: [Info 19:40:37.274] Initializing DBus [Info 19:40:37.531] Initializing Mono.Addins [Info 19:40:38.060] Starting new FSpot server Unhandled Exception: Mono.Data.SqliteClient.SqliteExecutionException: SQL logic error or missing database at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) [0x00000] at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt) [0x00000] at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] at Banshee.Database.QueuedSqliteCommand.Execute () [0x00000] Other information: F-spot is a really great software, i.e. a killer app in my opinion (Of all the people - macintosh or windows user - I did show f-spot to, every last one of them was very impressed and quite envious). Thanks for that great work !
do you have a photos.db.* in your home (or where you abitually run f-spot from?)
I actually do have some photos.db.* files in my home. Their sizes and date are coherent with the crashes I (voluntarily or not) experienced. I didn't know that f-spot saved these files in case of problem. That is a very good thing. Alek.
known issue with db... copy one of those photos.db.* on .gnome2/f-spot/photos.db , you should magically have your collection back ;) *** This bug has been marked as a duplicate of 322541 ***
There is a slight difference between my report and the bug 322541. In my case, the root partition is full, but not my home directory (which lies on a specifc partition) where photos.db is located.
the exception is about sql. f-spot correctly catches errors on photo files IO. I'm 99.9% sure the error is about sqlite. wondering if it writes something to /tmp maybe...