F-Spot dies on SQLite error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
| f-spot (Ubuntu) |
Medium
|
Unassigned |
Bug Description
Binary package hint: f-spot
Running f-spot 0.6.1.5-0ubuntu1 on Karmic (9.10) on a Dell Laptop.
Tried to start F-Spot from a terminal. Instead it crashed.
These are the messages I get when I try to run F-Spot from a terminal.
[Info 12:12:51.226] Initializing DBus
[Info 12:12:51.347] Initializing Mono.Addins
[Info 12:12:51.500] Starting new FSpot server (f-spot 0.6.1.5)
** (f-spot:6640): CRITICAL **: atk_object_
** (f-spot:6640): CRITICAL **: atk_object_
** (f-spot:6640): CRITICAL **: atk_object_
** (f-spot:6640): CRITICAL **: atk_object_
** (f-spot:6640): CRITICAL **: atk_object_
[Warn 12:12:51.857] Caught an exception - SQL logic error or missing database (in `Mono.Data.
at Mono.Data.
at (wrapper remoting-
at Mono.Data.
at Mono.Data.
at (wrapper remoting-
at Mono.Data.
at Mono.Data.
at Mono.Data.
at (wrapper remoting-
at Banshee.
Exception has been thrown by the target of an invocation. (in `mscorlib')
at System.
at System.
at System.
at System.
at Mono.Addins.
at Mono.Addins.
at FSpot.Widgets.
at MainWindow.
at Mono.Addins.
at Mono.Addins.
at Mono.Addins.
at Mono.Addins.
at Mono.Addins.
at Mono.Addins.
at FSpot.Extension
at FSpot.Extension
at FSpot.Widgets.
at FSpot.Widgets.
at MainWindow..ctor (.Db db) [0x00000]
at FSpot.Core.
at FSpot.Core.Organize () [0x00000]
at FSpot.Driver.Main (System.String[] args) [0x00000]
ProblemType: Bug
Architecture: i386
Date: Wed Nov 25 12:27:22 2009
DistroRelease: Ubuntu 9.10
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
NonfreeKernelMo
Package: f-spot 0.6.1.5-0ubuntu1
ProcEnviron:
PATH=(custom, user)
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSign
SourcePackage: f-spot
Uname: Linux 2.6.31-15-generic i686
Jack C. Holt (jackcholt) wrote : | #1 |
Jack C. Holt (jackcholt) wrote : | #2 |
Jack C. Holt (jackcholt) wrote : | #3 |
I also uninstalled and then reinstalled F-Spot to make sure that it wasn't simply missing a dependency that I had perhaps inadvertently deleted.
zvpunry (miloeffler) wrote : | #4 |
I had the same error message (on debian sid). But i found the problem in the database:
i stopped f-spot an then:
cd ~/.config/f-spot/
cp -a photos.db photos.db.backup
sqlite3 photos.db .dump > photos.db.dump
rm photos.db
sqlite3 photos.db < photos.db.dump
Error: near line 13669: constraint failed
then i looked at line 13669 and found this: INSERT INTO "photo_versions" VALUES(
i deleted that statement and restored the db again (without error), and now it works again.
Jack C. Holt (jackcholt) wrote : | #5 |
Thanks zvpunry.
That did it. My F-Spot now works also.
zvpunry (miloeffler) wrote : | #6 |
I have opened a raw file with ufraw (direct from the context menu of f-spot), it asked if i want to create a new version but then i deleted this version... maybe this caused the bug?
Changed in f-spot (Ubuntu): | |
importance: | Undecided → Medium |
elsaturnino (elsaturnino-gmail) wrote : | #7 |
I ran into the same problem but when I followed zvpunry's suggested fix, I didn't get an error when restoring. Instead, after I tried to open f-spot I received the following error:
Unhandled Exception: Mono.Data.
at Mono.Data.
at Mono.Data.
at Mono.Data.
at Mono.Data.
at Banshee.
There is a file called photos.db so it's not a missing file problem. I did notice that the original photos.db file was set to executable but the new version wasn't. I chmod +x'd it but still get the same error :(
I should also add that I am using the Dust theme so as not to confuse this with issue 411941.