Skip to content

Instantly share code, notes, and snippets.

@zachshallbetter
Created August 15, 2014 20:05
Show Gist options
  • Select an option

  • Save zachshallbetter/b127201df1c2a4c43ffa to your computer and use it in GitHub Desktop.

Select an option

Save zachshallbetter/b127201df1c2a4c43ffa to your computer and use it in GitHub Desktop.
RDS Local error
sqlalchemy.exc.ProgrammingError
ProgrammingError: (ProgrammingError) relation "user" does not exist
LINE 2: FROM "user"
^
'SELECT "user".created_on AS user_created_on, "user".updated_on AS user_updated_on, "user".id AS user_id, "user".email AS user_email, "user".password AS user_password, "user".first_name AS user_first_name, "user".last_name AS user_last_name, "user".active AS user_active, "user".requires_password_change AS user_requires_password_change, "user".is_admin AS user_is_admin, "user".is_superadmin AS user_is_superadmin \nFROM "user" \nWHERE "user".id = %(id_1)s \n LIMIT %(param_1)s' {'id_1': u'18', 'param_1': 1}
Traceback (most recent call last)
File "/var/www/venv/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "/var/www/venv/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "/var/www/venv/lib/python2.7/site-packages/flask/app.py", line 1403, in handle_exception
reraise(exc_type, exc_value, tb)
File "/var/www/venv/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/var/www/venv/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/var/www/venv/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/var/www/venv/lib/python2.7/site-packages/flask/app.py", line 1473, in full_dispatch_request
rv = self.preprocess_request()
File "/var/www/venv/lib/python2.7/site-packages/flask/app.py", line 1666, in preprocess_request
rv = func()
File "/var/www/venv/lib/python2.7/site-packages/flask_login.py", line 300, in _load_user
return self.reload_user()
File "/var/www/venv/lib/python2.7/site-packages/flask_login.py", line 281, in reload_user
user = self.user_callback(user_id)
File "/var/www/venv/lib/python2.7/site-packages/flask_security/core.py", line 153, in _user_loader
return _security.datastore.find_user(id=user_id)
File "/var/www/venv/lib/python2.7/site-packages/flask_security/datastore.py", line 202, in find_user
return self.user_model.query.filter_by(**kwargs).first()
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2289, in first
ret = list(self[0:1])
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2156, in __getitem__
return list(res)
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2360, in __iter__
return self._execute_and_instances(context)
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2375, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 662, in execute
params)
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
compiled_sql, distilled_params
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
context)
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
exc_info
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
context)
File "/var/www/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 324, in do_execute
cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) relation "user" does not exist LINE 2: FROM "user" ^ 'SELECT "user".created_on AS user_created_on, "user".updated_on AS user_updated_on, "user".id AS user_id, "user".email AS user_email, "user".password AS user_password, "user".first_name AS user_first_name, "user".last_name AS user_last_name, "user".active AS user_active, "user".requires_password_change AS user_requires_password_change, "user".is_admin AS user_is_admin, "user".is_superadmin AS user_is_superadmin \nFROM "user" \nWHERE "user".id = %(id_1)s \n LIMIT %(param_1)s' {'id_1': u'18', 'param_1': 1}
The debugger caught an exception in your WSGI application. You can now look at the traceback which led to the error.
To switch between the interactive traceback and the plaintext one, you can click on the "Traceback" headline. From the text traceback you can also create a paste of it. For code execution mouse-over the frame you want to debug and click on the console icon on the right side.
You can execute arbitrary Python code in the stack frames and there are some extra helpers available for introspection:
dump() shows all variables in the frame
dump(obj) dumps all that's known about the object
Brought to you by DON'T PANIC, your friendly Werkzeug powered traceback interpreter.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment