Thiết kế website giá rẻ

Question

I am struggling with deploying an airflow host, and it looks like from the airflow slave worker in another server, something i did in the DB, now I am getting this error and cannot access to airflow UI, how to fix it?

[SQL: SELECT session.id AS session_id_1, session.session_id AS session_session_id, session.data AS session_data, session.expiry AS session_expiry 
airflow-webserver_1       | FROM session 
airflow-webserver_1       | WHERE session.session_id = %(session_id_1)s 
airflow-webserver_1       |  LIMIT %(param_1)s]
airflow-webserver_1       | [parameters: {'session_id_1': '9c3a6b60-fc99-4a22-96b3-889effd95060', 'param_1': 1}]
airflow-webserver_1       | (Background on this error at: https://sqlalche.me/e/14/f405)
airflow-webserver_1       | 
airflow-webserver_1       | During handling of the above exception, another exception occurred:
airflow-webserver_1       | 
airflow-webserver_1       | Traceback (most recent call last):
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
airflow-webserver_1       |     self.dialect.do_execute(
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
airflow-webserver_1       |     cursor.execute(statement, parameters)
airflow-webserver_1       | psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
airflow-webserver_1       | 
airflow-webserver_1       | 
airflow-webserver_1       | The above exception was the direct cause of the following exception:
airflow-webserver_1       | 
airflow-webserver_1       | Traceback (most recent call last):
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/flask/app.py", line 1847, in finalize_request
airflow-webserver_1       |     response = self.process_response(response)
airflow-webserver_1       |                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/flask/app.py", line 2343, in process_response
airflow-webserver_1       |     self.session_interface.save_session(self, ctx.session, response)
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/airflow/www/session.py", line 33, in save_session
airflow-webserver_1       |     return super().save_session(*args, **kwargs)
airflow-webserver_1       |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/flask_session/sessions.py", line 544, in save_session
airflow-webserver_1       |     session_id=store_id).first()
airflow-webserver_1       |                          ^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2824, in first
airflow-webserver_1       |     return self.limit(1)._iter().first()
airflow-webserver_1       |            ^^^^^^^^^^^^^^^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
airflow-webserver_1       |     result = self.session.execute(
airflow-webserver_1       |              ^^^^^^^^^^^^^^^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
airflow-webserver_1       |     result = conn._execute_20(statement, params or {}, execution_options)
airflow-webserver_1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
airflow-webserver_1       |     return meth(self, args_10style, kwargs_10style, execution_options)
airflow-webserver_1       |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
airflow-webserver_1       |     return connection._execute_clauseelement(
airflow-webserver_1       |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
airflow-webserver_1       |     ret = self._execute_context(
airflow-webserver_1       |           ^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
airflow-webserver_1       |     self._handle_dbapi_exception(
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
airflow-webserver_1       |     util.raise_(
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
airflow-webserver_1       |     raise exception
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
airflow-webserver_1       |     self.dialect.do_execute(
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
airflow-webserver_1       |     cursor.execute(statement, parameters)
airflow-webserver_1       | sqlalchemy.exc.InternalError: (psycopg2.errors.InFailedSqlTransaction) current transaction is aborted, commands ignored until end of transaction block
airflow-webserver_1       | 
airflow-webserver_1       | [SQL: SELECT session.id AS session_id_1, session.session_id AS session_session_id, session.data AS session_data, session.expiry AS session_expiry 
airflow-webserver_1       | FROM session 
airflow-webserver_1       | WHERE session.session_id = %(session_id_1)s 
airflow-webserver_1       |  LIMIT %(param_1)s]
airflow-webserver_1       | [parameters: {'session_id_1': '9c3a6b60-fc99-4a22-96b3-889effd95060', 'param_1': 1}]
airflow-webserver_1       | (Background on this error at: https://sqlalche.me/e/14/2j85)
airflow-webserver_1       | 172.16.173.214 - - [12/Jun/2024:12:39:12 +0200] "GET /dags/deteccion-colusion/grid?dag_run_id=manual__2024-05-23T08%3A24%3A32.941726%2B00%3A00&task_id=notebook_deteccion_alf&tab=logs HTTP/1.0" 500 1539 "https://airflowdesa.cnmc.es/home" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36"
airflow-webserver_1       | [2024-06-12T12:39:12.536+0200] {app.py:1744} ERROR - Exception on /favicon.ico [GET]
airflow-webserver_1       | Traceback (most recent call last):
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
airflow-webserver_1       |     self.dialect.do_execute(
airflow-webserver_1       |   File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
airflow-webserver_1       |     cursor.execute(statement, parameters)
airflow-webserver_1       | psycopg2.errors.UndefinedTable: relation "session" does not exist
airflow-webserver_1       | LINE 2: FROM session

Thiết kế website giá rẻ

Danh mục

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation “session” does not exist