Deadlock found when trying to update task_instance table

[gdbassett]

I'm trying to figure out if the issue here https://issues.apache.org/jira/browse/AIRFLOW-2516 from JIRA has been fixed. I couldn't find a reference to it in the issues, but may have missed where it was documented. We are currently having the issue with airflow 1.10.12 (locked in until May or June except for critical updates) causing deadlocks about 70% of the time on a dynamically generated subdag.

[2021-01-29 05:02:02,649] {{taskinstance.py:1128}} ERROR - (_mysql_exceptions.OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction')
[SQL: UPDATE task_instance SET state=%s, queued_dttm=%s WHERE task_instance.task_id = %s AND task_instance.dag_id = %s AND task_instance.execution_date = %s]
[parameters: ('queued', datetime.datetime(2021, 1, 29, 5, 1, 47, 22685, tzinfo=<Timezone [UTC]>), 'task_name', 'dag.dag_sub', datetime.datetime(2021, 1, 28, 5, 0, tzinfo=<Timezone [UTC]>))]