Bug 327122

Summary: f-spot does not start on 10.3
Product: [openSUSE] openSUSE 10.3 Reporter: Tim Lee <timlee>
Component: MonoAssignee: Larry Ewing <lewing>
Status: RESOLVED FIXED QA Contact: E-mail List <qa-bugs>
Severity: Major    
Priority: P5 - None CC: francis, mmeeks, regis
Version: RC 1   
Target Milestone: ---   
Hardware: i686   
OS: Other   
Whiteboard:
Found By: Integration Test Services Priority:
Business Priority: Blocker: ---
Marketing QA Status: --- IT Deployment: ---

Description Tim Lee 2007-09-21 13:41:48 UTC
- clean install of RC1 of 10.3
- About 2 hours after booting the machine I connected a USB camera and got an Import pictures dialog
- Clicked Import, but f-spot never came up. However the f-spot process was consuming around ~65% of CPU
- Started f-spot from command line and got:


$ f-spot
Initializing Mono.Addins
Starting new FSpot server
XXXXX
Mono.Data.SqliteClient.SqliteSyntaxException: file is encrypted or is not a database
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart, System.IntPtr& pzTail, System.IntPtr& pStmt) [0x00000] 
  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 Mono.Data.SqliteClient.SqliteCommand.ExecuteScalar () [0x00000] 
  at Banshee.Database.QueuedSqliteCommand.Execute () [0x00000] 
XXXXX
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server
Can't get a connection to the dbus. Trying again...
Starting new FSpot server



At the same time dbus-monitor showed
==================================================================================
signal sender=org.freedesktop.DBus -> dest=:1.19 path=/org/freedesktop/DBus; int
   string ":1.19"
method call sender=:1.19 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "type='method_call'"
method call sender=:1.19 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "type='method_return'"
method call sender=:1.19 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "type='error'"
signal sender=org.freedesktop.DBus -> dest=(null destination) path=/org/freedesk
   string ":1.20"
   string ""
   string ":1.20"
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
signal sender=org.freedesktop.DBus -> dest=(null destination) path=/org/freedesk
   string "org.gnome.FSpot"
   string ""
   string ":1.20"
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
   uint32 4
signal sender=org.freedesktop.DBus -> dest=(null destination) path=/org/freedesk
   string "org.gnome.FSpot"
   string ":1.20"
   string ""
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
method call sender=:1.20 -> dest=org.freedesktop.DBus path=/org/freedesktop/DBus
   string "org.gnome.FSpot"
Comment 1 Larry Ewing 2007-09-24 21:07:36 UTC
I can't reproduce this.  What kind of camera?  The error sounds like there might have been an old database in the directory?
Comment 2 Tim Lee 2007-09-26 17:20:25 UTC
The camera is a Canon A520. I had copied my home directory from my SLED 10 SP1 partition. However when I run f-spot from a new user account (without the camera connected) I get an error dialog with this:


An unhandled exception was thrown: F-Spot cannot find the Dbus session bus.  Make sure dbus is configured properly or start a new session for f-spot using "dbus-launch f-spot"

  at FSpot.Driver.Main (System.String[] args) [0x00000] 
.NET Version: 2.0.50727.42

Assembly Version Information:

gdk-sharp (2.10.0.0)
gnome-vfs-sharp (2.16.0.0)
Mono.Addins (0.2.0.0)
NDesk.DBus.GLib (0.3.0.0)
NDesk.DBus (1.0.0.0)
System (2.0.0.0)
Mono.Posix (2.0.0.0)
atk-sharp (2.10.0.0)
gtk-sharp (2.10.0.0)
Mono.Addins.Setup (0.2.0.0)
glib-sharp (2.10.0.0)
gnome-sharp (2.16.0.0)
f-spot (0.4.0.0)
Mono.GetOptions (2.0.0.0)
mscorlib (2.0.0.0)

Platform Information: Linux 2.6.22.5-25-default i686 i386 GNU/Linux

Distribution Information:

[/etc/lsb-release]
LSB_VERSION="core-2.0-noarch:core-3.0-noarch:core-2.0-ia32:core-3.0-ia32"

[/etc/SuSE-release]
openSUSE 10.3 (i586)
VERSION = 10.3

Comment 3 Tim Lee 2007-09-26 17:31:51 UTC
`dbus-launch f-spot` works for a new user account, however if I run it in my SLED 10 home directory the gui never comes up and at the command line get:

$ dbus-launch f-spot
Initializing Mono.Addins
Starting new FSpot server

Unhandled Exception: Mono.Data.SqliteClient.SqliteSyntaxException: file is encrypted or is not a database
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart, System.IntPtr& pzTail, System.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] 
Comment 4 Boyd Timothy 2007-10-17 17:48:00 UTC
Sounds like you hit the same problem I did in https://bugzilla.novell.com/show_bug.cgi?id=331844.

Running the following command should fix your database up and allow you to run the newer f-spot:

f-spot-sqlite-upgrade
Comment 5 JP Rosevear 2007-10-24 14:33:42 UTC
*** Bug 331844 has been marked as a duplicate of this bug. ***
Comment 6 JP Rosevear 2007-10-29 16:05:09 UTC
Packages with with a fixed requires will appear at:
http://download.opensuse.org/repositories/home:/jproseve/openSUSE_10.3/

shortly, please test.
Comment 7 Tim Lee 2007-10-29 16:33:58 UTC
downloaded and installed f-spot-0.4.0-34.1.i586.rpm from URL above. After installing 0.4.0-34.1, f-spot started normally and the UI came up correctly. Two notes.

* The fixed package 0.4.0-34.1 has a new dependency on sqlite2.

* The version of f-spot in the final release of 10.3 is 0.4.0-35, so I had to remove the existing f-spot package before I could install JP's 0.4.0-34.1 package.
Comment 8 JP Rosevear 2007-10-29 17:56:33 UTC
(In reply to comment #7 from Tim Lee)
> downloaded and installed f-spot-0.4.0-34.1.i586.rpm from URL above. After
> installing 0.4.0-34.1, f-spot started normally and the UI came up correctly.
> Two notes.
> 
> * The fixed package 0.4.0-34.1 has a new dependency on sqlite2.

Yes, this is the fix.  In order to convert from old versions of f-spot it needs tools from sqlite2.

> * The version of f-spot in the final release of 10.3 is 0.4.0-35, so I had to
> remove the existing f-spot package before I could install JP's 0.4.0-34.1
> package.

Yes, I just built from the build service without paying attention to the rev.

Thanks Tim.

Comment 9 JP Rosevear 2007-12-12 19:46:08 UTC
Fix submitted to Factory.
Comment 10 Regis Fauquet 2007-12-19 00:58:41 UTC
I encountered the same issue even though I ran f-spot version 0.4.0-35 and my database was already upgraded.
Installing sqlite2 was what did the trick on my system.
Comment 11 JP Rosevear 2008-03-25 18:46:29 UTC
Released for 10.3 a few weeks ago.
Comment 12 JP Rosevear 2008-03-26 14:25:12 UTC
*** Bug 351745 has been marked as a duplicate of this bug. ***