Skip to content

Instantly share code, notes, and snippets.

@crooksey
Created March 22, 2012 09:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save crooksey/2157378 to your computer and use it in GitHub Desktop.
Save crooksey/2157378 to your computer and use it in GitHub Desktop.
Traceback from informixdb + sqlalchemy
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