[jira] [Created] (AIRFLOW-4231) Airflow Manual trigger not working | when connected to SQL server

["Raja Saheem Khan (JIRA)" <ji...@apache.org>]

Raja Saheem Khan created AIRFLOW-4231:
-----------------------------------------

             Summary: Airflow Manual trigger not working | when connected to SQL server
                 Key: AIRFLOW-4231
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-4231
             Project: Apache Airflow
          Issue Type: Bug
          Components: scheduler
    Affects Versions: 1.10.1
            Reporter: Raja Saheem Khan
         Attachments: Aiflow_Dag_Run.jpg, jobs_py.JPG, scheduler_logs.txt

I am using Airflow with SQL server DB.
 * I am trying to manually run a Dag from Airflow screen and from cli using "airflow trigger_dag <dagid>. In both the cases the Dag run successfully but never get picked by scheduler.
 * If I try to schedule a Dag run then it works fine.
 * I did the analysis and found that task_instance table does not get populate and a result of which the scheduler does not process the dag.
 * As I checked the code, I found that line no. 954 of jobs.py does not return any task. \{code} tis = run.get_task_instances(state=(State.NONE,
 State.UP_FOR_RETRY)) \{code}
 * When should the task_instance table be populated?

Logs and screen shots are attached for your reference. Could you please look into the issue and let me know in case more information is required on this.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)