Re: [sqlalchemy] Re: Something wrong with pool. Got "Connection is already closed None None" with copy_from and big file.

2009-11-21 Thread Michael Bayer
On Nov 21, 2009, at 8:51 AM, sector119 wrote: > > > On Nov 4, 7:13 pm, "Michael Bayer" wrote: >> copy_from() probably creates some state that is not compatible with the >> connection being used afterwards for subsequent operations, or >> alternatively copy_from() is not compatible with some pr

Re: [sqlalchemy] Re: Something wrong with pool. Got "Connection is already closed None None" with copy_from and big file.

2009-11-21 Thread Michael Bayer
On Nov 21, 2009, at 8:51 AM, sector119 wrote: > > > On Nov 4, 7:13 pm, "Michael Bayer" wrote: >> copy_from() probably creates some state that is not compatible with the >> connection being used afterwards for subsequent operations, or >> alternatively copy_from() is not compatible with some pr

[sqlalchemy] Re: Something wrong with pool. Got "Connection is already closed None None" with copy_from and big file.

2009-11-21 Thread sector119
On Nov 4, 7:13 pm, "Michael Bayer" wrote: > copy_from() probably creates some state that is not compatible with the > connection being used afterwards for subsequent operations, or > alternatively copy_from() is not compatible with some previous state.   > The pool does nothing special to the co

[sqlalchemy] Re: Something wrong with pool. Got "Connection is already closed None None" with copy_from and big file.

2009-11-04 Thread Michael Bayer
sector119 wrote: > > I use sqlalchemy 0.6 and psycopg2 2.0.13. > > When I try to copy from some little file it's ok, when from some > bigger one I got error and log posted below. > When I use pgbouncer and pass poolclass=pool.NullPool to create_engine > everything wor perfect with large file too.