can't import - f-spot freeze whenever I want to import new photos

Bug #182361 reported by Psykotik
4
Affects Status Importance Assigned to Milestone
f-spot (Ubuntu)
Invalid
Medium
Maia Everett
Nominated for Intrepid by savantelite

Bug Description

Binary package hint: f-spot

I use f-spot since a lot of time. I have never had any issue, since today.

I'm trying to add new photos to database, but can't do it anymore since f-spot freeze as soon as I try to do so. I use f-spot 0.4.0-0ubuntu3 on Ubuntu 7.10. It doesn't seem to be related to "database locked" bug (https://bugs.launchpad.net/ubuntu/+source/f-spot/+bug/129218).

Here is the console log :

----

psykotik@psykotik-desktop:~$ f-spot
Initializing Mono.Addins
Starting new FSpot server
Query: SELECT photos.id, photos.time, photos.directory_path, photos.name, photos.description, photos.roll_id, photos.default_version_id FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY photos.time
Query: SELECT photos.id, photos.time, photos.directory_path, photos.name, photos.description, photos.roll_id, photos.default_version_id FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY photos.time
Query: SELECT photos.id, photos.time, photos.directory_path, photos.name, photos.description, photos.roll_id, photos.default_version_id FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY photos.time

(f-spot:18631): Gtk-WARNING **: gtk_menu_attach_to_widget(): menu already attached to GtkMenuItem

(f-spot:18631): Gtk-WARNING **: gtk_menu_attach_to_widget(): menu already attached to GtkMenuItem
Query: SELECT photos.id, photos.time, photos.directory_path, photos.name, photos.description, photos.roll_id, photos.default_version_id FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY photos.time
Reloading
Query: SELECT photos.id, photos.time, photos.directory_path, photos.name, photos.description, photos.roll_id, photos.default_version_id FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY photos.time
item changed
open uri = file:///home/psykotik/images/Perso/Joaquin Jose Martinez/IMG_4130.JPG
open uri = file:///home/psykotik/images/Perso/Joaquin Jose Martinez/IMG_4130.JPG
open uri = file:///home/psykotik/images/Perso/Joaquin Jose Martinez/IMG_4130.JPG
open uri = file:///home/psykotik/images/Perso/Joaquin Jose Martinez/IMG_4130.JPG

(f-spot:18631): GdkPixbuf-WARNING **: GdkPixbufLoader finalized without calling gdk_pixbuf_loader_close() - this is not allowed. You must explicitly end the data stream to the loader before dropping the last reference.
WinXP_Datas - gnome-dev-harddisk - Mountpoint file:///media/XPdatas True True Harddrive
Harddrive
WINXP - gnome-dev-harddisk - Mountpoint file:///media/WinXP True True Harddrive
Harddrive
item ImportCommand+SourceItem
Scanning /Misc/Perso/Matteo anni - Antoine 11.1.08

Unhandled Exception: Mono.Data.SqliteClient.SqliteBusyException: The database is locked.
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) [0x00000]
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (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]

Revision history for this message
Psykotik (linux-ikiru) wrote :

If I stop "beagled" process, I don't see the error.

I run Beagle 0.3.1.

Maia Everett (linneris)
Changed in f-spot:
importance: Undecided → Medium
Revision history for this message
Maia Everett (linneris) wrote :

Some SQLite issues have been fixed in the current Hardy version. Could you please verify if this issue still persists there?

Changed in f-spot:
assignee: nobody → sikon
status: New → 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
Revision history for this message
Psykotik (linux-ikiru) wrote :

reopened by the author

Changed in f-spot:
status: Invalid → New
Revision history for this message
Psykotik (linux-ikiru) wrote :

Since I do not have a "current hardy version", I cannot check if this issue is fixed.

Please, let it open, since this very issue is still active on 7.10

Revision history for this message
savantelite (savantelite) wrote :

I am running intrepid and f-spot freezes when I try to import photos with my Sony Cyber Shot DSC-W120.

F-spot worked fine with camera on different computer running Herron

Revision history for this message
Pedro Villavicencio (pedro) wrote :

i don't think it's the same issue, please open a new bug report.

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

Other bug subscribers

Remote bug watches

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