Loading...

XML

Word

Printable

Type: Problem report
Resolution: Fixed
Priority: Trivial
Fix Version/s: 3.4.15rc1, 4.0.0rc1, 4.0 (plan)
Affects Version/s: 3.4.13, 4.0.0beta1
Component/s: Server (S)
Labels:
- deadlock
- escalations

Sprint:
Sprint 42
Story Points:
0.5

As seen in query below, there is no sorting done by escalationid when updating recovered escalations from history syncer, this can lead to a deadlock and possible loss of data in history syncer. Sorting must be added.

 38444:20180903:151902.552 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update escalations set r_eventid=485422 where escalationid=1920;
update escalations set r_eventid=485414 where escalationid=1895;
update escalations set r_eventid=485423 where escalationid=1751;
update escalations set r_eventid=485420 where escalationid=1785;
update escalations set r_eventid=485415 where escalationid=1743;
]

------------------------
LATEST DETECTED DEADLOCK
------------------------
2018-09-03 12:19:02 0x7f9ad435c700
*** (1) TRANSACTION:
TRANSACTION 132888, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 14 lock struct(s), heap size 1136, 24 row lock(s), undo log entries 33
MySQL thread id 247, OS thread handle 140302962784000, query id 8681810 172.17.0.1 zabbix updating
update escalations set r_eventid=485420 where escalationid=1785
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 339 page no 17 n bits 256 index PRIMARY of table `zabbix`.`escalations` trx id 132888 lock_mode X locks rec but not gap waiting
Record lock, heap no 122 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006f9; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572900; asc "   W) ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c8e2; asc         ;;
 5: len 8; hex 000000000006a7f4; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

*** (2) TRANSACTION:
TRANSACTION 132871, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
14 lock struct(s), heap size 1136, 414 row lock(s), undo log entries 412
MySQL thread id 249, OS thread handle 140302961985280, query id 8681822 172.17.0.1 zabbix updating
update escalations set nextcheck=1535980741,esc_step=1 where escalationid=1920
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 339 page no 17 n bits 248 index PRIMARY of table `zabbix`.`escalations` trx id 132871 lock_mode X locks rec but not gap
Record lock, heap no 4 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000663; asc        c;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175723e7; asc "   W# ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c752; asc        R;;
 5: len 8; hex 000000000006a48e; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 7 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000669; asc        i;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572414; asc "   W$ ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022cc1; asc       , ;;
 5: len 8; hex 000000000006a523; asc        #;;
 6: len 8; hex 0000000000076726; asc       g&;;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 19 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000675; asc        u;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572441; asc "   W$A;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022d04; asc       - ;;
 5: len 8; hex 000000000006a59a; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 22 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000678; asc        x;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757246e; asc "   W$n;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c781; asc         ;;
 5: len 8; hex 000000000006a5aa; asc         ;;
 6: len 8; hex 00000000000767e8; asc       g ;;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 24 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000067a; asc        z;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757249b; asc "   W$ ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000003628b; asc       b ;;
 5: len 8; hex 000000000006a5bb; asc         ;;
 6: len 8; hex 000000000007672f; asc       g/;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 35 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000686; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175724c8; asc "   W$ ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022dbf; asc       - ;;
 5: len 8; hex 000000000006a4e5; asc         ;;
 6: len 8; hex 0000000000076786; asc       g ;;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 37 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000688; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175724f5; asc "   W$ ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000035f11; asc       _ ;;
 5: len 8; hex 000000000006a4f5; asc         ;;
 6: len 8; hex 0000000000076705; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 51 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000699; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572522; asc "   W%";;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022c3b; asc       ,;;;
 5: len 8; hex 000000000006a73d; asc        =;;
 6: len 8; hex 000000000007670f; asc       g ;;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 52 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000069a; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757254f; asc "   W%O;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022c3e; asc       ,>;;
 5: len 8; hex 000000000006a73f; asc        ?;;
 6: len 8; hex 0000000000076710; asc       g ;;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 53 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000069b; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757257c; asc "   W%|;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022c70; asc       ,p;;
 5: len 8; hex 000000000006a743; asc        C;;
 6: SQL NULL;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 56 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000069e; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175725d6; asc "   W% ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000003636d; asc       cm;;
 5: len 8; hex 000000000006a761; asc        a;;
 6: len 8; hex 0000000000076796; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 57 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000069f; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572603; asc "   W& ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000036370; asc       cp;;
 5: len 8; hex 000000000006a762; asc        b;;
 6: len 8; hex 0000000000076797; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 58 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006a0; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572630; asc "   W&0;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000003637f; asc       c ;;
 5: len 8; hex 000000000006a763; asc        c;;
 6: len 8; hex 0000000000076798; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 63 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006aa; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757265d; asc "   W&];;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000363af; asc       c ;;
 5: len 8; hex 000000000006a7a8; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 64 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006ab; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757268a; asc "   W& ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000363b7; asc       c ;;
 5: len 8; hex 000000000006a7a9; asc         ;;
 6: len 8; hex 00000000000767d3; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 70 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006b4; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175726b7; asc "   W& ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c698; asc         ;;
 5: len 8; hex 000000000006a717; asc         ;;
 6: len 8; hex 0000000000076701; asc       g ;;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 86 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006c8; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175726e4; asc "   W& ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022d6b; asc       -k;;
 5: len 8; hex 000000000006a68f; asc         ;;
 6: len 8; hex 00000000000767fb; asc       g ;;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 87 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006c9; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572711; asc "   W' ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022d6c; asc       -l;;
 5: len 8; hex 000000000006a690; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 95 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006d2; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757273e; asc "   W'>;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c912; asc         ;;
 5: len 8; hex 000000000006a874; asc        t;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 96 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006d3; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757276b; asc "   W'k;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c942; asc        B;;
 5: len 8; hex 000000000006a876; asc        v;;
 6: len 8; hex 00000000000767b5; asc       g ;;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 97 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006d4; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572798; asc "   W' ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c96f; asc        o;;
 5: len 8; hex 000000000006a879; asc        y;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 98 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006d5; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175727c5; asc "   W' ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000363fa; asc       c ;;
 5: len 8; hex 000000000006a883; asc         ;;
 6: len 8; hex 00000000000767ec; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 103 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006de; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175727f2; asc "   W' ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c7e3; asc         ;;
 5: len 8; hex 000000000006a625; asc        %;;
 6: len 8; hex 000000000007675c; asc       g\;;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 104 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006df; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757281f; asc "   W( ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c81a; asc         ;;
 5: len 8; hex 000000000006a629; asc        );;
 6: len 8; hex 00000000000767b4; asc       g ;;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 106 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006e1; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757284c; asc "   W(L;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000362d8; asc       b ;;
 5: len 8; hex 000000000006a638; asc        8;;
 6: len 8; hex 0000000000076754; asc       gT;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 107 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006e2; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572879; asc "   W(y;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000036300; asc       c ;;
 5: len 8; hex 000000000006a639; asc        9;;
 6: len 8; hex 00000000000767b6; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 108 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006e3; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175728a6; asc "   W( ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000003630a; asc       c ;;
 5: len 8; hex 000000000006a63a; asc        :;;
 6: len 8; hex 0000000000076760; asc       g`;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 110 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006e5; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175728d3; asc "   W( ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000003648a; asc       d ;;
 5: len 8; hex 000000000006a647; asc        G;;
 6: SQL NULL;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 122 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006f9; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572900; asc "   W) ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c8e2; asc         ;;
 5: len 8; hex 000000000006a7f4; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 123 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006fa; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757292d; asc "   W)-;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000361ff; asc       a ;;
 5: len 8; hex 000000000006a7f5; asc         ;;
 6: len 8; hex 00000000000767dd; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 124 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006fb; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 2200001757295a; asc "   W)Z;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000036227; asc       b';;
 5: len 8; hex 000000000006a7f8; asc         ;;
 6: len 8; hex 000000000007672d; asc       g-;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 125 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006fc; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572987; asc "   W) ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000363d7; asc       c ;;
 5: len 8; hex 000000000006a7fc; asc         ;;
 6: len 8; hex 00000000000767a0; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 126 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006fe; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175729b1; asc "   W) ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022bb4; asc       + ;;
 5: len 8; hex 000000000006a811; asc         ;;
 6: len 8; hex 00000000000766fc; asc       f ;;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 127 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 00000000000006ff; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 220000175729de; asc "   W) ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022dd0; asc       - ;;
 5: len 8; hex 000000000006a814; asc         ;;
 6: len 8; hex 0000000000076791; asc       g ;;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 128 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000700; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572a0b; asc "   W* ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c87c; asc        |;;
 5: len 8; hex 000000000006a817; asc         ;;
 6: len 8; hex 0000000000076793; asc       g ;;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 131 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000703; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572a38; asc "   W*8;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002cabf; asc         ;;
 5: len 8; hex 000000000006a827; asc        ';;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 133 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000705; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572a65; asc "   W*e;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000036597; asc       e ;;
 5: len 8; hex 000000000006a838; asc        8;;
 6: SQL NULL;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 138 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000070d; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572abf; asc "   W* ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000230d6; asc       0 ;;
 5: len 8; hex 000000000006a8f5; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 143 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000713; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572aec; asc "   W* ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022f3e; asc       />;;
 5: len 8; hex 000000000006a975; asc        u;;
 6: SQL NULL;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 158 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000727; asc        ';;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572b19; asc "   W+ ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000036522; asc       e";;
 5: len 8; hex 000000000006a945; asc        E;;
 6: SQL NULL;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 160 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000072d; asc        -;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572b46; asc "   W+F;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c975; asc        u;;
 5: len 8; hex 000000000006aaa3; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 161 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000072e; asc        .;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572b73; asc "   W+s;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002c9a8; asc         ;;
 5: len 8; hex 000000000006aaa6; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 163 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000730; asc        0;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572ba0; asc "   W+ ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000003644d; asc       dM;;
 5: len 8; hex 000000000006aab2; asc         ;;
 6: len 8; hex 00000000000767b7; asc       g ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 164 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000731; asc        1;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572bcd; asc "   W+ ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000036458; asc       dX;;
 5: len 8; hex 000000000006aab3; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 165 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000732; asc        2;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572bfa; asc "   W+ ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000036777; asc       gw;;
 5: len 8; hex 000000000006aabd; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 170 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000073a; asc        :;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572c27; asc "   W,';;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022eb9; asc       . ;;
 5: len 8; hex 000000000006aa08; asc         ;;
 6: len 8; hex 00000000000767e7; asc       g ;;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 172 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 000000000000073c; asc        <;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572c54; asc "   W,T;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002cc09; asc         ;;
 5: len 8; hex 000000000006aa0f; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 176 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000742; asc        B;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572c81; asc "   W, ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 0000000000022fd1; asc       / ;;
 5: len 8; hex 000000000006ab67; asc        g;;
 6: SQL NULL;
 7: len 4; hex db8d34c3; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 180 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000746; asc        F;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572cae; asc "   W, ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 000000000002caa2; asc         ;;
 5: len 8; hex 000000000006ab8f; asc         ;;
 6: SQL NULL;
 7: len 4; hex db8d34c4; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

Record lock, heap no 182 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000706; asc         ;;
 1: len 6; hex 000000020707; asc       ;;
 2: len 7; hex 22000017572a92; asc "   W* ;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000365a0; asc       e ;;
 5: len 8; hex 000000000006a83c; asc        <;;
 6: len 8; hex 000000000007680b; asc       h ;;
 7: len 4; hex db8d34c5; asc   4 ;;
 8: len 4; hex 80000001; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 339 page no 19 n bits 264 index PRIMARY of table `zabbix`.`escalations` trx id 132871 lock_mode X locks rec but not gap waiting
Record lock, heap no 197 PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 8; hex 0000000000000780; asc         ;;
 1: len 6; hex 000000020718; asc       ;;
 2: len 7; hex 2d000016ee1b32; asc -     2;;
 3: len 8; hex 0000000000000003; asc         ;;
 4: len 8; hex 00000000000365c8; asc       e ;;
 5: len 8; hex 000000000006ab01; asc         ;;
 6: len 8; hex 000000000007682e; asc       h.;;
 7: len 4; hex 80000000; asc     ;;
 8: len 4; hex 80000000; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: SQL NULL;
 11: SQL NULL;

*** WE ROLL BACK TRANSACTION (1)

caused by

ZBXNEXT-3195 Independent escalation of each problem for multiple problems generated by a trigger

Closed

Assignee:: Andris Zeila

Reporter:: Vladislavs Sokurenko

Team:: Team A

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Created:: 2018 Sep 10 16:59

Updated:: 2024 Apr 10 16:55

Resolved:: 2018 Sep 16 19:14

Details

Description

Attachments

Issue Links

Activity

People

Dates