Hi,
I don't know if I am doing something wrong :/
It also happens if instead of *engine.connect().connection* I use
*engine.raw_connection*.
But I think that the error dissappears if you use a "standard" connection
of something like that.
There has to be some side effect, because when I run this on the debugger,
i does not always fail :/
*engine.connect().connection*.cursor().copy_expert("COPY ({0}) TO
STDOUT DELIMITER ' ' CSV".format(config['query']),
open(full_catalog_filename_nfs, 'w'), size=65536)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1709, in connect
return self._connection_cls(self, **kwargs)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 59, in __init__
self.__connection = connection or engine.raw_connection()
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1778, in raw_connection
return self.pool.unique_connection()
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/pool.py",
line 273, in unique_connection
return _ConnectionFairy._checkout(self)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/pool.py",
line 626, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/pool.py",
line 433, in checkout
rec = pool._do_get()
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/pool.py",
line 945, in _do_get
return self._create_connection()
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/pool.py",
line 278, in _create_connection
return _ConnectionRecord(self)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/pool.py",
line 409, in __init__
exec_once(self.connection, self)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/event/attr.py",
line 247, in exec_once
self(*args, **kw)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/event/attr.py",
line 257, in __call__
fn(*args, **kw)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/util/langhelpers.py",
line 1203, in go
return once_fn(*arg, **kw)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/strategies.py",
line 165, in first_connect
dialect.initialize(c)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/dialects/postgresql/psycopg2.py",
line 390, in initialize
super(PGDialect_psycopg2, self).initialize(connection)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/dialects/postgresql/base.py",
line 1576, in initialize
"show standard_conforming_strings"
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 650, in scalar
return self.execute(object, *multiparams, **params).scalar()
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 712, in execute
return self._execute_text(object, multiparams, params)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 861, in _execute_text
statement, parameters
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 947, in _execute_context
context)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1097, in _handle_dbapi_exception
self._safe_close_cursor(cursor)
File
"/nfs/pau/PAUdm/codes/jcarrete/envs_jcarrete/photoz_env/lib/python2.6/site-packages/SQLAlchemy-0.9.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1050, in _safe_close_cursor
self.connection._logger.error(
AttributeError: 'psycopg2._psycopg.connection' object has no attribute
'_logger'
--
----------------------------------
Pau Tallada Crespí
Dep. d'Astrofísica i Cosmologia
Port d'Informació Científica (PIC)
Tel: +34 93 586 8233
----------------------------------
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
