F-Spot dies on SQLite error

[Jack C. Holt]

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_set_name: assertion `name != NULL' failed

** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed

** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed

** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed

** (f-spot:6640): CRITICAL **: atk_object_set_name: assertion `name != NULL' failed

[Warn 12:12:51.857] Caught an exception - SQL logic error or missing database (in `Mono.Data.SqliteClient')

  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) [0x00000]

  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteCommand:ExecuteStatement (intptr,int&,intptr&,intptr&)

  at Mono.Data.SqliteClient.SqliteDataReader.ReadpVm (IntPtr pVm, Int32 version, Mono.Data.SqliteClient.SqliteCommand cmd) [0x00000]

  at Mono.Data.SqliteClient.SqliteDataReader..ctor (Mono.Data.SqliteClient.SqliteCommand cmd, IntPtr pVm, Int32 version) [0x00000]

  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteDataReader:.ctor (Mono.Data.SqliteClient.SqliteCommand,intptr,int)

  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000]

  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000]

  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader () [0x00000]

  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteCommand:ExecuteReader ()

  at Banshee.Database.QueuedSqliteCommand.Execute () [0x00000]

Exception has been thrown by the target of an invocation. (in `mscorlib')

  at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000]

  at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000]

  at System.Reflection.ConstructorInfo.Invoke (System.Object[] parameters) [0x00000]

  at System.Activator.CreateInstance (System.Type type, Boolean nonPublic) [0x00000]

  at Mono.Addins.RuntimeAddin.CreateInstance (System.String typeName, Boolean throwIfNotFound) [0x00000]

  at Mono.Addins.RuntimeAddin.CreateInstance (System.String typeName) [0x00000]

  at FSpot.Widgets.SidebarPageNode.GetSidebarPage () [0x00000]

  at MainWindow.OnSidebarExtensionChanged (System.Object s, Mono.Addins.ExtensionNodeEventArgs args) [0x00000]

  at Mono.Addins.ExtensionNode.OnChildNodeAdded (Mono.Addins.ExtensionNode node) [0x00000]

  at Mono.Addins.ExtensionNode.NotifyChildChanged () [0x00000]

  at Mono.Addins.TreeNode.NotifyChildrenChanged () [0x00000]

  at Mono.Addins.ExtensionContext.NotifyConditionChanged (Mono.Addins.ConditionType cond) [0x00000]

  at Mono.Addins.ExtensionContext.OnConditionChanged (System.Object s, System.EventArgs a) [0x00000]

  at Mono.Addins.ConditionType.NotifyChanged () [0x00000]

  at FSpot.Extensions.ViewModeCondition.<ViewModeCondition>m__5 () [0x00000]

  at FSpot.Extensions.ViewModeCondition.set_Mode (ViewMode value) [0x00000]

  at FSpot.Widgets.Sidebar.HandleContextChanged (System.Object sender, System.EventArgs args) [0x00000]

  at FSpot.Widgets.Sidebar.set_Context (ViewContext value) [0x00000]

  at MainWindow..ctor (.Db db) [0x00000]

  at FSpot.Core.get_MainWindow () [0x00000]

  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)
NonfreeKernelModules: nvidia
Package: f-spot 0.6.1.5-0ubuntu1
ProcEnviron:
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-15.50-generic
SourcePackage: f-spot
Uname: Linux 2.6.31-15-generic i686

[Jack C. Holt (jackcholt)]

I should also add that I am using the Dust theme so as not to confuse this with issue 411941.

[Jack C. Holt (jackcholt)]

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)]

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(NULL,NULL,NULL,NULL,NULL,NULL,NULL);

i deleted that statement and restored the db again (without error), and now it works again.

[Jack C. Holt (jackcholt)]

Thanks zvpunry.

That did it. My F-Spot now works also.

[zvpunry (miloeffler)]

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?

[elsaturnino (elsaturnino-gmail)]

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.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] in <filename unknown>:0
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt) [0x00000] in <filename unknown>:0
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] in <filename unknown>:0
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] in <filename unknown>:0
  at Banshee.Database.QueuedSqliteCommand.Execute () [0x00000] in <filename unknown>:0

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 :(