After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 472238 - Program hangs when accessing database
Program hangs when accessing database
Status: RESOLVED DUPLICATE of bug 467011
Product: f-spot
Classification: Other
Component: Import
0.4.x
Other All
: Normal blocker
: ---
Assigned To: F-spot maintainers
F-spot maintainers
Depends on:
Blocks:
 
 
Reported: 2007-08-31 15:13 UTC by Chris Gurgiolo
Modified: 2007-08-31 16:03 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Chris Gurgiolo 2007-08-31 15:13:57 UTC
Please describe the problem:
On updating from 0.3.5 to 0.4.0 on Gentoo, whenever I attempt to add/remove a tag from a photo or make changes in the user comment field the program hangs with 100% CPU usage.  Database currently has > 2000 images listed in it.  If I reinstall f-spot 0.3.5 the problem is removed.

Steps to reproduce:
1. Add/Remove image tag
2. Edit image comment field
3. 


Actual results:
Program freezes, CPU activity goes to 100%

Expected results:
Tag are added or removed, comments added to image entry in db

Does this happen every time?
Everytime and I've reinstalled multiple times

Other information:
If I start from command line, this is the error that is returned just before the application freezes.

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]
Comment 1 Stephane Delcroix 2007-08-31 16:03:04 UTC
upgrade your db to sqlite3 (provided script in the tools/ folder)

*** This bug has been marked as a duplicate of 467011 ***