=====================================
2017-11-15 16:31:12 d70 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 58 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 29199 srv_active, 0 srv_shutdown, 84384 srv_idle
srv_master_thread log flush and writes: 113583
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 52099
OS WAIT ARRAY INFO: signal count 101931
Mutex spin waits 132924, rounds 718233, OS waits 19555
RW-shared spins 50999, rounds 976739, OS waits 31206
RW-excl spins 10188, rounds 124600, OS waits 1166
Spin rounds per wait: 5.40 mutex, 19.15 RW-shared, 12.23 RW-excl
------------------------
LATEST DETECTED DEADLOCK
------------------------
2017-11-15 15:34:25 12c8
*** (1) TRANSACTION:
TRANSACTION 52034947, ACTIVE 4774 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 28 lock struct(s), heap size 6544, 9 row lock(s), undo log entries 78
MySQL thread id 1074, OS thread handle 0xe00, query id 8959849 localhost 127.0.0.1 root updating
UPDATE organ SET id='8eed7d7d-1800-4292-a2e1-8544fceccae1',name='办公室',duty='负责分发药品及劳保用品',person='蹇阅',person_id='0a77b193-be18-42be-9a8d-754cdb7a04bd',person_duty='负责分发药品及劳保用品',is_safety_committee='0',is_safety_organ='0',is_train='1',is_hang='1',is_public='1',pid='',type=1 WHERE id='8eed7d7d-1800-4292-a2e1-8544fceccae1'
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 507 page no 756 n bits 88 index `PRIMARY` of table `safety`.`organ` trx id 52034947 lock_mode X locks rec but not gap waiting
Record lock, heap no 15 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 30; hex 38656564376437642d313830302d343239322d613265312d383534346663; asc 8eed7d7d-1800-4292-a2e1-8544fc; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2770; asc " 'p;;
3: len 9; hex e58a9ee585ace5aea4; asc ;;
4: len 30; hex e8b49fe8b4a3e58886e58f91e88dafe59381e58f8ae58ab3e4bf9de794a8; asc ; (total 33 bytes);
5: len 6; hex e8b987e99885; asc ;;
6: len 30; hex 30613737623139332d626531382d343262652d396138642d373534636462; asc 0a77b193-be18-42be-9a8d-754cdb; (total 36 bytes);
7: len 30; hex e8b49fe8b4a3e58886e58f91e88dafe59381e58f8ae58ab3e4bf9de794a8; asc ; (total 33 bytes);
8: len 0; hex ; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 0; hex ; asc ;;
11: len 4; hex 5a0bed33; asc Z 3;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 4; hex 80000001; asc ;;
15: len 30; hex 32323933343563332d303535332d343966322d386563342d653530663434; asc 229345c3-0553-49f2-8ec4-e50f44; (total 36 bytes);
16: len 4; hex 8000c8f3; asc ;;
17: SQL NULL;
18: SQL NULL;
19: len 4; hex 80000000; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000000; asc ;;
*** (2) TRANSACTION:
TRANSACTION 52032926, ACTIVE 4898 sec fetching rows, thread declared inside InnoDB 1917
mysql tables in use 1, locked 1
2927 lock struct(s), heap size 276008, 27 row lock(s), undo log entries 113
MySQL thread id 1079, OS thread handle 0x12c8, query id 8959883 localhost 127.0.0.1 root updating
UPDATE person SET organ_name='办公室' WHERE organ_id='8eed7d7d-1800-4292-a2e1-8544fceccae1'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 507 page no 756 n bits 80 index `PRIMARY` of table `safety`.`organ` trx id 52032926 lock_mode X locks rec but not gap
Record lock, heap no 15 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 30; hex 38656564376437642d313830302d343239322d613265312d383534346663; asc 8eed7d7d-1800-4292-a2e1-8544fc; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2770; asc " 'p;;
3: len 9; hex e58a9ee585ace5aea4; asc ;;
4: len 30; hex e8b49fe8b4a3e58886e58f91e88dafe59381e58f8ae58ab3e4bf9de794a8; asc ; (total 33 bytes);
5: len 6; hex e8b987e99885; asc ;;
6: len 30; hex 30613737623139332d626531382d343262652d396138642d373534636462; asc 0a77b193-be18-42be-9a8d-754cdb; (total 36 bytes);
7: len 30; hex e8b49fe8b4a3e58886e58f91e88dafe59381e58f8ae58ab3e4bf9de794a8; asc ; (total 33 bytes);
8: len 0; hex ; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 0; hex ; asc ;;
11: len 4; hex 5a0bed33; asc Z 3;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 4; hex 80000001; asc ;;
15: len 30; hex 32323933343563332d303535332d343966322d386563342d653530663434; asc 229345c3-0553-49f2-8ec4-e50f44; (total 36 bytes);
16: len 4; hex 8000c8f3; asc ;;
17: SQL NULL;
18: SQL NULL;
19: len 4; hex 80000000; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000000; asc ;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 1091 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52032926 lock_mode X locks rec but not gap waiting
Record lock, heap no 39 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 38363334386331362d323932632d343132622d623337352d643330393364; asc 86348c16-292c-412b-b375-d3093d; (total 36 bytes);
1: len 6; hex 00000319fd83; asc ;;
2: len 7; hex 6f000007d910aa; asc o ;;
3: len 6; hex e58689e9949f; asc ;;
4: len 30; hex 34373936363134322d626664662d343536662d396533632d626662623436; asc 47966142-bfdf-456f-9e3c-bfbb46; (total 36 bytes);
5: SQL NULL;
6: len 30; hex 62643830623261622d663833642d346331332d393537312d663266323135; asc bd80b2ab-f83d-4c13-9571-f2f215; (total 36 bytes);
7: len 9; hex e9809ae998b2e983a8; asc ;;
8: SQL NULL;
9: len 4; hex 80000000; asc ;;
10: len 11; hex 3135313836313231333835; asc 15186121385;;
11: len 30; hex e5b297e4bd8de5b7a5e4bd9ce8818ce8b4a30d0a31e38081e59ca8e79fbf; asc 1 ; (total 906 bytes);
12: SQL NULL;
13: SQL NULL;
14: len 30; hex e8b4b5e998b3e5b882e8a782e5b1b1e6b996e58cbae98791e58d8ee99587; asc ; (total 36 bytes);
15: len 18; hex 353230313132313938373034323833323133; asc 520112198704283213;;
16: len 5; hex 993af80000; asc : ;;
17: len 12; hex e8b4b5e5b79ee8b4b5e998b3; asc ;;
18: len 6; hex e5b7b2e5a99a; asc ;;
19: len 6; hex e4b8ade4b893; asc ;;
20: len 5; hex 999e100000; asc ;;
21: len 5; hex 999e100000; asc ;;
22: len 9; hex e68a80e69cafe59198; asc ;;
23: SQL NULL;
24: len 0; hex ; asc ;;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 353439643562306232303135343630386162666235633838326639313136; asc 549d5b0b20154608abfb5c882f9116; (total 32 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 30; hex 63666339376138352d333363652d346136632d616565322d616535363537; asc cfc97a85-33ce-4a6c-aee2-ae5657; (total 36 bytes);
31: len 9; hex e9809ae998b2e983a8; asc ;;
32: SQL NULL;
33: len 4; hex 80039d52; asc R;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bec43; asc Z C;;
39: len 4; hex 80000000; asc ;;
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 52214760
Purge done for trx's n:o < 52214639 undo n:o < 0 state: running but idle
History list length 2216
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 52213869, not started
MySQL thread id 1234, OS thread handle 0x16e4, query id 9612046 iZxmk4ttcjds6jZ 60.205.171.98 root cleaning up
---TRANSACTION 52183837, not started
MySQL thread id 1232, OS thread handle 0x1448, query id 9476473 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52183831, not started
MySQL thread id 1230, OS thread handle 0xa98, query id 9476493 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52166340, not started
MySQL thread id 1229, OS thread handle 0x10c0, query id 9402295 114.244.6.112 root cleaning up
---TRANSACTION 52166447, not started
MySQL thread id 1228, OS thread handle 0x11bc, query id 9402736 114.244.6.112 root cleaning up
---TRANSACTION 52211549, not started
MySQL thread id 1227, OS thread handle 0x764, query id 9599208 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52148617, not started
MySQL thread id 1226, OS thread handle 0xe60, query id 9322906 iZxmk4ttcjds6jZ 60.205.171.98 root cleaning up
---TRANSACTION 52184926, not started
MySQL thread id 1225, OS thread handle 0xd30, query id 9481160 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185954, not started
MySQL thread id 1222, OS thread handle 0x1038, query id 9485737 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52211541, not started
MySQL thread id 1221, OS thread handle 0xd98, query id 9599154 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185926, not started
MySQL thread id 1220, OS thread handle 0x560, query id 9485605 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52214128, not started
MySQL thread id 1218, OS thread handle 0x12c0, query id 9614856 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185985, not started
MySQL thread id 1217, OS thread handle 0x17e4, query id 9485900 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52213876, not started
MySQL thread id 1207, OS thread handle 0xdb4, query id 9612087 iZxmk4ttcjds6jZ 60.205.171.98 root cleaning up
---TRANSACTION 52111180, not started
MySQL thread id 1205, OS thread handle 0x1484, query id 9149207 114.244.6.112 root cleaning up
---TRANSACTION 52211220, not started
MySQL thread id 1200, OS thread handle 0x1428, query id 9614858 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52214179, not started
MySQL thread id 1199, OS thread handle 0xbd4, query id 9615072 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52183839, not started
MySQL thread id 1196, OS thread handle 0x13e8, query id 9476480 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185881, not started
MySQL thread id 1195, OS thread handle 0x464, query id 9485398 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52182609, not started
MySQL thread id 1191, OS thread handle 0xcdc, query id 9485670 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52211548, not started
MySQL thread id 1189, OS thread handle 0xf74, query id 9599188 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52182697, not started
MySQL thread id 1188, OS thread handle 0x1584, query id 9485925 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52182724, not started
MySQL thread id 1187, OS thread handle 0xfb4, query id 9485921 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185941, not started
MySQL thread id 1186, OS thread handle 0x1724, query id 9485666 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185671, not started
MySQL thread id 1185, OS thread handle 0xf48, query id 9484477 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185727, not started
MySQL thread id 1183, OS thread handle 0x1798, query id 9484744 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52210731, not started
MySQL thread id 1180, OS thread handle 0xc58, query id 9595725 iZxmk4ttcjds6jZ 60.205.171.98 root cleaning up
---TRANSACTION 52149233, not started
MySQL thread id 1177, OS thread handle 0x39c, query id 9327341 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52210542, not started
MySQL thread id 1176, OS thread handle 0x79c, query id 9594949 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52130629, not started
MySQL thread id 1174, OS thread handle 0x15f0, query id 9235975 114.244.6.112 root cleaning up
---TRANSACTION 52182714, not started
MySQL thread id 1171, OS thread handle 0xefc, query id 9485919 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52211536, not started
MySQL thread id 1170, OS thread handle 0x1444, query id 9599135 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52177118, not started
MySQL thread id 1163, OS thread handle 0x1040, query id 9448186 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52214177, not started
MySQL thread id 1169, OS thread handle 0x1180, query id 9615073 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52184160, not started
MySQL thread id 1168, OS thread handle 0x14a4, query id 9477869 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185997, not started
MySQL thread id 1166, OS thread handle 0xf60, query id 9485915 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52211947, not started
MySQL thread id 1155, OS thread handle 0x688, query id 9602394 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52214759, not started
MySQL thread id 1148, OS thread handle 0x6ac, query id 9617482 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185781, not started
MySQL thread id 1147, OS thread handle 0x1434, query id 9484973 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185907, not started
MySQL thread id 1145, OS thread handle 0xb70, query id 9485526 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52214124, not started
MySQL thread id 1144, OS thread handle 0xa18, query id 9614840 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52214125, not started
MySQL thread id 1143, OS thread handle 0xc, query id 9614846 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52185682, not started
MySQL thread id 1141, OS thread handle 0xec4, query id 9484515 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52214758, not started
MySQL thread id 1138, OS thread handle 0x434, query id 9617486 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52213693, not started
MySQL thread id 1133, OS thread handle 0x61c, query id 9611317 114.244.6.112 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 1121, OS thread handle 0xd00, query id 8754968 114.244.6.112 root cleaning up
---TRANSACTION 52029470, not started
MySQL thread id 1122, OS thread handle 0xf30, query id 8756360 114.244.6.112 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 1119, OS thread handle 0x14d4, query id 8894860 114.244.6.112 root cleaning up
---TRANSACTION 52028996, not started
MySQL thread id 1120, OS thread handle 0x17d0, query id 8754418 114.244.6.112 root cleaning up
---TRANSACTION 52177122, not started
MySQL thread id 1114, OS thread handle 0xf80, query id 9448199 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52134304, not started
MySQL thread id 1041, OS thread handle 0x7cc, query id 9253446 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52214147, not started
MySQL thread id 1040, OS thread handle 0xaac, query id 9614963 localhost 127.0.0.1 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 952, OS thread handle 0xf9c, query id 8896988 114.244.6.112 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 1005, OS thread handle 0xd70, query id 9617488 114.244.6.112 root init
SHOW ENGINE INNODB STATUS
---TRANSACTION 51907455, not started
MySQL thread id 984, OS thread handle 0x14ac, query id 8192647 114.244.6.112 root cleaning up
---TRANSACTION 52076294, not started
MySQL thread id 982, OS thread handle 0xc48, query id 8975356 iZxmk4ttcjds6jZ 60.205.171.98 root cleaning up
---TRANSACTION 51905656, not started
MySQL thread id 973, OS thread handle 0xa08, query id 8185374 iZxmk4ttcjds6jZ 60.205.171.98 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 953, OS thread handle 0x16b8, query id 9143747 114.244.6.112 root cleaning up
---TRANSACTION 51886060, not started
MySQL thread id 959, OS thread handle 0x670, query id 8079148 114.244.6.112 root cleaning up
---TRANSACTION 51867225, not started
MySQL thread id 958, OS thread handle 0x1450, query id 8001902 114.244.6.112 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 954, OS thread handle 0x12b4, query id 7959889 114.244.6.112 root cleaning up
---TRANSACTION 52214444, not started
MySQL thread id 777, OS thread handle 0x354, query id 9616175 iZxmk4ttcjds6jZ 60.205.171.98 root cleaning up
---TRANSACTION 52214705, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1209, OS thread handle 0x17a8, query id 9617265 localhost 127.0.0.1 root updating
UPDATE person SET organ_id='d48e7d02-a07a-42b7-90c9-04403c85be9e',organ_name='站领导' WHERE id='51ab1865-b720-4060-b174-feaa68adc607'
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 1908 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52214705 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 35316162313836352d623732302d343036302d623137342d666561613638; asc 51ab1865-b720-4060-b174-feaa68; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2c0a; asc " , ;;
3: len 6; hex e8b5b5e998b3; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 1; hex 30; asc 0;;
7: SQL NULL;
8: SQL NULL;
9: len 4; hex 80000001; asc ;;
10: len 12; hex 313535303835333730323533; asc 155085370253;;
11: len 0; hex ; asc ;;
12: SQL NULL;
13: SQL NULL;
14: len 0; hex ; asc ;;
15: len 18; hex 353232343235313937393038323230303235; asc 522425197908220025;;
16: SQL NULL;
17: len 0; hex ; asc ;;
18: len 6; hex e69caae5a99a; asc ;;
19: len 6; hex e4b893e7a791; asc ;;
20: SQL NULL;
21: SQL NULL;
22: len 0; hex ; asc ;;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 39376461366339652d636330662d346261302d383231332d346338373735; asc 97da6c9e-cc0f-4ba0-8213-4c8775; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 80039e47; asc G;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf556; asc Z V;;
39: len 4; hex 80000001; asc ;;
------------------
---TRANSACTION 52214697, ACTIVE 1 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1167, OS thread handle 0x15d4, query id 9617229 localhost 127.0.0.1 root updating
UPDATE person SET organ_id='d48e7d02-a07a-42b7-90c9-04403c85be9e',organ_name='站领导' WHERE id='51ab1865-b720-4060-b174-feaa68adc607'
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 1908 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52214697 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 35316162313836352d623732302d343036302d623137342d666561613638; asc 51ab1865-b720-4060-b174-feaa68; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2c0a; asc " , ;;
3: len 6; hex e8b5b5e998b3; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 1; hex 30; asc 0;;
7: SQL NULL;
8: SQL NULL;
9: len 4; hex 80000001; asc ;;
10: len 12; hex 313535303835333730323533; asc 155085370253;;
11: len 0; hex ; asc ;;
12: SQL NULL;
13: SQL NULL;
14: len 0; hex ; asc ;;
15: len 18; hex 353232343235313937393038323230303235; asc 522425197908220025;;
16: SQL NULL;
17: len 0; hex ; asc ;;
18: len 6; hex e69caae5a99a; asc ;;
19: len 6; hex e4b893e7a791; asc ;;
20: SQL NULL;
21: SQL NULL;
22: len 0; hex ; asc ;;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 39376461366339652d636330662d346261302d383231332d346338373735; asc 97da6c9e-cc0f-4ba0-8213-4c8775; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 80039e47; asc G;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf556; asc Z V;;
39: len 4; hex 80000001; asc ;;
------------------
---TRANSACTION 52214688, ACTIVE 1 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1223, OS thread handle 0x175c, query id 9617189 localhost 127.0.0.1 root updating
UPDATE person SET organ_id='d48e7d02-a07a-42b7-90c9-04403c85be9e',organ_name='站领导' WHERE id='51ab1865-b720-4060-b174-feaa68adc607'
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 1908 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52214688 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 35316162313836352d623732302d343036302d623137342d666561613638; asc 51ab1865-b720-4060-b174-feaa68; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2c0a; asc " , ;;
3: len 6; hex e8b5b5e998b3; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 1; hex 30; asc 0;;
7: SQL NULL;
8: SQL NULL;
9: len 4; hex 80000001; asc ;;
10: len 12; hex 313535303835333730323533; asc 155085370253;;
11: len 0; hex ; asc ;;
12: SQL NULL;
13: SQL NULL;
14: len 0; hex ; asc ;;
15: len 18; hex 353232343235313937393038323230303235; asc 522425197908220025;;
16: SQL NULL;
17: len 0; hex ; asc ;;
18: len 6; hex e69caae5a99a; asc ;;
19: len 6; hex e4b893e7a791; asc ;;
20: SQL NULL;
21: SQL NULL;
22: len 0; hex ; asc ;;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 39376461366339652d636330662d346261302d383231332d346338373735; asc 97da6c9e-cc0f-4ba0-8213-4c8775; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 80039e47; asc G;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf556; asc Z V;;
39: len 4; hex 80000001; asc ;;
------------------
---TRANSACTION 52214681, ACTIVE 1 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1193, OS thread handle 0x104c, query id 9617157 localhost 127.0.0.1 root updating
UPDATE person SET organ_id='d48e7d02-a07a-42b7-90c9-04403c85be9e',organ_name='站领导' WHERE id='51ab1865-b720-4060-b174-feaa68adc607'
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 1908 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52214681 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 35316162313836352d623732302d343036302d623137342d666561613638; asc 51ab1865-b720-4060-b174-feaa68; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2c0a; asc " , ;;
3: len 6; hex e8b5b5e998b3; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 1; hex 30; asc 0;;
7: SQL NULL;
8: SQL NULL;
9: len 4; hex 80000001; asc ;;
10: len 12; hex 313535303835333730323533; asc 155085370253;;
11: len 0; hex ; asc ;;
12: SQL NULL;
13: SQL NULL;
14: len 0; hex ; asc ;;
15: len 18; hex 353232343235313937393038323230303235; asc 522425197908220025;;
16: SQL NULL;
17: len 0; hex ; asc ;;
18: len 6; hex e69caae5a99a; asc ;;
19: len 6; hex e4b893e7a791; asc ;;
20: SQL NULL;
21: SQL NULL;
22: len 0; hex ; asc ;;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 39376461366339652d636330662d346261302d383231332d346338373735; asc 97da6c9e-cc0f-4ba0-8213-4c8775; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 80039e47; asc G;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf556; asc Z V;;
39: len 4; hex 80000001; asc ;;
------------------
---TRANSACTION 52214665, ACTIVE 1 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1184, OS thread handle 0xf24, query id 9617085 localhost 127.0.0.1 root updating
UPDATE person SET organ_id='d48e7d02-a07a-42b7-90c9-04403c85be9e',organ_name='站领导' WHERE id='51ab1865-b720-4060-b174-feaa68adc607'
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 1908 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52214665 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 35316162313836352d623732302d343036302d623137342d666561613638; asc 51ab1865-b720-4060-b174-feaa68; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2c0a; asc " , ;;
3: len 6; hex e8b5b5e998b3; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 1; hex 30; asc 0;;
7: SQL NULL;
8: SQL NULL;
9: len 4; hex 80000001; asc ;;
10: len 12; hex 313535303835333730323533; asc 155085370253;;
11: len 0; hex ; asc ;;
12: SQL NULL;
13: SQL NULL;
14: len 0; hex ; asc ;;
15: len 18; hex 353232343235313937393038323230303235; asc 522425197908220025;;
16: SQL NULL;
17: len 0; hex ; asc ;;
18: len 6; hex e69caae5a99a; asc ;;
19: len 6; hex e4b893e7a791; asc ;;
20: SQL NULL;
21: SQL NULL;
22: len 0; hex ; asc ;;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 39376461366339652d636330662d346261302d383231332d346338373735; asc 97da6c9e-cc0f-4ba0-8213-4c8775; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 80039e47; asc G;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf556; asc Z V;;
39: len 4; hex 80000001; asc ;;
------------------
---TRANSACTION 52214521, ACTIVE 4 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1190, OS thread handle 0x1718, query id 9616490 localhost 127.0.0.1 root updating
UPDATE person SET organ_id='d48e7d02-a07a-42b7-90c9-04403c85be9e',organ_name='站领导' WHERE id='51ab1865-b720-4060-b174-feaa68adc607'
------- TRX HAS BEEN WAITING 4 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 1908 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52214521 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 35316162313836352d623732302d343036302d623137342d666561613638; asc 51ab1865-b720-4060-b174-feaa68; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2c0a; asc " , ;;
3: len 6; hex e8b5b5e998b3; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 1; hex 30; asc 0;;
7: SQL NULL;
8: SQL NULL;
9: len 4; hex 80000001; asc ;;
10: len 12; hex 313535303835333730323533; asc 155085370253;;
11: len 0; hex ; asc ;;
12: SQL NULL;
13: SQL NULL;
14: len 0; hex ; asc ;;
15: len 18; hex 353232343235313937393038323230303235; asc 522425197908220025;;
16: SQL NULL;
17: len 0; hex ; asc ;;
18: len 6; hex e69caae5a99a; asc ;;
19: len 6; hex e4b893e7a791; asc ;;
20: SQL NULL;
21: SQL NULL;
22: len 0; hex ; asc ;;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 39376461366339652d636330662d346261302d383231332d346338373735; asc 97da6c9e-cc0f-4ba0-8213-4c8775; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 80039e47; asc G;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf556; asc Z V;;
39: len 4; hex 80000001; asc ;;
------------------
---TRANSACTION 52214495, ACTIVE 5 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1215, OS thread handle 0xcfc, query id 9616379 localhost 127.0.0.1 root updating
UPDATE standard SET status=0,report_time=null WHERE id='d406d0e4-32d3-448f-a4cf-4be45cdfc0fc'
------- TRX HAS BEEN WAITING 5 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 356 page no 573 n bits 80 index `PRIMARY` of table `safety`.`standard` trx id 52214495 lock_mode X locks rec but not gap waiting
Record lock, heap no 10 PHYSICAL RECORD: n_fields 24; compact format; info bits 0
0: len 30; hex 64343036643065342d333264332d343438662d613463662d346265343563; asc d406d0e4-32d3-448f-a4cf-4be45c; (total 36 bytes);
1: len 6; hex 00000319787d; asc x};;
2: len 7; hex 02000007f208a2; asc ;;
3: len 30; hex 32373637663562362d343638382d343532302d396231622d343462343163; asc 2767f5b6-4688-4520-9b1b-44b41c; (total 36 bytes);
4: len 6; hex e4b880e78fad; asc ;;
5: len 30; hex 32386235633334322d653461642d346162302d393037662d363536313163; asc 28b5c342-e4ad-4ab0-907f-65611c; (total 36 bytes);
6: len 12; hex e4b880e78fade6b885e58d95; asc ;;
7: len 5; hex 999e1f071e; asc ;;
8: len 13; hex 5b22e58f91e794b5e69cba225d; asc [" "];;
9: len 4; hex 5b22225d; asc [""];;
10: SQL NULL;
11: len 24; hex 5b2228e4bc81e4b89ae69cace7baa7e5889be5bbba29225d; asc ["( )"];;
12: len 4; hex 5b22225d; asc [""];;
13: len 9; hex e8b0a2e8bf90e585b5; asc ;;
14: len 30; hex 5b2264303861323436352d656538332d346233302d623637312d37656363; asc ["d08a2465-ee83-4b30-b671-7ecc; (total 40 bytes);
15: len 1; hex 30; asc 0;;
16: len 4; hex 80000003; asc ;;
17: len 4; hex 8001ac82; asc ;;
18: len 5; hex 999e1f0732; asc 2;;
19: len 4; hex 5a0bfac2; asc Z ;;
20: len 5; hex 5b2237225d; asc ["7"];;
21: len 5; hex 5b2231225d; asc ["1"];;
22: len 4; hex 80000000; asc ;;
23: len 4; hex 80000000; asc ;;
------------------
---TRANSACTION 52213954, ACTIVE 14 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1139, OS thread handle 0x1080, query id 9612456 localhost 127.0.0.1 root updating
UPDATE standard SET status=0,report_time=null WHERE id='d406d0e4-32d3-448f-a4cf-4be45cdfc0fc'
------- TRX HAS BEEN WAITING 14 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 356 page no 573 n bits 80 index `PRIMARY` of table `safety`.`standard` trx id 52213954 lock_mode X locks rec but not gap waiting
Record lock, heap no 10 PHYSICAL RECORD: n_fields 24; compact format; info bits 0
0: len 30; hex 64343036643065342d333264332d343438662d613463662d346265343563; asc d406d0e4-32d3-448f-a4cf-4be45c; (total 36 bytes);
1: len 6; hex 00000319787d; asc x};;
2: len 7; hex 02000007f208a2; asc ;;
3: len 30; hex 32373637663562362d343638382d343532302d396231622d343462343163; asc 2767f5b6-4688-4520-9b1b-44b41c; (total 36 bytes);
4: len 6; hex e4b880e78fad; asc ;;
5: len 30; hex 32386235633334322d653461642d346162302d393037662d363536313163; asc 28b5c342-e4ad-4ab0-907f-65611c; (total 36 bytes);
6: len 12; hex e4b880e78fade6b885e58d95; asc ;;
7: len 5; hex 999e1f071e; asc ;;
8: len 13; hex 5b22e58f91e794b5e69cba225d; asc [" "];;
9: len 4; hex 5b22225d; asc [""];;
10: SQL NULL;
11: len 24; hex 5b2228e4bc81e4b89ae69cace7baa7e5889be5bbba29225d; asc ["( )"];;
12: len 4; hex 5b22225d; asc [""];;
13: len 9; hex e8b0a2e8bf90e585b5; asc ;;
14: len 30; hex 5b2264303861323436352d656538332d346233302d623637312d37656363; asc ["d08a2465-ee83-4b30-b671-7ecc; (total 40 bytes);
15: len 1; hex 30; asc 0;;
16: len 4; hex 80000003; asc ;;
17: len 4; hex 8001ac82; asc ;;
18: len 5; hex 999e1f0732; asc 2;;
19: len 4; hex 5a0bfac2; asc Z ;;
20: len 5; hex 5b2237225d; asc ["7"];;
21: len 5; hex 5b2231225d; asc ["1"];;
22: len 4; hex 80000000; asc ;;
23: len 4; hex 80000000; asc ;;
------------------
---TRANSACTION 52213412, ACTIVE 24 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1224, OS thread handle 0xf8c, query id 9610171 localhost 127.0.0.1 root updating
UPDATE standard SET status=1,is_change=0 WHERE id='c885e97f-59e2-4bd5-b796-af31b4c29993'
------- TRX HAS BEEN WAITING 24 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 356 page no 2008 n bits 80 index `PRIMARY` of table `safety`.`standard` trx id 52213412 lock_mode X locks rec but not gap waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 24; compact format; info bits 0
0: len 30; hex 63383835653937662d353965322d346264352d623739362d616633316234; asc c885e97f-59e2-4bd5-b796-af31b4; (total 36 bytes);
1: len 6; hex 0000031a9119; asc ;;
2: len 7; hex 22000001970f9f; asc " ;;
3: len 0; hex ; asc ;;
4: len 0; hex ; asc ;;
5: len 30; hex 363639336264333138373434346332373937333035313933383831373737; asc 6693bd3187444c2797305193881777; (total 32 bytes);
6: len 30; hex e59bbde794b5e8b4b5e5b79ee785a4e4b89ae68a95e8b584e69c89e99990; asc ; (total 72 bytes);
7: len 5; hex 999e1f01ca; asc ;;
8: len 22; hex 5b22e7b289e5b098e6b593e5baa6e8b685e6a087225d; asc [" "];;
9: len 4; hex 5b22225d; asc [""];;
10: SQL NULL;
11: len 24; hex 5b2228e4bc81e4b89ae69cace7baa7e5889be5bbba29225d; asc ["( )"];;
12: len 4; hex 5b22225d; asc [""];;
13: len 4; hex 736c6d6b; asc slmk;;
14: len 30; hex 5b2230643335623162362d663433322d343434622d626437632d35303431; asc ["0d35b1b6-f432-444b-bd7c-5041; (total 40 bytes);
15: len 1; hex 30; asc 0;;
16: len 4; hex 80000001; asc ;;
17: len 4; hex 8001ac5a; asc Z;;
18: len 5; hex 999e1f01e1; asc ;;
19: len 4; hex 5a0bf658; asc Z X;;
20: len 5; hex 5b2231225d; asc ["1"];;
21: len 5; hex 5b2233225d; asc ["3"];;
22: len 4; hex 80000000; asc ;;
23: len 4; hex 80000000; asc ;;
------------------
---TRANSACTION 52213292, ACTIVE 25 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1172, OS thread handle 0x2f8, query id 9609666 localhost 127.0.0.1 root updating
UPDATE person SET user_id='f06fcad8-209f-4781-9a4a-1e06dadab1ea' WHERE id='721422cf-40d3-45cf-be8f-19af3085d65e'
------- TRX HAS BEEN WAITING 25 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 682 n bits 128 index `PRIMARY` of table `safety`.`person` trx id 52213292 lock_mode X locks rec but not gap waiting
Record lock, heap no 40 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 37323134323263662d343064332d343563662d626538662d313961663330; asc 721422cf-40d3-45cf-be8f-19af30; (total 36 bytes);
1: len 6; hex 0000031a9119; asc ;;
2: len 7; hex 220000019711c2; asc " ;;
3: len 9; hex e5bb96e88c82e79b9b; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 30; hex 61313539633133382d633637642d343931642d623930352d623034373039; asc a159c138-c67d-491d-b905-b04709; (total 36 bytes);
7: len 12; hex e7949fe4baa7e8bda6e997b4; asc ;;
8: SQL NULL;
9: len 4; hex 80000000; asc ;;
10: len 11; hex 3135313137353038373935; asc 15117508795;;
11: len 30; hex e4b8a5e6a0bce981b5e6938de4bd9ce8a784e7a88be58f8ae59084e9a1b9; asc ; (total 372 bytes);
12: SQL NULL;
13: SQL NULL;
14: len 30; hex e8b4b5e5b79ee79c81e7bb87e98791e58ebfe88cb6e5ba97e4b9a1e5ae89; asc ; (total 45 bytes);
15: SQL NULL;
16: len 5; hex 992eee0000; asc . ;;
17: len 12; hex e8b4b5e5b79ee7bb87e98791; asc ;;
18: len 6; hex e5b7b2e5a99a; asc ;;
19: len 6; hex e5889de4b8ad; asc ;;
20: SQL NULL;
21: len 5; hex 999b820000; asc ;;
22: len 18; hex e6b094e793b6e58585e8a385e7bb84e995bf; asc ;;
23: SQL NULL;
24: len 0; hex ; asc ;;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 61643266356637662d613338392d343439342d386338322d613736383162; asc ad2f5f7f-a389-4494-8c82-a7681b; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 8002bb2b; asc +;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000001; asc ;;
36: len 4; hex 80000000; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf6f8; asc Z ;;
39: len 4; hex 80000000; asc ;;
------------------
---TRANSACTION 52213208, ACTIVE 27 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1211, OS thread handle 0x12f4, query id 9609321 localhost 127.0.0.1 root updating
UPDATE person SET organ_id='2e81e9cd-640d-4adb-9a10-3c6404e2cb64',organ_name='矿委会' WHERE id IN ('8b431fa1-6d8a-4cd9-b841-e0054e38edf9','2efa79ef-820e-4440-85f9-51a67b5c6917','311a9ba8-98fb-41d0-ad33-d3d9d925767c','3f5d764b-850d-404a-8c05-4e5269093e92')
------- TRX HAS BEEN WAITING 27 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 2132 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52213208 lock_mode X locks rec but not gap waiting
Record lock, heap no 38 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 32656661373965662d383230652d343434302d383566392d353161363762; asc 2efa79ef-820e-4440-85f9-51a67b; (total 36 bytes);
1: len 6; hex 0000020d8907; asc ;;
2: len 7; hex e5000003bf0110; asc ;;
3: len 6; hex e58898e696b0; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 30; hex 32653831653963642d363430642d346164622d396131302d336336343034; asc 2e81e9cd-640d-4adb-9a10-3c6404; (total 36 bytes);
7: len 9; hex e79fbfe5a794e4bc9a; asc ;;
8: SQL NULL;
9: len 4; hex 80000000; asc ;;
10: len 11; hex 3133383835303838353935; asc 13885088595;;
11: len 30; hex e8b49fe8b4a3e785a4e79fbfe69cbae794b5e79bb8e585b3e7aea1e79086; asc ; (total 36 bytes);
12: SQL NULL;
13: SQL NULL;
14: len 30; hex e6b19fe8a5bfe79c81e59089e5ae89e5b882e5ae89e7a68fe58ebfe5b9b3; asc ; (total 67 bytes);
15: len 18; hex 333632343239313936323038303830303737; asc 362429196208080077;;
16: len 5; hex 98ea900000; asc ;;
17: len 12; hex e6b19fe8a5bfe59089e5ae89; asc ;;
18: len 6; hex e5b7b2e5a99a; asc ;;
19: len 6; hex e69cace7a791; asc ;;
20: len 5; hex 992f260000; asc /& ;;
21: len 5; hex 999bcc0000; asc ;;
22: len 15; hex e69cbae794b5e589afe79fbfe995bf; asc ;;
23: SQL NULL;
24: len 0; hex ; asc ;;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 366239626262363964636336346332613934646231626562383866376461; asc 6b9bbb69dcc64c2a94db1beb88f7da; (total 32 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 80029a80; asc ;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 2; hex 3330; asc 30;;
38: len 4; hex 59c1b8b2; asc Y ;;
39: len 4; hex 80000000; asc ;;
------------------
---TRANSACTION 52212726, ACTIVE 38 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1216, OS thread handle 0xe6c, query id 9605587 localhost 127.0.0.1 root updating
UPDATE standard SET status=1,is_change=0 WHERE id='c885e97f-59e2-4bd5-b796-af31b4c29993'
------- TRX HAS BEEN WAITING 38 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 356 page no 2008 n bits 80 index `PRIMARY` of table `safety`.`standard` trx id 52212726 lock_mode X locks rec but not gap waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 24; compact format; info bits 0
0: len 30; hex 63383835653937662d353965322d346264352d623739362d616633316234; asc c885e97f-59e2-4bd5-b796-af31b4; (total 36 bytes);
1: len 6; hex 0000031a9119; asc ;;
2: len 7; hex 22000001970f9f; asc " ;;
3: len 0; hex ; asc ;;
4: len 0; hex ; asc ;;
5: len 30; hex 363639336264333138373434346332373937333035313933383831373737; asc 6693bd3187444c2797305193881777; (total 32 bytes);
6: len 30; hex e59bbde794b5e8b4b5e5b79ee785a4e4b89ae68a95e8b584e69c89e99990; asc ; (total 72 bytes);
7: len 5; hex 999e1f01ca; asc ;;
8: len 22; hex 5b22e7b289e5b098e6b593e5baa6e8b685e6a087225d; asc [" "];;
9: len 4; hex 5b22225d; asc [""];;
10: SQL NULL;
11: len 24; hex 5b2228e4bc81e4b89ae69cace7baa7e5889be5bbba29225d; asc ["( )"];;
12: len 4; hex 5b22225d; asc [""];;
13: len 4; hex 736c6d6b; asc slmk;;
14: len 30; hex 5b2230643335623162362d663433322d343434622d626437632d35303431; asc ["0d35b1b6-f432-444b-bd7c-5041; (total 40 bytes);
15: len 1; hex 30; asc 0;;
16: len 4; hex 80000001; asc ;;
17: len 4; hex 8001ac5a; asc Z;;
18: len 5; hex 999e1f01e1; asc ;;
19: len 4; hex 5a0bf658; asc Z X;;
20: len 5; hex 5b2231225d; asc ["1"];;
21: len 5; hex 5b2233225d; asc ["3"];;
22: len 4; hex 80000000; asc ;;
23: len 4; hex 80000000; asc ;;
------------------
---TRANSACTION 52212687, ACTIVE 38 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1197, OS thread handle 0x668, query id 9605421 localhost 127.0.0.1 root updating
UPDATE standard SET status=1,is_change=0 WHERE id='d406d0e4-32d3-448f-a4cf-4be45cdfc0fc'
------- TRX HAS BEEN WAITING 38 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 356 page no 573 n bits 80 index `PRIMARY` of table `safety`.`standard` trx id 52212687 lock_mode X locks rec but not gap waiting
Record lock, heap no 10 PHYSICAL RECORD: n_fields 24; compact format; info bits 0
0: len 30; hex 64343036643065342d333264332d343438662d613463662d346265343563; asc d406d0e4-32d3-448f-a4cf-4be45c; (total 36 bytes);
1: len 6; hex 00000319787d; asc x};;
2: len 7; hex 02000007f208a2; asc ;;
3: len 30; hex 32373637663562362d343638382d343532302d396231622d343462343163; asc 2767f5b6-4688-4520-9b1b-44b41c; (total 36 bytes);
4: len 6; hex e4b880e78fad; asc ;;
5: len 30; hex 32386235633334322d653461642d346162302d393037662d363536313163; asc 28b5c342-e4ad-4ab0-907f-65611c; (total 36 bytes);
6: len 12; hex e4b880e78fade6b885e58d95; asc ;;
7: len 5; hex 999e1f071e; asc ;;
8: len 13; hex 5b22e58f91e794b5e69cba225d; asc [" "];;
9: len 4; hex 5b22225d; asc [""];;
10: SQL NULL;
11: len 24; hex 5b2228e4bc81e4b89ae69cace7baa7e5889be5bbba29225d; asc ["( )"];;
12: len 4; hex 5b22225d; asc [""];;
13: len 9; hex e8b0a2e8bf90e585b5; asc ;;
14: len 30; hex 5b2264303861323436352d656538332d346233302d623637312d37656363; asc ["d08a2465-ee83-4b30-b671-7ecc; (total 40 bytes);
15: len 1; hex 30; asc 0;;
16: len 4; hex 80000003; asc ;;
17: len 4; hex 8001ac82; asc ;;
18: len 5; hex 999e1f0732; asc 2;;
19: len 4; hex 5a0bfac2; asc Z ;;
20: len 5; hex 5b2237225d; asc ["7"];;
21: len 5; hex 5b2231225d; asc ["1"];;
22: len 4; hex 80000000; asc ;;
23: len 4; hex 80000000; asc ;;
------------------
---TRANSACTION 52212431, ACTIVE 42 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1136, OS thread handle 0x1270, query id 9604379 localhost 127.0.0.1 root updating
UPDATE person SET organ_id='d48e7d02-a07a-42b7-90c9-04403c85be9e',organ_name='站领导' WHERE id='51ab1865-b720-4060-b174-feaa68adc607'
------- TRX HAS BEEN WAITING 42 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 1908 n bits 112 index `PRIMARY` of table `safety`.`person` trx id 52212431 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 35316162313836352d623732302d343036302d623137342d666561613638; asc 51ab1865-b720-4060-b174-feaa68; (total 36 bytes);
1: len 6; hex 00000319f59e; asc ;;
2: len 7; hex 22000007ec2c0a; asc " , ;;
3: len 6; hex e8b5b5e998b3; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 1; hex 30; asc 0;;
7: SQL NULL;
8: SQL NULL;
9: len 4; hex 80000001; asc ;;
10: len 12; hex 313535303835333730323533; asc 155085370253;;
11: len 0; hex ; asc ;;
12: SQL NULL;
13: SQL NULL;
14: len 0; hex ; asc ;;
15: len 18; hex 353232343235313937393038323230303235; asc 522425197908220025;;
16: SQL NULL;
17: len 0; hex ; asc ;;
18: len 6; hex e69caae5a99a; asc ;;
19: len 6; hex e4b893e7a791; asc ;;
20: SQL NULL;
21: SQL NULL;
22: len 0; hex ; asc ;;
23: SQL NULL;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 39376461366339652d636330662d346261302d383231332d346338373735; asc 97da6c9e-cc0f-4ba0-8213-4c8775; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 80039e47; asc G;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 4; hex 80000001; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf556; asc Z V;;
39: len 4; hex 80000001; asc ;;
------------------
---TRANSACTION 52211923, ACTIVE 50 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1194, OS thread handle 0x1138, query id 9600766 localhost 127.0.0.1 root updating
UPDATE person SET id='721422cf-40d3-45cf-be8f-19af3085d65e',name='廖茂盛',sex='0',phone='15117508795',role_id='af0f1cd2-720f-4968-b2e1-035085938508',card_no='',addr='贵州省织金县茶店乡安乐村龙进组',work_time='2017-01-01 00:00:00',one_work_time=null,birthday='1983-08-23',hometown='贵州织金',marital='已婚',culture='初中',is_special='1',is_manager='0',is_sp='0',safety_work_year='',trades='气瓶充装组长',duty='严格遵操作规程及各项规章制度，及时纠正或阻止充装员工的各种违规行为，对生产过全程监控，随时把握车间的各项工
------- TRX HAS BEEN WAITING 50 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 569 page no 682 n bits 128 index `PRIMARY` of table `safety`.`person` trx id 52211923 lock_mode X locks rec but not gap waiting
Record lock, heap no 40 PHYSICAL RECORD: n_fields 40; compact format; info bits 0
0: len 30; hex 37323134323263662d343064332d343563662d626538662d313961663330; asc 721422cf-40d3-45cf-be8f-19af30; (total 36 bytes);
1: len 6; hex 0000031a9119; asc ;;
2: len 7; hex 220000019711c2; asc " ;;
3: len 9; hex e5bb96e88c82e79b9b; asc ;;
4: SQL NULL;
5: SQL NULL;
6: len 30; hex 61313539633133382d633637642d343931642d623930352d623034373039; asc a159c138-c67d-491d-b905-b04709; (total 36 bytes);
7: len 12; hex e7949fe4baa7e8bda6e997b4; asc ;;
8: SQL NULL;
9: len 4; hex 80000000; asc ;;
10: len 11; hex 3135313137353038373935; asc 15117508795;;
11: len 30; hex e4b8a5e6a0bce981b5e6938de4bd9ce8a784e7a88be58f8ae59084e9a1b9; asc ; (total 372 bytes);
12: SQL NULL;
13: SQL NULL;
14: len 30; hex e8b4b5e5b79ee79c81e7bb87e98791e58ebfe88cb6e5ba97e4b9a1e5ae89; asc ; (total 45 bytes);
15: SQL NULL;
16: len 5; hex 992eee0000; asc . ;;
17: len 12; hex e8b4b5e5b79ee7bb87e98791; asc ;;
18: len 6; hex e5b7b2e5a99a; asc ;;
19: len 6; hex e5889de4b8ad; asc ;;
20: SQL NULL;
21: len 5; hex 999b820000; asc ;;
22: len 18; hex e6b094e793b6e58585e8a385e7bb84e995bf; asc ;;
23: SQL NULL;
24: len 0; hex ; asc ;;
25: SQL NULL;
26: SQL NULL;
27: len 30; hex 61643266356637662d613338392d343439342d386338322d613736383162; asc ad2f5f7f-a389-4494-8c82-a7681b; (total 36 bytes);
28: SQL NULL;
29: SQL NULL;
30: len 2; hex 6e78; asc nx;;
31: len 12; hex e7b3bbe7bb9fe7aea1e79086; asc ;;
32: SQL NULL;
33: len 4; hex 8002bb2b; asc +;;
34: len 4; hex 80000000; asc ;;
35: len 4; hex 80000001; asc ;;
36: len 4; hex 80000000; asc ;;
37: len 0; hex ; asc ;;
38: len 4; hex 5a0bf6f8; asc Z ;;
39: len 4; hex 80000000; asc ;;
------------------
---TRANSACTION 52072729, ACTIVE 3396 sec
44 lock struct(s), heap size 6544, 31 row lock(s), undo log entries 178
MySQL thread id 1074, OS thread handle 0xe00, query id 9612229 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52032926, ACTIVE 8305 sec
2929 lock struct(s), heap size 276008, 51 row lock(s), undo log entries 282
MySQL thread id 1079, OS thread handle 0x12c8, query id 9617142 localhost 127.0.0.1 root cleaning up
---TRANSACTION 52000893, ACTIVE 11507 sec
122 lock struct(s), heap size 13864, 99 row lock(s), undo log entries 442
MySQL thread id 997, OS thread handle 0xee8, query id 9616717 localhost 127.0.0.1 root cleaning up
--------
FILE I/O
--------
I/O thread 0 state: wait Windows aio (insert buffer thread)
I/O thread 1 state: wait Windows aio (log thread)
I/O thread 2 state: wait Windows aio (read thread)
I/O thread 3 state: wait Windows aio (read thread)
I/O thread 4 state: wait Windows aio (read thread)
I/O thread 5 state: wait Windows aio (read thread)
I/O thread 6 state: wait Windows aio (write thread)
I/O thread 7 state: wait Windows aio (write thread)
I/O thread 8 state: wait Windows aio (write thread)
I/O thread 9 state: wait Windows aio (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
177760 OS file reads, 655969 OS file writes, 452363 OS fsyncs
1.14 reads/s, 16384 avg bytes/read, 9.16 writes/s, 6.47 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 510, seg size 512, 25046 merges
merged operations:
insert 97500, delete mark 1, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 6375037, node heap has 946 buffer(s)
3835.40 hash searches/s, 1121.38 non-hash searches/s
---
LOG
---
Log sequence number 7865101132
Log flushed up to 7865101132
Pages flushed up to 7856093364
Last checkpoint at 7856093364
0 pending log writes, 0 pending chkp writes
193937 log i/o's done, 5.50 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 3298295808; in additional pool allocated 0
Dictionary memory allocated 1467866
Buffer pool size 196608
Free buffers 12051
Database pages 183595
Old database pages 67927
Modified db pages 10055
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1010, not young 0
0.03 youngs/s, 0.00 non-youngs/s
Pages read 177583, created 6012, written 352345
1.14 reads/s, 0.21 creates/s, 3.50 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 183595, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 24576
Free buffers 1619
Database pages 22833
Old database pages 8448
Modified db pages 1244
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 104, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22216, created 617, written 36948
0.21 reads/s, 0.00 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 22833, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 24576
Free buffers 1250
Database pages 23206
Old database pages 8586
Modified db pages 1213
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 99, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22521, created 685, written 44624
0.09 reads/s, 0.00 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 23206, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 24576
Free buffers 2008
Database pages 22445
Old database pages 8305
Modified db pages 1175
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 113, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21739, created 706, written 42591
0.09 reads/s, 0.00 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 22445, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 24576
Free buffers 1158
Database pages 23296
Old database pages 8619
Modified db pages 1307
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 155, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22381, created 915, written 33407
0.17 reads/s, 0.07 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 23296, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 24576
Free buffers 1741
Database pages 22720
Old database pages 8406
Modified db pages 1457
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 87, not young 0
0.02 youngs/s, 0.00 non-youngs/s
Pages read 21947, created 773, written 51299
0.12 reads/s, 0.00 creates/s, 0.48 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 22720, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 24576
Free buffers 1210
Database pages 23251
Old database pages 8602
Modified db pages 1132
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 133, not young 0
0.02 youngs/s, 0.00 non-youngs/s
Pages read 22490, created 761, written 47879
0.19 reads/s, 0.00 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 23251, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 24576
Free buffers 1877
Database pages 22578
Old database pages 8354
Modified db pages 1244
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 139, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21759, created 819, written 60577
0.14 reads/s, 0.03 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 22578, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 24576
Free buffers 1188
Database pages 23266
Old database pages 8607
Modified db pages 1283
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 180, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22530, created 736, written 35020
0.14 reads/s, 0.10 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 23266, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Main thread id 5528, state: sleeping
Number of rows inserted 186411, updated 12906, deleted 393, read 4827971550
5.07 inserts/s, 0.69 updates/s, 0.02 deletes/s, 58737.88 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
5 回复
For example:> "UPDATE person SET isdelete=1 WHERE id='d03b5b0b-9ccd-4a87-8f91-8140be0f7e47'"'
PreparedStatement:
'UPDATE person SET isdelete=? WHERE id=?'
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:95)
at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:250)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:64)
... 53 more
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:266)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:81)
... 55 more
添加回复
请先登陆