Unable to delete user via CI

[casper-voltgoed]

Apache Airflow version

2.6.1

What happened

I am unable to delete users via the "delete command".

I am trying to create a new user delete the default admin user. so I tried running the command airflow users delete -u admin. Running this command gave the following error output:

Feature not implemented,tasks route disabled

/usr/local/lib/python3.10/site-packages/flask_limiter/extension.py:293 UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend.
/usr/local/lib/python3.10/site-packages/astronomer/airflow/version_check/update_checks.py:440 UserWarning: The setup method 'app_context_processor' can no longer be called on the blueprint 'UpdateAvailableView'. It has already been registered at least once, any changes will not be applied consistently.
Make sure all imports, decorators, functions, etc. needed to set up the blueprint are done before registering it.
This warning will become an exception in Flask 2.3.
/usr/local/lib/python3.10/site-packages/flask/blueprints.py:673 UserWarning: The setup method 'record_once' can no longer be called on the blueprint 'UpdateAvailableView'. It has already been registered at least once, any changes will not be applied consistently.
Make sure all imports, decorators, functions, etc. needed to set up the blueprint are done before registering it.
This warning will become an exception in Flask 2.3.
/usr/local/lib/python3.10/site-packages/flask/blueprints.py:321 UserWarning: The setup method 'record' can no longer be called on the blueprint 'UpdateAvailableView'. It has already been registered at least once, any changes will not be applied consistently.
Make sure all imports, decorators, functions, etc. needed to set up the blueprint are done before registering it.
This warning will become an exception in Flask 2.3.
/usr/local/lib/python3.10/site-packages/airflow/www/fab_security/sqla/manager.py:151 SAWarning: Object of type <Role> not in session, delete operation along 'User.roles' won't proceed

[2023-05-24T12:34:19.438+0000] {manager.py:154} ERROR - Remove Register User Error: (psycopg2.errors.ForeignKeyViolation) update or delete on table "ab_user" violates foreign key constraint "ab_user_role_user_id_fkey" on table "ab_user_role"
DETAIL:  Key (id)=(4) is still referenced from table "ab_user_role".

[SQL: DELETE FROM ab_user WHERE ab_user.id = %(id)s]
[parameters: {'id': 4}]
(Background on this error at: https://sqlalche.me/e/14/gkpj)
Failed to delete user

Deleting via the UI works fine.
The error also occurs for users that have a different role, such as Viewer.

What you think should happen instead

No error should occur and the specified user should be deleted.

How to reproduce

Run a Dag with a task that is a BashOperator that deletes the user e.g.:

    remove_default_admin_user_task = BashOperator(task_id="remove_default_admin_user",
                                                  bash_command="airflow users delete -u admin")

Operating System

Docker containers run in Debian 10

Versions of Apache Airflow Providers

Astronomer

Deployment

Astronomer

Deployment details

I use Astronomer 8.0.0

Anything else

Always. It also occurs when ran inside the webserver docker container or when ran via the astro CLI with the command astro dev run airflow users delete -u admin.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct