2020-11-25T17:19:27.808054Z 1620319561 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-11-25T17:19:27.808083Z 1620319561 [Note] InnoDB:
*** (1) TRANSACTION:
TRANSACTION 2564094879, ACTIVE 0 sec starting index read
mysql tables in use 3, locked 3
LOCK WAIT 13 lock struct(s), heap size 1136, 13 row lock(s)
MySQL thread id 1620120128, OS thread handle 140645850257152, query id 28985136377 bi-airflow 10.19.7.193 airflow Sending data
UPDATE task_instance, (SELECT task_instance.try_number AS try_number, task_instance.task_id AS task_id, task_instance.dag_id AS dag_id,
task_instance.execution_date AS execution_date, tas
k_instance.start_date AS start_date, task_instance.end_date AS end_date, task_instance.duration AS duration, task_instance.state AS state,
task_instance.max_tries AS max_tries, task_insta
nce.hostname AS hostname, task_instance.unixname AS unixname, task_instance.job_id AS job_id, task_instance.pool AS pool, task_instance.queue AS queue,
task_instance.priority_weight AS pr
iority_weight, task_instance.operator AS operator, task_instance.queued_dttm AS queued_dttm, task_instance.pid AS pid, task_instance.executor_config AS
executor_config
FROM task_instance LEFT OUTER JOIN dag_run ON task_instance.dag_id = dag_run.dag_id AND task_instance.execution_date = dag_run.execution_date
WHERE task_instance.dag
2020-11-25T17:19:27.808128Z 1620319561 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 795 page no 12085 n bits 144 index PRIMARY of table `airflow_v10`.`task_instance` trx id 2564094879 lock_mode X locks rec but not
gap waiting
Record lock, heap no 77 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
0: len 14; hex 666c6f7765725f73706163653735; asc flower_space75;;
1: len 30; hex 6d7973716c32686466735f6e6577636c75737465722e666c6f7765725f73; asc mysql2hdfs_newcluster.flower_s; (total 34 bytes);
2: len 7; hex 5fbcbdbc000000; asc _ ;;
3: len 6; hex 000098d4fb9e; asc ;;
4: len 7; hex 3200000152251c; asc 2 R% ;;
5: len 7; hex 5fbe219e0f3753; asc _ ! 7S;;
6: len 7; hex 5fbe219e0f3774; asc _ ! 7t;;
7: SQL NULL;
8: len 6; hex 717565756564; asc queued;;
9: len 4; hex 80000000; asc ;;
10: len 30; hex 646174612d6864706879736963616c2d6d6173746572312e75626a32652e; asc data-hdphysical-master1.ubj2e.; (total 45 bytes);
11: len 6; hex 6861646f6f70; asc hadoop;;
12: SQL NULL;
13: SQL NULL;
14: len 15; hex 6861646f6f702d706879736963616c; asc hadoop-physical;;
15: len 4; hex 80000001; asc ;;
16: SQL NULL;
17: SQL NULL;
18: SQL NULL;
19: len 4; hex 80000003; asc ;;
20: len 14; hex 80049503000000000000007d942e; asc } .;;
2020-11-25T17:19:27.809329Z 1620319561 [Note] InnoDB: *** (2) TRANSACTION:
TRANSACTION 2564094878, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 1620319561, OS thread handle 140645844399872, query id 28985136390 data-hdphysical-master1 10.42.31.63 airflow updating
UPDATE task_instance SET state='queued' WHERE task_instance.task_id = 'flower_space75' AND task_instance.dag_id =
'mysql2hdfs_newcluster.flower_space' AND task_instance.execution_date = '
2020-11-24 16:01:00'
2020-11-25T17:19:27.809361Z 1620319561 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 795 page no 12085 n bits 144 index PRIMARY of table `airflow_v10`.`task_instance` trx id 2564094878 lock_mode X locks rec but not
gap
Record lock, heap no 77 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
0: len 14; hex 666c6f7765725f73706163653735; asc flower_space75;;
1: len 30; hex 6d7973716c32686466735f6e6577636c75737465722e666c6f7765725f73; asc mysql2hdfs_newcluster.flower_s; (total 34 bytes);
2: len 7; hex 5fbcbdbc000000; asc _ ;;
3: len 6; hex 000098d4fb9e; asc ;;
4: len 7; hex 3200000152251c; asc 2 R% ;;
5: len 7; hex 5fbe219e0f3753; asc _ ! 7S;;
6: len 7; hex 5fbe219e0f3774; asc _ ! 7t;;
7: SQL NULL;
8: len 6; hex 717565756564; asc queued;;
9: len 4; hex 80000000; asc ;;
10: len 30; hex 646174612d6864706879736963616c2d6d6173746572312e75626a32652e; asc data-hdphysical-master1.ubj2e.; (total 45 bytes);
11: len 6; hex 6861646f6f70; asc hadoop;;
12: SQL NULL;
13: SQL NULL;
14: len 15; hex 6861646f6f702d706879736963616c; asc hadoop-physical;;
15: len 4; hex 80000001; asc ;;
16: SQL NULL;
17: SQL NULL;
18: SQL NULL;
19: len 4; hex 80000003; asc ;;
20: len 14; hex 80049503000000000000007d942e; asc } .;;
2020-11-25T17:19:27.810639Z 1620319561 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 795 page no 50940 n bits 312 index ti_dag_state of table `airflow_v10`.`task_instance` trx id 2564094878 lock_mode X locks rec but
not gap waiting
Record lock, heap no 229 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
评论0