Advertisement
Guest User

Untitled

a guest
Feb 24th, 2020
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.99 KB | None | 0 0
  1. ERROR: Exception in ASGI application
  2. Traceback (most recent call last):
  3. File "/usr/local/lib/python3.7/site-packages/uvicorn/protocols/http/httptools_impl.py", line 375, in run_asgi
  4. result = await app(self.scope, self.receive, self.send)
  5. File "/usr/local/lib/python3.7/site-packages/fastapi/applications.py", line 140, in __call__
  6. await super().__call__(scope, receive, send)
  7. File "/usr/local/lib/python3.7/site-packages/starlette/applications.py", line 134, in __call__
  8. await self.error_middleware(scope, receive, send)
  9. File "/usr/local/lib/python3.7/site-packages/starlette/middleware/errors.py", line 178, in __call__
  10. raise exc from None
  11. File "/usr/local/lib/python3.7/site-packages/starlette/middleware/errors.py", line 156, in __call__
  12. await self.app(scope, receive, _send)
  13. File "/usr/local/lib/python3.7/site-packages/starlette/middleware/base.py", line 25, in __call__
  14. response = await self.dispatch_func(request, self.call_next)
  15. File "./app/main.py", line 51, in db_session_middleware
  16. response = await call_next(request)
  17. File "/usr/local/lib/python3.7/site-packages/starlette/middleware/base.py", line 45, in call_next
  18. task.result()
  19. File "/usr/local/lib/python3.7/site-packages/starlette/middleware/base.py", line 38, in coro
  20. await self.app(scope, receive, send)
  21. File "/usr/local/lib/python3.7/site-packages/starlette/middleware/cors.py", line 76, in __call__
  22. await self.app(scope, receive, send)
  23. File "/usr/local/lib/python3.7/site-packages/starlette/exceptions.py", line 73, in __call__
  24. raise exc from None
  25. File "/usr/local/lib/python3.7/site-packages/starlette/exceptions.py", line 62, in __call__
  26. await self.app(scope, receive, sender)
  27. File "/usr/local/lib/python3.7/site-packages/starlette/routing.py", line 590, in __call__
  28. await route(scope, receive, send)
  29. File "/usr/local/lib/python3.7/site-packages/starlette/routing.py", line 208, in __call__
  30. await self.app(scope, receive, send)
  31. File "/usr/local/lib/python3.7/site-packages/starlette/routing.py", line 41, in app
  32. response = await func(request)
  33. File "/usr/local/lib/python3.7/site-packages/fastapi/routing.py", line 133, in app
  34. raw_response = await dependant.call(**values)
  35. File "./app/api/endpoints/quizzes.py", line 71, in get_all_quizzes_available_for_user
  36. return get_all_quizzes_to_user(db, user)
  37. File "./app/api/services/quizzes.py", line 248, in get_all_quizzes_to_user
  38. return get_quizzes_to_show_id(session, user)
  39. File "./app/crud/quizzes.py", line 120, in get_quizzes_to_show_id
  40. q1res = session.query(Questionnaire).from_statement(q).all()
  41. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3233, in all
  42. return list(self)
  43. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3389, in __iter__
  44. return self._execute_and_instances(context)
  45. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3414, in _execute_and_instances
  46. result = conn.execute(querycontext.statement, self._params)
  47. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute
  48. return meth(self, multiparams, params)
  49. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection
  50. return connection._execute_clauseelement(self, multiparams, params)
  51. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement
  52. distilled_params,
  53. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
  54. e, statement, parameters, cursor, context
  55. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
  56. util.raise_from_cause(sqlalchemy_exception, exc_info)
  57. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
  58. reraise(type(exception), exception, tb=exc_tb, cause=cause)
  59. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
  60. raise value.with_traceback(tb)
  61. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
  62. cursor, statement, parameters, context
  63. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
  64. cursor.execute(statement, parameters)
  65. sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column q.is_active does not exist
  66. LINE 1: ...uiz_name, q.final_date from questionnaire q where q.is_activ...
  67. ^
  68.  
  69. [SQL: SELECT q.id, q.quiz_name, q.final_date from questionnaire q where q.is_active = true and q.available_for_group && (Select department_name from "user" where id = %(user_id)s) and q.id not in (SELECT questionnaire_id FROM questionnaire_response where user_id = %(user_id)s)]
  70. [parameters: {'user_id': 4}]
  71. (Background on this error at: http://sqlalche.me/e/f405)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement