mssql issues; Set changed size during iteration and hangs at Loading database structure..

[GoogleCodeExporter]

I'm having trouble using the SQL server support. Using the current tip
revision, on Ubuntu Karmic x64, I get one of a handful of problems:

Quite commonly, when expanding Schemata or the connection entry, I get this:

Traceback (most recent call last):
  File "/home/daz/tmp/crunchyfrog/src/cf/ui/browser.py", line 355, in
on_row_expanded
    for child in datasource_info.meta.get_children(obj):
  File "/home/daz/tmp/crunchyfrog/src/cf/db/meta.py", line 81, in get_children
    return self.find(parent=parent)
  File "/home/daz/tmp/crunchyfrog/src/cf/db/meta.py", line 90, in find
    res = filter(lambda x: x.property_matches(key, value), res)
RuntimeError: Set changed size during iteration

Sometimes the status bar will report Loading database structure, but
nothing appears in the navigator tree. No errors are printed to
stdout/stderr. If I disconnect and reconnect a couple of times, I might see
some schema.

There are also some other more sporadic, and minor issues. And yet
sometimes it mostly works as it should and I can run queries :)

Is the SQL Server support mature or still experimental at this stage? I can
work with SQLite db's perfectly fine. Cannot try MySQL, as it doesn't give
me that choice (though the MySQL provider is listed as installed) - though
that's another ticket I suspect :)

I'm trying to convince the debugger in Pydev to play nicely to try and get
some more useful information.

Original issue reported on code.google.com by darren.w...@gmail.com on 9 Dec 2009 at 2:16

[GoogleCodeExporter]

I'm very regularly getting RuntimeError: Set changed size during iteration, but 
I
cant get a debugger going in the relevant module. With a pdb.set_trace() (on 
line 85
(in cf.db.meta.find), I get a pdb prompt, but I cant actually type anything 
into it.

Feels like some kind of race problem - any thoughts on where I should be 
looking?

Original comment by darren.w...@gmail.com on 9 Dec 2009 at 10:29

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

This issue was closed by revision d75abbdc95.

Original comment by albrecht.andi on 10 Dec 2009 at 1:59

• Changed state: Fixed
• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Thanks :) I did a similar fix, was trying to see if I could dig deeper but I'll 
leave
it now, debug fail was irritating anyway :)

Original comment by darren.w...@gmail.com on 10 Dec 2009 at 3:35

• Added labels: ****
• Removed labels: ****