GNOME Bugzilla – Bug 472238
Program hangs when accessing database
Last modified: 2007-08-31 16:03:04 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]
upgrade your db to sqlite3 (provided script in the tools/ folder) *** This bug has been marked as a duplicate of 467011 ***