Re: [sqlalchemy] SQLAlchemy asyncio ThreadPoolExecutor “Too many clients”

2016-09-28 Thread Viktor Roytman
Yes, the problem was the call to engine.dispose() Thanks! On Wednesday, September 28, 2016 at 5:11:59 PM UTC-4, Mike Bayer wrote: > > > > it would appear that either the ThreadExecutorPool is starting more > threads than your Postgresql database has available connections, or your >

[sqlalchemy] SQLAlchemy asyncio ThreadPoolExecutor “Too many clients”

2016-09-28 Thread Viktor Roytman
I wrote a script with this sort of logic in order to insert many records into a PostgreSQL table as they are generated. #!/usr/bin/env python3 import asyncio from concurrent.futures import ProcessPoolExecutor as pool from functools import partial import sqlalchemy as sa from

[sqlalchemy] Warning in tree structure consisting of 3 models

2015-06-30 Thread Viktor Roytman
I have a three classes that I am using to represent a tree: Tree has some information about the tree at large and a list of nodes. Node has some information specific to a node, a list of subtrees, and needs a particular piece of information about the Tree for a constraint. SubTree has a list of

[sqlalchemy] Re: Warning in tree structure consisting of 3 models

2015-06-30 Thread Viktor Roytman
I think I see why the warning pops up, thank you for clarifying that. I'd prefer to live with the warning since in my actual application that contradiction won't be cropping up. What's the best way to suppress this particular warning? On Tuesday, June 30, 2015 at 3:54:51 PM UTC-4, Viktor