okfn/openspending — Issue #326: Error 500 on front page
Author: mk270
Created: 2011-11-22 12:48:21+00:00
State: open

This seemed to appear and disappear without warning

Internal Server Error
Traceback:

Traceback (most recent call last):
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/gunicorn/workers/sync.py", line 99, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/paste/cascade.py", line 130, in __call__
return self.apps[-1](environ, start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/paste/registry.py", line 379, in __call__
app_iter = self.application(environ, start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/pylons/middleware.py", line 163, in __call__
self.app, new_environ, catch_exc_info=True)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/pylons/util.py", line 48, in call_wsgi_application
app_iter = application(environ, start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/weberror/errormiddleware.py", line 156, in __call__
return self.application(environ, start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/repoze/who/middleware.py", line 87, in __call__
app_iter = app(environ, wrapper.wrap_start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/beaker/middleware.py", line 73, in __call__
return self.app(environ, start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/beaker/middleware.py", line 155, in __call__
return self.wrap_app(environ, session_start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/routes/middleware.py", line 131, in __call__
response = self.app(environ, start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/pylons/wsgiapp.py", line 107, in __call__
response = self.dispatch(controller, environ, start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/pylons/wsgiapp.py", line 312, in dispatch
return controller(environ, start_response)
File "/home/okfn/var/srvc/openspending.org/src/openspending/openspending/ui/lib/base.py", line 89, in __call__
return WSGIController.__call__(self, environ, start_response)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/pylons/controllers/core.py", line 207, in __call__
response = self._inspect_call(self.__before__)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/pylons/controllers/core.py", line 105, in _inspect_call
result = self._perform_call(func, args)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/pylons/controllers/core.py", line 57, in _perform_call
return func(**args)
File "/home/okfn/var/srvc/openspending.org/src/openspending/openspending/ui/lib/base.py", line 108, in __before__
self._detect_dataset_subdomain()
File "/home/okfn/var/srvc/openspending.org/src/openspending/openspending/ui/lib/base.py", line 130, in _detect_dataset_subdomain
for dataset in c.datasets:
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 1839, in __iter__
return self._execute_and_instances(context)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 1854, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1399, in execute
params)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1532, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1599, in _execute_context
None, None)
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1593, in _execute_context
conn = self._revalidate_connection()
File "/home/okfn/var/srvc/openspending.org/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1018, in _revalidate_connection
"Can't reconnect until invalid "
StatementError: Can't reconnect until invalid transaction is rolled back (original cause: InvalidRequestError: Can't reconnect until invalid transaction is rolled back) 'SELECT dataset.id AS dataset_id, dataset.name AS dataset_name, dataset.label AS dataset_label, dataset.description AS dataset_description, dataset.currency AS dataset_currency, dataset.default_time AS dataset_default_time, dataset.data AS dataset_data, dataset.private AS dataset_private \nFROM dataset \nWHERE dataset.private = %(private_1)s' [immutabledict({})]