[ 
https://issues.apache.org/jira/browse/AIRFLOW-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16786088#comment-16786088
 ] 

ASF subversion and git services commented on AIRFLOW-3761:
----------------------------------------------------------

Commit f3156d771ae8cda5daf53e936dc0b3a258ce6924 in airflow's branch 
refs/heads/master from Ash Berlin-Taylor
[ https://gitbox.apache.org/repos/asf?p=airflow.git;h=f3156d7 ]

[AIRFLOW-3761] Fix `DROP TABLE user` migration for upgrades. (#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.)

> 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)

Reply via email to