f-spot crashes at startup complains about "Unsupported database version" - Bad error message when NFS locking fails

Bug #63484 reported by Roberto Rosario
6
Affects Status Importance Assigned to Milestone
F-Spot
New
Undecided
Unassigned
f-spot (Ubuntu)
Invalid
Low
Ubuntu Desktop Bugs

Bug Description

Happens at every try.

Ubuntu Edgy workstation upgraded from Drapper using synaptic

f-spot 0.2.1-0ubuntu1
mono-common 1.1.17.1-1ubuntu5
libsqlite3-0 3.3.5-0.2

The music manager program Banshee throws the same message at startup.

Starting new FSpot server
XXXXX
System.Exception: Unsupported database version
  at Db.Init (System.String path, Boolean create_if_missing) [0x00000]
  at FSpot.Core..ctor () [0x00000]
  at FSpot.Driver.Main (System.String[] args) [0x00000]
XXXXX
Starting new FSpot server

Revision history for this message
Roberto Rosario (roberto-rosario-gonzalez) wrote :
Revision history for this message
Andrew Mitchell (ajmitch) wrote :

I presume that at sometime in the past you ran F-Spot from universe, from when it was using sqlite 2.x by default (this was changed early in dapper development)

To convert your database, install both sqlite & sqlite3, then run 'sqlite ~/.gnome2/f-spot/photos.db .dump | sqlite3 ~/.gnome2/f-spot/photos.db'.

The reason that sqlite2 is not still a dependency of f-spot, is that we do not want to have the old library still supported in main, as it has some issues which were fixed in the redesign resulting in sqlite3.

Revision history for this message
Roberto Rosario (roberto-rosario-gonzalez) wrote :

No, this is the first time I'm trying f-spot.
Trying to manipulate photo.db with sqlite in anyway returns "Database locked" even though lsof 'photo.db' returns nothing.

My home directory is NFS mounted, so after much head-scratching it turned out to be an NFS client side locking issue, installing 'nfs-common' on the client machine, remounting /home and deleting photo.db solved the problem.

Thanks for the help, just wished the error message would have been less misleading.

http://mail.gnome.org/archives/f-spot-list/2005-February/msg00018.html
http://r0ver-linux.blogspot.com/
http://bugzilla.gnome.org/show_bug.cgi?id=167647

Revision history for this message
Roberto Rosario (roberto-rosario-gonzalez) wrote :

/home directory was NFS mounted and client side locking was not enabled. Error message was misleading. Installing 'nfs-common' so that rpc.statd executes solved the problem.

Changed in f-spot:
status: Unconfirmed → Confirmed
Revision history for this message
Andrew Mitchell (ajmitch) wrote :

Ah, thanks for that. Yes, the error message is very misleading & says nothing about locking at all - a great way to confuse the user. I'll retitle the bug.

Maia Everett (linneris)
Changed in f-spot:
importance: Undecided → Medium
status: Confirmed → Triaged
Maia Everett (linneris)
Changed in f-spot:
importance: Medium → Low
Revision history for this message
Pedro Villavicencio (pedro) wrote :

still an issue with intrepid? may someone having the behavior could send this upstream at bugzilla.gnome.org? thanks.

Changed in f-spot:
assignee: nobody → desktop-bugs
status: Triaged → Incomplete
Revision history for this message
Pedro Villavicencio (pedro) wrote :

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to New. Thanks again!.

Changed in f-spot:
status: Incomplete → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

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