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.
My query is: session.connection().connection.cursor().cursor.copy_from(f, table, sep=chr(int(conf['import.separator'])), columns=map(str, fields.split (','))) Log: 2009-11-04 18:43:30 EET LOG: statement: COPY people (id,street_id,building,corpus,appartment,block,last_name,hd,residents,space,rooms,privilege,comment) FROM stdin WITH DELIMITER AS E' ' 2009-11-04 18:44:08 EET LOG: could not receive data from client: Connection reset by peer 2009-11-04 18:44:08 EET CONTEXT: COPY people, line 6146 2009-11-04 18:44:08 EET STATEMENT: COPY people (id,street_id,building,corpus,appartment,block,last_name,hd,residents,space,rooms,privilege,comment) FROM stdin WITH DELIMITER AS E'' 2009-11-04 18:44:08 EET LOG: incomplete message from client 2009-11-04 18:44:08 EET CONTEXT: COPY people, line 6146 2009-11-04 18:44:08 EET STATEMENT: COPY people (id,street_id,building,corpus,appartment,block,last_name,hd,residents,space,rooms,privilege,comment) FROM stdin WITH DELIMITER AS E'' 2009-11-04 18:44:08 EET ERROR: unexpected EOF on client connection 2009-11-04 18:44:08 EET CONTEXT: COPY people, line 6146 2009-11-04 18:44:08 EET STATEMENT: COPY people (id,street_id,building,corpus,appartment,block,last_name,hd,residents,space,rooms,privilege,comment) FROM stdin WITH DELIMITER AS E'' 2009-11-04 18:44:08 EET LOG: could not send data to client: Broken pipe 2009-11-04 18:44:08 EET LOG: could not receive data from client: Connection reset by peer 2009-11-04 18:44:08 EET LOG: unexpected EOF on client connection 2009-11-04 18:44:08 EET LOG: disconnection: session time: 0:00:44.763 user=eps database=eps host=localhost port=44257 --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---