Python 3.1 + psycopg2 = exception

Issue #2135 resolved
Former user created an issue
  File "/home/....py", line 41, in ...
    stats = query.all()
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/orm/query.py", line 1637, in all
    return list(self)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/orm/query.py", line 1747, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/orm/query.py", line 1753, in _execute_and_instances
    close_with_result=True).execute(querycontext.statement, self._params)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/orm/session.py", line 690, in connection
    close_with_result=close_with_result)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/orm/session.py", line 694, in _connection_for_bind
    return self.transaction._connection_for_bind(engine)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/orm/session.py", line 246, in _connection_for_bind
    conn = bind.contextual_connect()
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/base.py", line 2062, in contextual_connect
    self.pool.connect(),
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/pool.py", line 208, in connect
    return _ConnectionFairy(self).checkout()
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/pool.py", line 369, in __init__
    rec = self._connection_record = pool._do_get()
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/pool.py", line 693, in _do_get
    con = self._create_connection()
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/pool.py", line 173, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/pool.py", line 257, in __init__
    pool.dispatch.first_connect.exec_once(self.connection, self)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/event.py", line 227, in exec_once
    self(*args, **kw)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/event.py", line 236, in __call__
    fn(*args, **kw)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/strategies.py", line 162, in first_connect
    dialect.initialize(c)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/dialects/postgresql/base.py", line 793, in initialize
    super(PGDialect, self).initialize(connection)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/default.py", line 171, in initialize
    self._get_server_version_info(connection)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/dialects/postgresql/base.py", line 964, in _get_server_version_info
    v = connection.execute("select version()").scalar()
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/base.py", line 1259, in execute
    params)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/base.py", line 1436, in _execute_text
    statement, parameters
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/base.py", line 1519, in _execute_context
    result = context.get_result_proxy()
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/dialects/postgresql/psycopg2.py", line 198, in get_result_proxy
    return base.ResultProxy(self)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/base.py", line 2420, in __init__
    self._init_metadata()
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/base.py", line 2427, in _init_metadata
    self._metadata = ResultMetaData(self, metadata)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/engine/base.py", line 2283, in __init__
    colname = dialect._description_decoder(colname)
  File "/usr/local/lib/python3.1/dist-packages/SQLAlchemy-0.7b3-py3.1.egg/sqlalchemy/processors.py", line 69, in process
    return decoder(value, errors)[0](0)
  File "/usr/lib/python3.1/encodings/utf_8.py", line 16, in decode
    return codecs.utf_8_decode(input, errors, True)
TypeError: must be bytes or buffer, not str

Comments (1)

  1. Log in to comment