ephraimbuddy commented on pull request #21462:
URL: https://github.com/apache/airflow/pull/21462#issuecomment-1034707548
> Not sure what to do on this error from MSSQL:
>
> ```sql
> sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000',
"[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Introducing
FOREIGN KEY constraint 'task_reschedule_dr_fkey' on table 'task_reschedule' may
cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON
UPDATE NO ACTION, or modify other FOREIGN KEY constraints. (1785)
(SQLExecDirectW)")
> [SQL:
> CREATE TABLE task_reschedule (
> id INTEGER NOT NULL IDENTITY,
> task_id VARCHAR(250) NOT NULL,
> dag_id VARCHAR(250) NOT NULL,
> run_id VARCHAR(250) NOT NULL,
> map_index INTEGER NOT NULL DEFAULT -1,
> try_number INTEGER NOT NULL,
> start_date DATETIME NOT NULL,
> end_date DATETIME NOT NULL,
> duration INTEGER NOT NULL,
> reschedule_date DATETIME NOT NULL,
> PRIMARY KEY (id),
> CONSTRAINT task_reschedule_ti_fkey FOREIGN KEY(dag_id, task_id,
run_id, map_index) REFERENCES task_instance (dag_id, task_id, run_id,
map_index) ON DELETE CASCADE,
> CONSTRAINT task_reschedule_dr_fkey FOREIGN KEY(dag_id, run_id)
REFERENCES dag_run (dag_id, run_id) ON DELETE CASCADE
> )
> ```
This might be a real problem...
--
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]
