Comment 4 for bug 441596

I had the same problem. Best output I could get was

f-spot --debug
** Running f-spot in Debug Mode **
** Running Mono with --debug **
[Info 22:58:25.251] Initializing DBus
[Debug 22:58:25.723] DBusInitialization took 0.426689s
[Info 22:58:25.723] Initializing Mono.Addins
[Debug 22:58:26.408] Mono.Addins Initialization took 0.68464s
[Info 22:58:26.460] Starting new FSpot server (f-spot 0.6.1.3)
[Debug 22:58:26.937] Db Initialization took 0.227139s
[Debug 22:58:27.965] Query Started : SELECT * FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY time DESC, filename DESC
[Debug 22:58:27.967] QueryToTemp took 0.002191s : SELECT * FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY time DESC, filename DESC
[Debug 22:58:27.968] Reloading the query took 0.011748s
[Debug 22:58:28.266] PhotosPerMonth took 0.021088s
[Debug 22:58:28.277] TimeAdaptor REAL Reload took 0.239155s
[Debug 22:58:28.848] Query Started : SELECT * FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY time DESC, filename DESC
[Debug 22:58:28.859] QueryToTemp took 0.010771s : SELECT * FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY time DESC, filename DESC
[Debug 22:58:28.998] Reloading the query took 0.152216s
[Debug 22:58:29.010] Query Started : SELECT * FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY time DESC, filename DESC
[Debug 22:58:29.014] QueryToTemp took 0.003862s : SELECT * FROM photos WHERE photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY time DESC, filename DESC
[Debug 22:58:29.027] Reloading the query took 0.018058s
[Info 22:58:29.041] Starting BeagleService
[Debug 22:58:29.044] BeagleService startup took 3.7E-05s
[Debug 22:58:29.086] PhotosPerMonth took 0.012301s
[Debug 22:58:29.088] TimeAdaptor REAL Reload took 0.072808s
[Info 22:58:29.123] Hack for gnome-settings-daemon engaged

(f-spot:1973): 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.
[Debug 22:58:29.240] PhotosPerMonth took 0.019861s
[Debug 22:58:29.240] TimeAdaptor REAL Reload took 0.225377s
The program 'f-spot' received an X Window System error.
This probably reflects a bug in the program.
The error was 'BadAlloc (insufficient resources for operation)'.
  (Details: serial 3810 error_code 11 request_code 53 minor_code 0)
  (Note to programmers: normally, X errors are reported asynchronously;
   that is, you will receive the error a while after causing it.
   To debug your program, run it with the --sync command line
   option to change this behavior. You can then get a meaningful
   backtrace from your debugger if you break on the gdk_x_error() function.)