Airflow 2.0 crashed due airflow db reset command

[nvnvashisth]

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
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 "", line 783, in exec_module
File "", 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
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 "", 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 "", line 8, in drop_constraint
File "", 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.

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template!

[jaimegm]

It's not required to reset your db to stop the Web UI from loading the examples. Resetting your db will erase all of your credentials Usually adjusting the airflow.cfg, reinstall and restart will remove the example dags. It looks a issue related to your upgrade. Its recommended upgrading to 1.10.15 before upgrading to 2.0 and running checks.

Upgrading to 2.0

I attempted to upgrade without using the bridge release and received an error similar to what you are seeing

[github-actions]

This issue has been automatically marked as stale because it has been open for 30 days with no response from the author. It will be closed in next 7 days if no further activity occurs from the issue author.

[github-actions]

This issue has been closed because it has not received response from the issue author.