nvnvashisth opened a new issue #15368:
URL: https://github.com/apache/airflow/issues/15368
Hello Team,
Currently I was trying to disable my example dag and because of which
tutorial says, I have to disable them from airflow.cfg and perform airflow db
reset.
After performing that, my entire airflow has been crashed and it throw below
error.
> INFO [alembic.runtime.migration] Running upgrade 08364691d074 ->
fe461863935f, increase_length_for_connection_password
> INFO [alembic.runtime.migration] Running upgrade fe461863935f ->
7939bcff74ba, Add DagTags table
> INFO [alembic.runtime.migration] Running upgrade 7939bcff74ba ->
a4c2fd67d16b, add pool_slots field to task_instance
> INFO [alembic.runtime.migration] Running upgrade a4c2fd67d16b ->
852ae6c715af, Add RenderedTaskInstanceFields table
> INFO [alembic.runtime.migration] Running upgrade 852ae6c715af ->
952da73b5eff, add dag_code table
> INFO [alembic.runtime.migration] Running upgrade 952da73b5eff ->
a66efa278eea, Add Precision to execution_date in RenderedTaskInstanceFields
table
> INFO [alembic.runtime.migration] Running upgrade a66efa278eea ->
da3f683c3a5a, Add dag_hash Column to serialized_dag table
> INFO [alembic.runtime.migration] Running upgrade da3f683c3a5a ->
92c57b58940d, Create FAB Tables
> INFO [alembic.runtime.migration] Running upgrade 92c57b58940d ->
03afc6b6f902, Increase length of FAB ab_view_menu.name column
> INFO [alembic.runtime.migration] Running upgrade 03afc6b6f902 ->
cf5dc11e79ad, drop_user_and_chart
> Traceback (most recent call last):
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1276, in _execute_context
> self.dialect.do_execute(
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/engine/default.py",
line 593, in do_execute
> cursor.execute(statement, parameters)
> psycopg2.errors.UndefinedObject: constraint "known_event_user_id_fkey" of
relation "known_event" does not exist
>
>
> The above exception was the direct cause of the following exception:
>
> Traceback (most recent call last):
> File "/home/airflow/airflow/airflow_2/bin/airflow", line 8, in <module>
> sys.exit(main())
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/__main__.py",
line 40, in main
> args.func(args)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/cli/cli_parser.py",
line 48, in command
> return func(*args, **kwargs)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/cli/commands/db_command.py",
line 39, in resetdb
> db.resetdb()
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/utils/db.py",
line 701, in resetdb
> initdb()
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/utils/db.py",
line 549, in initdb
> upgradedb()
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/utils/db.py",
line 688, in upgradedb
> command.upgrade(config, 'heads')
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/command.py",
line 298, in upgrade
> script.run_env()
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/script/base.py",
line 489, in run_env
> util.load_python_file(self.dir, "env.py")
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/util/pyfiles.py",
line 98, in load_python_file
> module = load_module_py(module_id, path)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/util/compat.py",
line 184, in load_module_py
> spec.loader.exec_module(module)
> File "<frozen importlib._bootstrap_external>", line 783, in exec_module
> File "<frozen importlib._bootstrap>", line 219, in
_call_with_frames_removed
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/migrations/env.py",
line 108, in <module>
> run_migrations_online()
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/migrations/env.py",
line 102, in run_migrations_online
> context.run_migrations()
> File "<string>", line 8, in run_migrations
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/runtime/environment.py",
line 846, in run_migrations
> self.get_context().run_migrations(**kw)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/runtime/migration.py",
line 522, in run_migrations
> step.migration_fn(**kw)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/airflow/migrations/versions/cf5dc11e79ad_drop_user_and_chart.py",
line 49, in upgrade
> op.drop_constraint('known_event_user_id_fkey', 'known_event')
> File "<string>", line 8, in drop_constraint
> File "<string>", line 3, in drop_constraint
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/operations/ops.py",
line 159, in drop_constraint
> return operations.invoke(op)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/operations/base.py",
line 373, in invoke
> return fn(self, operation)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/operations/toimpl.py",
line 158, in drop_constraint
> operations.impl.drop_constraint(
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/ddl/impl.py",
line 248, in drop_constraint
> self._exec(schema.DropConstraint(const))
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/alembic/ddl/impl.py",
line 141, in _exec
> return conn.execute(construct, *multiparams, **params)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1011, in execute
> return meth(self, multiparams, params)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/sql/ddl.py",
line 72, in _execute_on_connection
> return connection._execute_ddl(self, multiparams, params)
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1068, in _execute_ddl
> ret = self._execute_context(
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1316, in _execute_context
> self._handle_dbapi_exception(
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1510, in _handle_dbapi_exception
> util.raise_(
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/util/compat.py",
line 182, in raise_
> raise exception
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1276, in _execute_context
> self.dialect.do_execute(
> File
"/home/airflow/airflow/airflow_2/lib/python3.8/site-packages/sqlalchemy/engine/default.py",
line 593, in do_execute
> cursor.execute(statement, parameters)
> sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedObject)
constraint "known_event_user_id_fkey" of relation "known_event" does not exist
>
> [SQL: ALTER TABLE known_event DROP CONSTRAINT known_event_user_id_fkey]
> (Background on this error at: http://sqlalche.me/e/13/f405)
Looking forward to have support.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
