Pymssql runs on top of the ancient library DB-lib, which has real issues with not fully reading all query results -- make sure all your query results are fully consumed, i.e. read them into a list and the iterate that instead of partially iterating the cursor.
On 2/8/07, Arnar Birgisson <[EMAIL PROTECTED]> wrote: > > Hi Rick, > > On 2/8/07, Rick Morrison <[EMAIL PROTECTED]> wrote: > > Pymssql, or adodbapi? Client-side cursors, or Server-side? > > Pymssql and client side cursors (I guess, I'm just issuing plain > select statements, no stored procs or such). > > > We use pymssql here over FreeTDS with SQL Server 2005 here without > > issues. If your DBA suggests "with (nolock)", I'm assuming that you're > > seeing some sort of persistent table/page locks? > > > > Can you give a bit more info? > > I'm trying to analyze the problem right now, but I'm afraid I don't > have alot of info. We were having locking issues in other systems > running of the same db server which were solved (partially at least) > by adding nolock hints to datawarehousing procedures. > > The symptom on the SA side is that this seems to happen after the > server (apache/mod_python) has been running for a while. A user (and > always the same two out of ~40) call me and says his page is empty - > meaning that the main query is giving 0 result rows when it should be > giving >300. I log in with my name and everything is fine - I log in > with his and I see the empty screen. If I restart apache it fixes the > problem for a while. > > I don't see any errors or tracebacks in the apache error_log, but I > have yet to enable more logging since this only happens on the > production server and quite sporadically. > > This has some pre-history. I was initially running this in cherrypy > which was simply not working at all. DB connections would lock up > until there were no left in the pool and this happend quite fast, in > about 20 minutes. I moved the part of the application that speaks to > mssql over to mod_python/apache and that solved the problem while we > were running on sql server 2000. > > I'll try to analyze this some more and get back to you.. thanks for the help. > > Arnar > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---