is that happening every time? it's a bug where an exception is raised on connect but it's not being allowed to display. Can you please invoke the statement "show standard_conforming_strings" on your connection and/or Postgresql database so I can see what it's saying?
On May 30, 2014, at 12:04 PM, Pau Tallada <[email protected]> wrote: > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
