Ubuntu
f-spot package

F-Spot dies on SQLite error

Bug #488428 reported by Jack C. Holt
22
This bug affects 3 people
Affects Status Importance Assigned to Milestone
f-spot (Ubuntu)
New
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_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

Revision history for this message
Jack C. Holt (jackcholt) wrote :
Revision history for this message
Jack C. Holt (jackcholt) wrote :

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

Revision history for this message
Jack C. Holt (jackcholt) wrote :

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.

Revision history for this message
zvpunry (miloeffler) wrote :

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.

Revision history for this message
Jack C. Holt (jackcholt) wrote :

Thanks zvpunry.

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

Revision history for this message
zvpunry (miloeffler) wrote :

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?

Pedro Villavicencio (pedro)
Changed in f-spot (Ubuntu):
importance: Undecided → Medium
Revision history for this message
elsaturnino (elsaturnino-gmail) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.