ashb commented on issue #21407: URL: https://github.com/apache/airflow/issues/21407#issuecomment-1033619255
> @ashb ah, i know how to reproduce it in the local. > > If i don't do `airflow users create -e admin@local -u admin -p admin -r Admin -f Admin -l Admin` after I init the db, `airflow webserver` won't start, due to: `AssertionError: Dependency rule tried to blank-out primary key column 'ab_permission.id' on instance '` > > but, if i created a user, it worked fine. No luck -- doesn't work for me :/ Webserver still launches. This is what I see in the output ``` /usr/local/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py:3463 SAWarning: relationship 'DagRun.serialized_dag' will copy column serialized_dag.dag_id to column dag_run.dag_id, which conflicts with relationship(s): 'BaseXCom.dag_run' (copies xcom.dag_id to dag_run.dag_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. The 'overlaps' parameter may be used to remove this warning. (Background on this error at: http://sqlalche.me/e/14/qzyx) /usr/local/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py:3463 SAWarning: relationship 'SerializedDagModel.dag_runs' will copy column serialized_dag.dag_id to column dag_run.dag_id, which conflicts with relationship(s): 'BaseXCom.dag_run' (copies xcom.dag_id to dag_run.dag_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. The 'overlaps' parameter may be used to remove this warning. (Background on this error at: http://sqlalche.me/e/14/qzyx) /opt/airflow/airflow/www/fab_security/sqla/manager.py:102 SADeprecationWarning: The from_engine() method on Inspector is deprecated and will be removed in a future release. Please use the sqlalchemy.inspect() function on an Engine or Connection in order to acquire an Inspector. (deprecated since: 1.4) [2022-02-09 10:42:51,209] {manager.py:792} WARNING - No user yet created, use flask fab command to do it. [2022-02-09 10:42:51,339] {manager.py:534} WARNING - Refused to delete permission view, assoc with role exists Permissions.menu_access Admin [2022-02-09 10:42:51,495] {manager.py:534} WARNING - Refused to delete permission view, assoc with role exists DAG Runs.can_create Admin [2022-02-09 10:42:51,610] {manager.py:534} WARNING - Refused to delete permission view, assoc with role exists Task Instances.can_edit Admin ``` -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
