- changed status to wontfix
Python 3.1 + psycopg2 = exception
Issue #2136
resolved
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)
-
repo owner - Log in to comment
psycopg2 + python3 support was only first noted in 0.7b4 and is in CHANGES here: http://www.sqlalchemy.org/trac/changeset/7513%3A6bfb6964600f/CHANGES . tests pass 100% for py3.2 and just two profile count failures in py3.1.