[
https://issues.apache.org/jira/browse/AIRFLOW-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16784563#comment-16784563
]
ASF GitHub Bot commented on AIRFLOW-3761:
-----------------------------------------
ashb commented on pull request #4840: [AIRFLOW-3761] Fix `DROP TABLE user`
migration for upgrades.
URL: https://github.com/apache/airflow/pull/4840
If you are upgrading an old install you will likely have rows in the
user and known_event tables. We dropped the KnownEvent without a
migration to remove it (on purpose) in [AIRFLOW-3468] (#4421) but this
means if we have any rows in there we won't be able to drop the USER
table:
> sqlalchemy.exc.InternalError: (psycopg2.InternalError) cannot drop table
users because other objects depend on it
> DETAIL: constraint known_event_user_id_fkey on table known_event depends
on table users
So we need to drop that FK constraint first (if the table exists, which
it won't on a fresh install, as the create migration has been deleted.)
cc @Fokko @XD-DENG
### Jira
https://issues.apache.org/jira/browse/AIRFLOW-3761
----------------------------------------------------------------
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]
> Decommission User & Chart models; Update doc accordingly
> --------------------------------------------------------
>
> Key: AIRFLOW-3761
> URL: https://issues.apache.org/jira/browse/AIRFLOW-3761
> Project: Apache Airflow
> Issue Type: Improvement
> Reporter: Xiaodong DENG
> Assignee: Xiaodong DENG
> Priority: Critical
>
> In master branch, we have already decommissioned the Flask-Admin UI.
> In model definitions, User and Chart are only applicable for the "old" UI
> based on Flask-Admin. Hence we should decommission these two models as well.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
