You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2022/08/27 17:42:59 UTC
[GitHub] [airflow] Jakeway commented on issue #25765: Deadlock in Scheduler Loop when Updating Dag Run
Jakeway commented on issue #25765:
URL: https://github.com/apache/airflow/issues/25765#issuecomment-1229234572
@potiuk Hello, here's the latest detected deadlock info:
```
------------------------
LATEST DETECTED DEADLOCK
------------------------
2022-08-27 00:01:20 0x14a4bc091700
*** (1) TRANSACTION:
TRANSACTION 546446888, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 2
MySQL thread id 28342642, OS thread handle 22697787754240, query id 655321967 10.0.9.225 airflow updating
UPDATE dag_run SET last_scheduling_decision='2022-08-27 00:01:20.418340' WHERE dag_run.id = 68
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 918 page no 3 n bits 144 index PRIMARY of table `airflow`.`dag_run` trx id 546446888 lock_mode X locks rec but not gap waiting
Record lock, heap no 71 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000044; asc D;;
1: len 6; hex 000020921d4d; asc M;;
2: len 7; hex 78000002942abb; asc x * ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 63080d00000000; asc c ;;
5: len 7; hex 72756e6e696e67; asc running;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32365430303a30303a3030; asc scheduled__2022-08-26T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: SQL NULL;
10: len 7; hex 63095e8503519a; asc c ^ Q ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 63095ec402ffea; asc c ^ ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 800017b5; asc ;;
15: len 7; hex 63095e800dd9e8; asc c ^ ;;
16: len 7; hex 63080d00000000; asc c ;;
17: len 7; hex 63095e80000000; asc c ^ ;;
18: len 4; hex 80000003; asc ;;
*** (2) TRANSACTION:
TRANSACTION 546446886, ACTIVE 0 sec fetching rows
mysql tables in use 3, locked 3
7 lock struct(s), heap size 1136, 53 row lock(s)
MySQL thread id 28349386, OS thread handle 22697761904384, query id 655321958 10.0.9.225 airflow Sending data
DELETE FROM rendered_task_instance_fields WHERE rendered_task_instance_fields.dag_id = 'pre_systems_execute_daily_dag' AND rendered_task_instance_fields.task_id = 'companies_morn_import_daily_price_and_nav_data_ftp_time_sensor' AND ((rendered_task_instance_fields.dag_id, rendered_task_instance_fields.task_id, rendered_task_instance_fields.run_id) NOT IN (SELECT subq2.dag_id, subq2.task_id, subq2.run_id
FROM (SELECT subq1.dag_id AS dag_id, subq1.task_id AS task_id, subq1.run_id AS run_id
FROM (SELECT DISTINCT rendered_task_instance_fields.dag_id AS dag_id, rendered_task_instance_fields.task_id AS task_id, rendered_task_instance_fields.run_id AS run_id, dag_run.execution_date AS execution_date
FROM rendered_task_instance_fields INNER JOIN dag_run ON rendered_task_instance_fields.dag_id = dag_run.dag_id AND rendered_task_instance_fields.run_id = dag_run.run_id
WHERE rendered_task_instance_fields.dag
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 918 page no 3 n bits 144 index PRIMARY of table `airflow`.`dag_run` trx id 546446886 lock mode S locks rec but not gap
Record lock, heap no 6 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000005; asc ;;
1: len 6; hex 000020049e5a; asc Z;;
2: len 7; hex 7a0000021f19b7; asc z ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62f2f500000000; asc b ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32365430303a30303a3030; asc scheduled__2022-08-26T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: SQL NULL;
10: len 7; hex 63095e8503519a; asc c ^ Q ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 63095ec402ffea; asc c ^ ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 800017b5; asc ;;
15: len 7; hex 63095e800dd9e8; asc c ^ ;;
16: len 7; hex 63080d00000000; asc c ;;
17: len 7; hex 63095e80000000; asc c ^ ;;
18: len 4; hex 80000003; asc ;;
*** (2) TRANSACTION:
TRANSACTION 546446886, ACTIVE 0 sec fetching rows
mysql tables in use 3, locked 3
7 lock struct(s), heap size 1136, 53 row lock(s)
MySQL thread id 28349386, OS thread handle 22697761904384, query id 655321958 10.0.9.225 airflow Sending data
DELETE FROM rendered_task_instance_fields WHERE rendered_task_instance_fields.dag_id = 'pre_systems_execute_daily_dag' AND rendered_task_instance_fields.task_id = 'companies_morn_import_daily_price_and_nav_data_ftp_time_sensor' AND ((rendered_task_instance_fields.dag_id, rendered_task_instance_fields.task_id, rendered_task_instance_fields.run_id) NOT IN (SELECT subq2.dag_id, subq2.task_id, subq2.run_id
FROM (SELECT subq1.dag_id AS dag_id, subq1.task_id AS task_id, subq1.run_id AS run_id
FROM (SELECT DISTINCT rendered_task_instance_fields.dag_id AS dag_id, rendered_task_instance_fields.task_id AS task_id, rendered_task_instance_fields.run_id AS run_id, dag_run.execution_date AS execution_date
FROM rendered_task_instance_fields INNER JOIN dag_run ON rendered_task_instance_fields.dag_id = dag_run.dag_id AND rendered_task_instance_fields.run_id = dag_run.run_id
WHERE rendered_task_instance_fields.dag
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 918 page no 3 n bits 144 index PRIMARY of table `airflow`.`dag_run` trx id 546446886 lock mode S locks rec but not gap
Record lock, heap no 6 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000005; asc ;;
1: len 6; hex 000020049e5a; asc Z;;
2: len 7; hex 7a0000021f19b7; asc z ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62f2f500000000; asc b ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31305430303a30303a3030; asc scheduled__2022-08-10T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62f4a16007d45d; asc b ` ];;
10: len 7; hex 62f46a190803f2; asc b j ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62f4a16007ba20; asc b ` ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80000001; asc ;;
15: len 7; hex 62f46a19075802; asc b j X ;;
16: len 7; hex 62f2f500000000; asc b ;;
17: len 7; hex 62f44680000000; asc b F ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 9 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000008; asc ;;
1: len 6; hex 0000200e1690; asc ;;
2: len 7; hex 35000002a12ff1; asc 5 / ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62f44680000000; asc b F ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31315430303a30303a3030; asc scheduled__2022-08-11T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62f5f3840b4270; asc b Bp;;
10: len 7; hex 62f598000a2089; asc b ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62f5f3840af2b3; asc b ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80000001; asc ;;
15: len 7; hex 62f5980008aa7c; asc b |;;
16: len 7; hex 62f44680000000; asc b F ;;
17: len 7; hex 62f59800000000; asc b ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 13 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 8000000c; asc ;;
1: len 6; hex 000020173685; asc 6 ;;
2: len 7; hex 7f000040131799; asc @ ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62f59800000000; asc b ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31325430303a30303a3030; asc scheduled__2022-08-12T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62f7445a0e9648; asc b DZ H;;
10: len 7; hex 62f6e982075128; asc b Q(;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62f7445a0e34d9; asc b DZ 4 ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80000491; asc ;;
15: len 7; hex 62f6e9800c27ca; asc b ' ;;
16: len 7; hex 62f59800000000; asc b ;;
17: len 7; hex 62f6e980000000; asc b ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 17 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000010; asc ;;
1: len 6; hex 00002020604f; asc `O;;
2: len 7; hex 39000002172658; asc 9 &X;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62f6e980000000; asc b ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31335430303a30303a3030; asc scheduled__2022-08-13T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62f88fd3073b81; asc b ; ;;
10: len 7; hex 62f83b0007adcb; asc b ; ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62f88fd3070a41; asc b A;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 800005a3; asc ;;
15: len 7; hex 62f83b00064673; asc b ; Fs;;
16: len 7; hex 62f6e980000000; asc b ;;
17: len 7; hex 62f83b00000000; asc b ; ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 21 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000014; asc ;;
1: len 6; hex 000020293045; asc )0E;;
2: len 7; hex 250000019b0598; asc % ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62f83b00000000; asc b ; ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31345430303a30303a3030; asc scheduled__2022-08-14T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62f9e155012b50; asc b U +P;;
10: len 7; hex 62f98c800b3655; asc b 6U;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62f9e15500d72c; asc b U ,;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 8000076c; asc l;;
15: len 7; hex 62f98c800832d3; asc b 2 ;;
16: len 7; hex 62f83b00000000; asc b ; ;;
17: len 7; hex 62f98c80000000; asc b ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 25 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000018; asc ;;
1: len 6; hex 0000203232c0; asc 22 ;;
2: len 7; hex 6a000002b71149; asc j I;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62f98c80000000; asc b ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31355430303a30303a3030; asc scheduled__2022-08-15T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62fb399a013146; asc b 9 1F;;
10: len 7; hex 62fade00074a75; asc b Ju;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62fb399a00d1d8; asc b 9 ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80000852; asc R;;
15: len 7; hex 62fade000608a0; asc b ;;
16: len 7; hex 62f98c80000000; asc b ;;
17: len 7; hex 62fade00000000; asc b ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 29 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 8000001c; asc ;;
1: len 6; hex 0000203b4eb4; asc ;N ;;
2: len 7; hex 3f0000002d08fe; asc ? - ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62fade00000000; asc b ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31365430303a30303a3030; asc scheduled__2022-08-16T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62fc8b1501d93e; asc b >;;
10: len 7; hex 62fc2f8008a54d; asc b / M;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62fc8b1501837b; asc b {;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 8000094c; asc L;;
15: len 7; hex 62fc2f8007f68d; asc b / ;;
16: len 7; hex 62fade00000000; asc b ;;
17: len 7; hex 62fc2f80000000; asc b / ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 33 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000020; asc ;;
1: len 6; hex 000020446c6f; asc Dlo;;
2: len 7; hex 2c000003051592; asc , ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62fc2f80000000; asc b / ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31375430303a30303a3030; asc scheduled__2022-08-17T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62fddc9e02e060; asc b `;;
10: len 7; hex 62fd810008a510; asc b ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62fddc9e02a9f3; asc b ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80000ace; asc ;;
15: len 7; hex 62fd810001a954; asc b T;;
16: len 7; hex 62fc2f80000000; asc b / ;;
17: len 7; hex 62fd8100000000; asc b ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 37 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000024; asc $;;
1: len 6; hex 0000204d609e; asc M` ;;
2: len 7; hex 2a0000401a0976; asc * @ v;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62fd8100000000; asc b ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31385430303a30303a3030; asc scheduled__2022-08-18T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 62ff2e20084ca2; asc b . L ;;
10: len 7; hex 62fed280071b06; asc b ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 62ff2e200802af; asc b . ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80000c7b; asc {;;
15: len 7; hex 62fed28005c4d9; asc b ;;
16: len 7; hex 62fd8100000000; asc b ;;
17: len 7; hex 62fed280000000; asc b ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 41 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000028; asc (;;
1: len 6; hex 00002056425d; asc VB];;
2: len 7; hex 350000033f0110; asc 5 ? ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 62fed280000000; asc b ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d31395430303a30303a3030; asc scheduled__2022-08-19T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 63007ed90e0268; asc c ~ h;;
10: len 7; hex 630024040e7ca2; asc c $ | ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 63007ed90dbac8; asc c ~ ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80000ded; asc ;;
15: len 7; hex 63002401014419; asc c $ D ;;
16: len 7; hex 62fed280000000; asc b ;;
17: len 7; hex 63002400000000; asc c $ ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 45 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 8000002c; asc ,;;
1: len 6; hex 0000205f2d59; asc _-Y;;
2: len 7; hex 660000025b0cef; asc f [ ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 63002400000000; asc c $ ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32305430303a30303a3030; asc scheduled__2022-08-20T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 6301ca620d5f6b; asc c b _k;;
10: len 7; hex 6301758202efef; asc c u ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 6301ca620d03cc; asc c b ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80000f75; asc u;;
15: len 7; hex 630175810685af; asc c u ;;
16: len 7; hex 63002400000000; asc c $ ;;
17: len 7; hex 63017580000000; asc c u ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 49 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000030; asc 0;;
1: len 6; hex 00002067cd80; asc g ;;
2: len 7; hex 7f0000030c11a4; asc ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 63017580000000; asc c u ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32315430303a30303a3030; asc scheduled__2022-08-21T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 63031be30eb393; asc c ;;
10: len 7; hex 6302c70109a0f4; asc c ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 63031be30e740e; asc c t ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 8000113a; asc :;;
15: len 7; hex 6302c701066dd0; asc c m ;;
16: len 7; hex 63017580000000; asc c u ;;
17: len 7; hex 6302c700000000; asc c ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 53 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000034; asc 4;;
1: len 6; hex 00002070a94c; asc p L;;
2: len 7; hex 2e0000401a0f88; asc . @ ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 6302c700000000; asc c ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32325430303a30303a3030; asc scheduled__2022-08-22T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 630473920b3633; asc c s 63;;
10: len 7; hex 6304188004cc6b; asc c k;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 630473920adecd; asc c s ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 80001233; asc 3;;
15: len 7; hex 6304188003dbca; asc c ;;
16: len 7; hex 6302c700000000; asc c ;;
17: len 7; hex 63041880000000; asc c ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 57 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000038; asc 8;;
1: len 6; hex 0000207999d2; asc y ;;
2: len 7; hex 30000001a114eb; asc 0 ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 63041880000000; asc c ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32335430303a30303a3030; asc scheduled__2022-08-23T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 6305c4e80e1283; asc c ;;
10: len 7; hex 63056a010096ff; asc c j ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 6305c4e80dc9eb; asc c ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 8000139d; asc ;;
15: len 7; hex 63056a000daaae; asc c j ;;
16: len 7; hex 63041880000000; asc c ;;
17: len 7; hex 63056a00000000; asc c j ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 61 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 8000003c; asc <;;
1: len 6; hex 0000208261d6; asc a ;;
2: len 7; hex 25000001a1083a; asc % :;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 63056a00000000; asc c j ;;
5: len 7; hex 73756363657373; asc success;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32345430303a30303a3030; asc scheduled__2022-08-24T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: len 7; hex 630716a40b8d47; asc c G;;
10: len 7; hex 6306bb800cc8d8; asc c ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 630716a40b4c13; asc c L ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 800014c2; asc ;;
15: len 7; hex 6306bb800bbc12; asc c ;;
16: len 7; hex 6306bb80000000; asc c ;;
17: len 7; hex 63080d00000000; asc c ;;
18: len 4; hex 80000003; asc ;;
Record lock, heap no 71 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000044; asc D;;
1: len 6; hex 000020921d4d; asc M;;
2: len 7; hex 78000002942abb; asc x * ;;
3: len 29; hex 7072655f73797374656d735f657865637574655f6461696c795f646167; asc pre_systems_execute_daily_dag;;
4: len 7; hex 63080d00000000; asc c ;;
5: len 7; hex 72756e6e696e67; asc running;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32365430303a30303a3030; asc scheduled__2022-08-26T00:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: SQL NULL;
10: len 7; hex 63095e8503519a; asc c ^ Q ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 63095ec402ffea; asc c ^ ;;
13: len 30; hex 326631633932343536356338636261623431663839623137336539386462; asc 2f1c924565c8cbab41f89b173e98db; (total 32 bytes);
14: len 4; hex 800017b5; asc ;;
15: len 7; hex 63095e800dd9e8; asc c ^ ;;
16: len 7; hex 63080d00000000; asc c ;;
17: len 7; hex 63095e80000000; asc c ^ ;;
18: len 4; hex 80000003; asc ;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 918 page no 3 n bits 144 index PRIMARY of table `airflow`.`dag_run` trx id 546446886 lock mode S locks rec but not gap waiting
Record lock, heap no 67 PHYSICAL RECORD: n_fields 19; compact format; info bits 0
0: len 4; hex 80000043; asc C;;
1: len 6; hex 000020921e28; asc (;;
2: len 7; hex 26000002a003db; asc & ;;
3: len 30; hex 706f73745f73797374656d735f657865637574655f6461696c795f646167; asc post_systems_execute_daily_dag;;
4: len 7; hex 63072c00000000; asc c , ;;
5: len 7; hex 72756e6e696e67; asc running;;
6: len 30; hex 7363686564756c65645f5f323032322d30382d32355430383a30303a3030; asc scheduled__2022-08-25T08:00:00; (total 36 bytes);
7: len 1; hex 80; asc ;;
8: len 5; hex 80047d942e; asc } .;;
9: SQL NULL;
10: len 7; hex 63087d8005db17; asc c } ;;
11: len 9; hex 7363686564756c6564; asc scheduled;;
12: len 7; hex 63095ed00758f8; asc c ^ X ;;
13: len 30; hex 343733383036626236666630353639313862303331313763323435613166; asc 473806bb6ff056918b03117c245a1f; (total 32 bytes);
14: len 4; hex 800017b5; asc ;;
15: len 7; hex 63087d8005002e; asc c } .;;
16: len 7; hex 63072c00000000; asc c , ;;
17: len 7; hex 63087d80000000; asc c } ;;
18: len 4; hex 80000003; asc ;;
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 546861435
Purge done for trx's n:o < 546861431 undo n:o < 0 state: running but idle
History list length 16
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 304173199398320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 304173199394640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 304173199395560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 304173199399240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 304173199397400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 304173199400160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 304173199396480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
```
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org