Created
March 22, 2012 09:44
-
-
Save crooksey/2157378 to your computer and use it in GitHub Desktop.
Traceback from informixdb + sqlalchemy
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Traceback (most recent call last): | |
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid_debugtoolbar-0.9.9.1-py2.7.egg/pyramid_debugtoolbar/panels/performance.py", line 55, in resource_timer_handler | |
result = handler(request) | |
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid-1.3b2-py2.7.egg/pyramid/tweens.py", line 20, in excview_tween | |
response = handler(request) | |
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid_tm-0.3-py2.7.egg/pyramid_tm/__init__.py", line 61, in tm_tween | |
response = handler(request) | |
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid-1.3b2-py2.7.egg/pyramid/router.py", line 164, in handle_request | |
response = view_callable(context, request) | |
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid-1.3b2-py2.7.egg/pyramid/config/views.py", line 331, in rendered_view | |
result = view(context, request) | |
File "/home/luke/virts/pyramid1.3b2/lib/python2.7/site-packages/pyramid-1.3b2-py2.7.egg/pyramid/config/views.py", line 462, in _requestonly_view | |
response = view(request) | |
File "/home/luke/pyramids/intranet/intranet/views.py", line 34, in view_customer | |
cust_slcustm = DBSessionRO.query(Slcustm).filter(Slcustm.customer == customer_no).first() | |
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 2024, in first | |
ret = list(self[0:1]) | |
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 1918, in __getitem__ | |
return list(res) | |
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 2093, in __iter__ | |
return self._execute_and_instances(context) | |
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 2106, in _execute_and_instances | |
close_with_result=True) | |
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 2097, in _connection_from_session | |
**kw) | |
File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 729, in connection | |
close_with_result=close_with_result) | |
File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 733, in _connection_for_bind | |
return self.transaction._connection_for_bind(engine) | |
File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 266, in _connection_for_bind | |
conn = bind.contextual_connect() | |
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 2340, in contextual_connect | |
self.pool.connect(), | |
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 210, in connect | |
return _ConnectionFairy(self).checkout() | |
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 371, in __init__ | |
rec = self._connection_record = pool._do_get() | |
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 697, in _do_get | |
con = self._create_connection() | |
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 174, in _create_connection | |
return _ConnectionRecord(self) | |
File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 259, in __init__ | |
pool.dispatch.first_connect.exec_once(self.connection, self) | |
File "build/bdist.linux-i686/egg/sqlalchemy/event.py", line 265, in exec_once | |
self(*args, **kw) | |
File "build/bdist.linux-i686/egg/sqlalchemy/event.py", line 274, in __call__ | |
fn(*args, **kw) | |
File "build/bdist.linux-i686/egg/sqlalchemy/engine/strategies.py", line 166, in first_connect | |
dialect.initialize(c) | |
File "build/bdist.linux-i686/egg/sqlalchemy/dialects/informix/base.py", line 357, in initialize | |
super(InformixDialect, self).initialize(connection) | |
File "build/bdist.linux-i686/egg/sqlalchemy/engine/default.py", line 175, in initialize | |
self._get_default_schema_name(connection) | |
File "build/bdist.linux-i686/egg/sqlalchemy/dialects/informix/base.py", line 593, in _get_default_schema_name | |
return connection.execute('select CURRENT_ROLE from systables').scalar() | |
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1405, in execute | |
params) | |
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1582, in _execute_text | |
statement, parameters | |
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1646, in _execute_context | |
context) | |
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1639, in _execute_context | |
context) | |
File "build/bdist.linux-i686/egg/sqlalchemy/engine/default.py", line 330, in do_execute | |
cursor.execute(statement, parameters) | |
DatabaseError: (DatabaseError) SQLCODE -217 in PREPARE: | |
IX000: Column (current_role) not found in any table in the query (or SLV is undefined). | |
'select CURRENT_ROLE from systables' () |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment