Error: maximum depth 1000 when deleting batch entries from catalogue

[Dougie Nisbet <dougie highmoor co uk>]

I'm still experimenting with f-spot and trying to see how I can fit the 
way I normally work with images into the f-spot philosophy. I'm used to 
moving and renaming files outside f-spot and f-spot seems to be WAD in 
not allowing this within the program.

I wanted to re-import my jpegs and start again, but I'd spent a lot of 
time creating tags (but had not assigned them to images yet) so I didn't 
want to lose all that administration. So I didn't just want to delete 
the photos.db file.

I've decided to try the f-spot way of using date-named folders and to 
import with copy. I moved my source images and created a new destination 
folder for the new images filesystem. However I had a load of images in 
the catalogue that appeared when I ran f-spot, so I decided to get rid 
of them by selecting all (13000 images) and removing from catalogue.

When I do this f-spot hangs indefinitely. The output from the program 
(version 0.4.1 started from the command line) is:

-----
Unhandled Exception: Mono.Data.SqliteClient.SqliteSyntaxException: 
Expression tree is too large (maximum depth 1000)
 at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr 
pzStart, System.IntPtr& pzTail, System.IntPtr& pStmt) [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]
Query: SELECT photos.id, photos.time, photos.uri, 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
Syncing metadata to file...
-----

and f-spot hangs indefinitely until I Ctrl-C.

I searched the bugs for this and couldn't find it, but found a reference 
to Ubuntu/Banshee at 
https://bugs.launchpad.net/ubuntu/+source/banshee/+bug/134120 which 
seems to be a similar thing. I have found that if I batch images into 
less than 1000 at a time I can delete them from the catalogue without 
problems.

Dougie