[sqlalchemy] Query hangs after a while

2015-06-13 Thread Dr.
I have a very simple table and query. For some reason it hangs after a few executions and I have to restart the application. Code to set it up: from sqlalchemy import ( Column, Integer, String ) from sqlalchemy.ext.declarative import declarative_base Base = declarative_base()

Re: [sqlalchemy] Query hangs after a while

2015-06-13 Thread Will Brown
The problem seems to be independent of context. Happens both when I run python interactively from the prompt, and from within a Pyramid-based web app. I have not tried other connectors or raw DBAPI. Will try that. On Sat, Jun 13, 2015 at 5:48 AM, Mike Bayer mike...@zzzcomputing.com wrote: On

Re: [sqlalchemy] Query hangs after a while

2015-06-13 Thread Mike Bayer
On 6/13/15 3:54 AM, Dr. wrote: I have a very simple table and query. For some reason it hangs after a few executions and I have to restart the application. Code to set it up: | fromsqlalchemy import( Column, Integer, String ) fromsqlalchemy.ext.declarative importdeclarative_base

Re: [sqlalchemy] Query hangs after a while

2015-06-13 Thread Jonathan Vanasco
Are you positive there isn't some transactional locking going on? What does mysql say about locked tables/rows when things are stalled? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from