f-spot crashes from integer conversion exception

Bug #678245 reported by Cris Jansson
18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
F-Spot
Won't Fix
Critical
f-spot (Ubuntu)
Fix Released
Undecided
Unassigned

Bug Description

Binary package hint: f-spot

After scrolling through the "date bar" to an earlier date, f-spot crashes with an exception. My photo collection has about 9200 images. Some of the images were imported with an earlier version of f-spot. It only occurs with the older photos, so it maybe a particular one.

Tail of f-spot --debug:

[4 Debug 13:03:59.656] Invalid thumbnail, reloading: file:///home/crj/Pictures/Photos/2003/05/01/img_0246.jpg
[4 Debug 13:03:59.670] open uri = file:///home/crj/Pictures/Photos/2003/05/01/img_0246.jpg
[4 Debug 13:04:00.102] Invalid thumbnail, reloading: file:///home/crj/Pictures/Photos/2003/05/04/img_0252.jpg
[4 Debug 13:04:00.104] open uri = file:///home/crj/Pictures/Photos/2003/05/04/img_0252.jpg
[1 Debug 13:04:00.548] IndexOf took 0.015483 : SELECT ROWID AS row_id FROM photoquery_temp_0 WHERE time <= 1049176799 ORDER BY time DESC LIMIT 1
[1 Debug 13:04:00.864] Query took 0.014783 : SELECT * FROM photoquery_temp_0 LIMIT 100 OFFSET 8800
[1 Debug 13:04:00.883] Query took 0.017766 : SELECT * FROM photoquery_temp_0 LIMIT 100 OFFSET 8900
[4 Debug 13:04:01.249] Invalid thumbnail, reloading: file:///home/crj/Pictures/Photos/2003/04/19/img_0190.jpg
[4 Debug 13:04:01.265] open uri = file:///home/crj/Pictures/Photos/2003/04/19/img_0190.jpg
[1 Debug 13:04:01.919] IndexOf took 0.006558 : SELECT ROWID AS row_id FROM photoquery_temp_0 WHERE time <= 1046498399 ORDER BY time DESC LIMIT 1
[1 Debug 13:04:03.070] IndexOf took 0.004456 : SELECT ROWID AS row_id FROM photoquery_temp_0 WHERE time <= 1044079199 ORDER BY time DESC LIMIT 1
[1 Debug 13:04:04.254] IndexOf took 0.005444 : SELECT ROWID AS row_id FROM photoquery_temp_0 WHERE time <= 1041400799 ORDER BY time DESC LIMIT 1
[1 Debug 13:04:05.363] IndexOf took 0.004121 : SELECT ROWID AS row_id FROM photoquery_temp_0 WHERE time <= 1038722399 ORDER BY time DESC LIMIT 1
[5 Debug 13:04:05.481] Exception executing command: SELECT * FROM photoquery_temp_0 LIMIT 100 OFFSET 9200
Marshaling value_changed signal
Exception in Gtk# callback delegate
  Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.OverflowException: Value is greater than Int32.MaxValue or less than Int32.MinValue
  at System.Convert.ToInt32 (Int64 value) [0x00000] in <filename unknown>:0
  at System.Int64.System.IConvertible.ToInt32 (IFormatProvider provider) [0x00000] in <filename unknown>:0
  at System.Convert.ToType (System.Object value, System.Type conversionType, IFormatProvider provider, Boolean try_target_to_type) [0x00000] in <filename unknown>:0
  at System.Convert.ChangeType (System.Object value, System.Type conversionType, IFormatProvider provider) [0x00000] in <filename unknown>:0
  at Mono.Data.Sqlite.Sqlite3.GetValue (Mono.Data.Sqlite.SqliteStatement stmt, Int32 index, Mono.Data.Sqlite.SqliteType typ) [0x00000] in <filename unknown>:0
  at Mono.Data.Sqlite.SqliteDataReader.GetValue (Int32 i) [0x00000] in <filename unknown>:0
  at Hyena.Data.Sqlite.HyenaSqliteArrayDataReader.ReadAllRows (Mono.Data.Sqlite.SqliteDataReader reader) [0x00000] in <filename unknown>:0
  at Hyena.Data.Sqlite.HyenaSqliteArrayDataReader..ctor (Mono.Data.Sqlite.SqliteDataReader reader) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) Hyena.Data.Sqlite.HyenaSqliteArrayDataReader:.ctor (Mono.Data.Sqlite.SqliteDataReader)
  at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Mono.Data.Sqlite.SqliteConnection connection) [0x00000] in <filename unknown>:0
  --- End of inner exception stack trace ---
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in <filename unknown>:0
  at System.Reflection.MethodBase.Invoke (System.Object obj, System.Object[] parameters) [0x00000] in <filename unknown>:0
  at System.Delegate.DynamicInvokeImpl (System.Object[] args) [0x00000] in <filename unknown>:0
  at System.MulticastDelegate.DynamicInvokeImpl (System.Object[] args) [0x00000] in <filename unknown>:0
  at System.Delegate.DynamicInvoke (System.Object[] args) [0x00000] in <filename unknown>:0
  at GLib.Signal.ClosureInvokedCB (System.Object o, GLib.ClosureInvokedArgs args) [0x00000] in <filename unknown>:0
  at GLib.SignalClosure.Invoke (GLib.ClosureInvokedArgs args) [0x00000] in <filename unknown>:0
  at GLib.SignalClosure.MarshalCallback (IntPtr raw_closure, IntPtr return_val, UInt32 n_param_vals, IntPtr param_values, IntPtr invocation_hint, IntPtr marshal_data) [0x00000] in <filename unknown>:0
   at GLib.ExceptionManager.RaiseUnhandledException(System.Exception e, Boolean is_terminal)
   at GLib.SignalClosure.MarshalCallback(IntPtr raw_closure, IntPtr return_val, UInt32 n_param_vals, IntPtr param_values, IntPtr invocation_hint, IntPtr marshal_data)
   at Gtk.Adjustment.gtk_adjustment_set_value(IntPtr , Double )
   at Gtk.Adjustment.set_Value(Double value)
   at FSpot.Widgets.CellGridView.ScrollTo(Int32 cell_num, Boolean center)
   at FSpot.Widgets.CellGridView.ScrollTo(Int32 cell_num)
   at FSpot.MainWindow.JumpTo(Int32 index)
   at FSpot.MainWindow.HandleAdaptorGlassSet(FSpot.GroupAdaptor sender, Int32 index)
   at FSpot.TimeAdaptor.SetGlass(Int32 min)
   at FSpot.GroupSelector+Glass.PositionChanged()
   at FSpot.GroupSelector+Manipulator.SetPosition(Int32 position, Boolean update)
   at FSpot.GroupSelector+Manipulator.SetPosition(Int32 position)
   at FSpot.GroupSelector.OnButtonPressEvent(Gdk.EventButton args)
   at Gtk.Widget.buttonpressevent_cb(IntPtr widget, IntPtr evnt)
   at Gtk.Application.gtk_main()
   at Gtk.Application.Run()
   at FSpot.Driver.Startup()
   at Hyena.Gui.CleanRoomStartup.Startup(Hyena.Gui.StartupInvocationHandler startup)
   at FSpot.Driver.Main(System.String[] args)

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: f-spot 0.8.0-1
ProcVersionSignature: Ubuntu 2.6.35-22.35-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic i686
NonfreeKernelModules: nvidia
Architecture: i386
Date: Sun Nov 21 12:49:54 2010
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
ProcEnviron:
 PATH=(custom, no user)
 LANG=en_US.utf8
 SHELL=/bin/bash
SourcePackage: f-spot

Revision history for this message
Cris Jansson (cris-jansson) wrote :
Changed in f-spot:
importance: Unknown → Critical
status: Unknown → New
Revision history for this message
Derek (bugs-m8y) wrote :

Imported 350 photos off SO's iphone 4.

Bug is triggered while trying to browser history by date at more than one place.

Same stack trace.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.OverflowException: Value is greater than Int32.MaxValue or less than Int32.MinValue
  at System.Convert.ToInt32 (Int64 value) [0x00000] in <filename unknown>:0
  at System.Int64.System.IConvertible.ToInt32 (IFormatProvider provider) [0x00000] in <filename unknown>:0
  at System.Convert.ToType (System.Object value, System.Type conversionType, IFormatProvider provider, Boolean try_target_to_type) [0x00000] in <filename unknown>:0
  at System.Convert.ChangeType (System.Object value, System.Type conversionType, IFormatProvider provider) [0x00000] in <filename unknown>:0
  at Mono.Data.Sqlite.Sqlite3.GetValue (Mono.Data.Sqlite.SqliteStatement stmt, Int32 index, Mono.Data.Sqlite.SqliteType typ) [0x00000] in <filename unknown>:0
  at Mono.Data.Sqlite.SqliteDataReader.GetValue (Int32 i) [0x00000] in <filename unknown>:0
  at Hyena.Data.Sqlite.HyenaSqliteArrayDataReader.ReadAllRows (Mono.Data.Sqlite.SqliteDataReader reader) [0x00000] in <filename unknown>:0
  at Hyena.Data.Sqlite.HyenaSqliteArrayDataReader..ctor (Mono.Data.Sqlite.SqliteDataReader reader) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) Hyena.Data.Sqlite.HyenaSqliteArrayDataReader:.ctor (Mono.Data.Sqlite.SqliteDataReader)
  at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Mono.Data.Sqlite.SqliteConnection connection) [0x00000] in <filename unknown>:0

Revision history for this message
Derek (bugs-m8y) wrote :

Oh, this was a clean profile, fresh install. Her first time with f-spot/linux really.
The photos from the iphone 4 in this single import were the only photos.

Revision history for this message
Derek (bugs-m8y) wrote :

In my opinion this is a duplicate of bug #636819 which also has workaround information.
I will move all my comments to that bug.

Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in f-spot (Ubuntu):
status: New → Confirmed
B Bobo (yout-bobo123)
tags: added: f-spot
B Bobo (yout-bobo123)
Changed in f-spot (Ubuntu):
status: Confirmed → Fix Released
Changed in f-spot:
status: New → Won't Fix
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.