[sqlalchemy] Re: 'Too many connections': Where am I handling sessions incorrectly?

2011-09-15 Thread Jeff
Thanks for the guidance! In a situation which a script submits a swarm of independent jobs for a cluster, and then finishes before some/all of those jobs have started running, each job will need to create the engine, yes? Or is there a better way to do it? On Sep 15, 2:30 pm, Michael Bayer

Re: [sqlalchemy] Re: 'Too many connections': Where am I handling sessions incorrectly?

2011-09-15 Thread Michael Bayer
On Sep 15, 2011, at 10:20 AM, Jeff wrote: Thanks for the guidance! In a situation which a script submits a swarm of independent jobs for a cluster, and then finishes before some/all of those jobs have started running, each job will need to create the engine, yes? Or is there a better way

[sqlalchemy] Re: 'Too many connections': Where am I handling sessions incorrectly?

2011-09-15 Thread Jeff
Great. I implemented your suggestions and it was (predictably) a significant speedup. Cheers! On Sep 15, 4:31 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Sep 15, 2011, at 10:20 AM, Jeff wrote: Thanks for the guidance! In a situation which a script submits a swarm of independent

[sqlalchemy] Re: Too many connections

2008-09-06 Thread gatto
On Sep 5, 12:19 pm, gatto [EMAIL PROTECTED] wrote: hi everyone. just started using sqlalchemy and elixir recently. i'm not having any issues with coding yet, just this one: OperationalError: (OperationalError) (1040, 'Too many connections') as a workaround for this problem, i created a

[sqlalchemy] Re: Too many connections

2008-09-06 Thread Michael Bayer
On Sep 6, 2008, at 8:03 AM, gatto wrote: On Sep 5, 12:19 pm, gatto [EMAIL PROTECTED] wrote: hi everyone. just started using sqlalchemy and elixir recently. i'm not having any issues with coding yet, just this one: OperationalError: (OperationalError) (1040, 'Too many connections') as

[sqlalchemy] Re: Too many connections

2008-09-06 Thread gatto
On Sep 6, 9:27 am, Michael Bayer [EMAIL PROTECTED] wrote: On Sep 6, 2008, at 8:03 AM, gatto wrote: On Sep 5, 12:19 pm, gatto [EMAIL PROTECTED] wrote: hi everyone. just started using sqlalchemy and elixir recently. i'm not having any issues with coding yet, just this one:

[sqlalchemy] Re: Too many connections

2008-09-06 Thread Michael Bayer
On Sep 6, 2008, at 5:07 PM, gatto wrote: global phase try: if phase == 'start': phase = 'running' except: phase = 'start' if phase == 'start': self.engine = create_engine('mysql://' + app_config.database.user + ':' + app_config.database.password + '@'