tanvn commented on issue #27296:
URL: https://github.com/apache/airflow/issues/27296#issuecomment-1455108659
Thanks for the information!
And one thing I should have mentioned here is that we have a hourly DAG that
has about 130 independent tasks (but the DAG's Concurrency is set to 32. And I
think somehow that is why we are hitting the error like below quite often.
```
[2023-03-05, 23:07:38 JST] {standard_task_runner.py:100} ERROR - Failed to
execute job 2083194 for task my_task ((MySQLdb.OperationalError) (1205, 'Lock
wait timeout exceeded; try restarting transaction')
[SQL: UPDATE dag_run SET last_scheduling_decision=%s, updated_at=%s WHERE
dag_run.id = %s]
```
(however, the tasks are retried and the DAG would be finished in the end)
But I am not sure if this has anything to do with the alert of `Too many
(more than 40) concurrent queries have been running.` I got from MySQL server.
--
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]