Mailing-List: contact dev-help@airflow.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@airflow.incubator.apache.org
MIME-Version: 1.0
From: manish ranjan <cse1.manish@gmail.com>
Date: Wed, 12 Jul 2017 14:23:13 -0700
Message-ID: <CAG0BdMVBv7GLTqW2MLJ2hBiKMWhM+3thftk3oExaZZjx_PCBdw@mail.gmail.com>
Subject: Trying to get rid of a DAG from UI after running it for a while
To: dev@airflow.incubator.apache.org
Content-Type: multipart/alternative; boundary="94eb2c1a1e22a8139d0554256d05"
archived-at: Wed, 12 Jul 2017 21:34:00 -0000

--94eb2c1a1e22a8139d0554256d05
Content-Type: text/plain; charset="UTF-8"

Hi All,

I have had a DAG, which I needed to clean up from UI (airflow version
v1.7.1.3)

Following this Jira <https://issues.apache.org/jira/browse/AIRFLOW-1002> I
deleted manually from all the tables
queries = {'delete from *xcom* where dag_id = "' + dag_input + '"',
        'delete from *task_instance* where dag_id = "' + dag_input + '"',
        'delete from *sla_miss* where dag_id = "' + dag_input + '"',
        'delete from *log* where dag_id = "' + dag_input + '"',
        'delete from *job* where dag_id = "' + dag_input + '"',
        'delete from *dag_run* where dag_id = "' + dag_input + '"',
        'delete from *dag* where dag_id = "' + dag_input + '"' }

But the dag from airflow UI just won't go away :( Is there something basic
I am missing?

PS: I also saw that you guys have merged this PR
<https://github.com/apache/incubator-airflow/pull/2199> just a few days
back so we will be able to do this from CLI. Thanks for that. But how can I
do this today?

~Manish

--94eb2c1a1e22a8139d0554256d05--