Re: f-spot 0.4.0 hangs (ubuntu gutsy)

[Emanuele Olivetti <emanuele relativita com>]

Lorenzo Milesi wrote:
> Emanuele Olivetti ha scritto:
>> Which is the right way to proceed in order to collect infos and
>> being able to collect the necessary details? How can I solve this
>> issue?
>>   
> until someone with more (useful) ideas shows up, I'd suggest to post the
> output of f-spot run from command line and of:
>
> $ file .gnome2/f-spot/photos.db
>
>
> Sometimes I have a similar problem to your: creating a new tag takes 2/3
> minutes of 100% cpu time. but if I close and reopen f-spot it returns
> normal.
>
> ciao
>


Here is the "file" command running on db:

foto arale:~$ file .gnome2/f-spot/photos.db
.gnome2/f-spot/photos.db: SQLite 2.x database


Here is the log of running f-spot, selecting _one_ image (left-click)
and dragging an icon-tag over it:
------------------------
foto arale:~$ 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

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

(f-spot:14439): 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/foto/Photos/2004/6/13/img_2418.jpg
open uri = file:///home/foto/Photos/2004/6/13/img_2418.jpg
open uri = file:///home/foto/Photos/2005/04/30/IMG_3838.JPG
open uri = file:///home/foto/Photos/2005/04/30/IMG_3838.JPG
open uri = file:///home/foto/Photos/2005/05/01/IMG_3846.JPG

(f-spot:14439): 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.

Unhandled Exception: System.ArgumentOutOfRangeException: Index is less
than 0 or more than or equal to the list count.
Parameter name: index
-1
  at System.Collections.ArrayList.get_Item (Int32 index) [0x00000]
  at Mono.Data.SqliteClient.SqliteParameterCollection.GetParameter (Int32
parameterIndex) [0x00000]
  at System.Data.Common.DbParameterCollection.get_Item (Int32 index)
[0x00000]
  at System.Data.Common.DbParameterCollection.get_Item (System.String
parameterName) [0x00000]
  at (wrapper remoting-invoke-with-check)
System.Data.Common.DbParameterCollection:get_Item (string)
  at Mono.Data.SqliteClient.SqliteCommand.BindParameters2 () [0x00000]
  at Mono.Data.SqliteClient.SqliteCommand.Prepare () [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]

---- Then f-spot hangs indefinitely. CTRL-C to kill it.

Other info: linux box i386 (ubuntu gutsy just updated), f-spot 0.4.0
provided
by ubuntu.

Hope this can help.


Thanks in advance,

Emanuele