Skip to content

Instantly share code, notes, and snippets.

@olivernybroe

olivernybroe/gist:cbf9d2da0e04e4eaa902d5d01591e11e Secret

Created April 15, 2019 10:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save olivernybroe/cbf9d2da0e04e4eaa902d5d01591e11e to your computer and use it in GitHub Desktop.
Save olivernybroe/cbf9d2da0e04e4eaa902d5d01591e11e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
------------------------
LATEST DETECTED DEADLOCK
------------------------
2019-04-15 10:43:32 0x70000206c000
*** (1) TRANSACTION:
TRANSACTION 281479711920584, ACTIVE 0 sec fetching rows
mysql tables in use 3, locked 3
LOCK WAIT 80 lock struct(s), heap size 24784, 17790 row lock(s)
MySQL thread id 607, OS thread handle 123145336004608, query id 9693908 localhost 127.0.0.1 root Sending data
UPDATE yjob_userrank target
JOIN
(
SELECT userranks.id,
@`row_number` := CASE
WHEN @job_id = yjob_id THEN @`row_number` + 1
ELSE 1
END AS `row_number`,
@job_id := yjob_id
FROM (SELECT @job_id := NULL, @`row_number` := NULL) vars,
(
SELECT yjob_userrank.id,
user_id,
yjob_id,
rank_wo_date + users.`rank` as combined_rank,
is_match
FROM yjob_userrank
JOIN users ON users.id = yjob_userrank.user_id
WHERE yjob_id IN (29,30,31,39,40,67,69,70,77,78,8
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 105 page no 765 n bits 408 index PRIMARY of table `worksome`.`yjob_userrank` trx id 281479711920584 lock mode S waiting
Record lock, heap no 205 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014441; asc DA;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003891d4e; asc N;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000001d; asc ;;
5: len 3; hex 800401; asc ;;
6: len 3; hex 800401; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8014; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
*** (2) TRANSACTION:
TRANSACTION 253483, ACTIVE 0 sec starting index read
mysql tables in use 3, locked 3
251 lock struct(s), heap size 41168, 64911 row lock(s)
MySQL thread id 604, OS thread handle 123145336307712, query id 9693898 localhost 127.0.0.1 root Creating sort index
UPDATE yjob_userrank target
JOIN
(
SELECT userranks.id,
@`row_number` := CASE
WHEN @job_id = yjob_id THEN @`row_number` + 1
ELSE 1
END AS `row_number`,
@job_id := yjob_id
FROM (SELECT @job_id := NULL, @`row_number` := NULL) vars,
(
SELECT yjob_userrank.id,
user_id,
yjob_id,
rank_wo_date + users.`rank` as combined_rank,
is_match
FROM yjob_userrank
JOIN users ON users.id = yjob_userrank.user_id
WHERE yjob_id IN (29,30,31,39,40,67,69,70,
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 105 page no 765 n bits 408 index PRIMARY of table `worksome`.`yjob_userrank` trx id 253483 lock_mode X locks rec but not gap
Record lock, heap no 205 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014441; asc DA;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003891d4e; asc N;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000001d; asc ;;
5: len 3; hex 800401; asc ;;
6: len 3; hex 800401; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8014; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 206 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014442; asc DB;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003892e03; asc . ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000001e; asc ;;
5: len 3; hex 80032d; asc -;;
6: len 3; hex 80032d; asc -;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8021; asc !;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 207 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014443; asc DC;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003893ec5; asc > ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000001f; asc ;;
5: len 3; hex 800242; asc B;;
6: len 3; hex 800242; asc B;;
7: len 1; hex 00; asc ;;
8: len 2; hex 802b; asc +;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 208 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014444; asc DD;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000038b0b2d; asc -;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000027; asc ';;
5: len 3; hex 800344; asc D;;
6: len 3; hex 800344; asc D;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800a; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 209 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014445; asc DE;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000038b1d7b; asc {;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000028; asc (;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801a; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 210 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014446; asc DF;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000038b2cf3; asc , ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000043; asc C;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8013; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 211 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014447; asc DG;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b311c16; asc 1 ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000045; asc E;;
5: len 3; hex 800608; asc ;;
6: len 3; hex 800608; asc ;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8001; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 212 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014448; asc DH;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000038d0cb9; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000046; asc F;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800e; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 213 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014449; asc DI;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b311c8a; asc 1 ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000004d; asc M;;
5: len 3; hex 80061f; asc ;;
6: len 3; hex 80061f; asc ;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8001; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 214 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001444a; asc DJ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000038d2c90; asc , ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000004e; asc N;;
5: len 3; hex 800344; asc D;;
6: len 3; hex 800344; asc D;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800e; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 215 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001444b; asc DK;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000038d3b84; asc ; ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000053; asc S;;
5: len 3; hex 800603; asc ;;
6: len 3; hex 800603; asc ;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 216 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001444c; asc DL;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003940e87; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000056; asc V;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801d; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 217 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001444d; asc DM;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003941f49; asc I;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000057; asc W;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8027; asc ';;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 218 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001444e; asc DN;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003942ac2; asc * ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000060; asc `;;
5: len 3; hex 800651; asc Q;;
6: len 3; hex 800651; asc Q;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 219 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001444f; asc DO;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003943e5a; asc >Z;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000061; asc a;;
5: len 3; hex 800242; asc B;;
6: len 3; hex 800242; asc B;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801e; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 220 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014450; asc DP;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003950dc1; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000062; asc b;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801c; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 221 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014451; asc DQ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003951c94; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000074; asc t;;
5: len 3; hex 800310; asc ;;
6: len 3; hex 800310; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8014; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 222 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014452; asc DR;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003952a80; asc * ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000077; asc w;;
5: len 3; hex 80063e; asc >;;
6: len 3; hex 80063e; asc >;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 223 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014453; asc DS;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003953d10; asc = ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000079; asc y;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801c; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 224 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014454; asc DT;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003970d3d; asc =;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000089; asc ;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801d; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 225 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014455; asc DU;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003971ae7; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000008f; asc ;;
5: len 3; hex 800354; asc T;;
6: len 3; hex 800354; asc T;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8009; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 226 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014456; asc DV;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003972a3e; asc *>;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000009a; asc ;;
5: len 3; hex 800719; asc ;;
6: len 3; hex 800719; asc ;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 227 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014457; asc DW;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003980059; asc Y;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000009b; asc ;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 802e; asc .;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 228 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014458; asc DX;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b311ff0; asc 1 ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000009e; asc ;;
5: len 3; hex 800605; asc ;;
6: len 3; hex 800605; asc ;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 229 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014459; asc DY;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003981b4a; asc J;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000a2; asc ;;
5: len 3; hex 800637; asc 7;;
6: len 3; hex 800637; asc 7;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 230 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001445a; asc DZ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003982fa8; asc / ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000a3; asc ;;
5: len 3; hex 800340; asc @;;
6: len 3; hex 800340; asc @;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8026; asc &;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 231 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001445b; asc D[;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039b00fe; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000b2; asc ;;
5: len 3; hex 800344; asc D;;
6: len 3; hex 800344; asc D;;
7: len 1; hex 00; asc ;;
8: len 2; hex 802e; asc .;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 232 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001445c; asc D\;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039b1097; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000b3; asc ;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 802c; asc ,;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 233 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001445d; asc D];;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039b1c52; asc R;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000c1; asc ;;
5: len 3; hex 80034f; asc O;;
6: len 3; hex 80034f; asc O;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800a; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 234 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001445e; asc D^;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039b2cb1; asc , ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000ca; asc ;;
5: len 3; hex 800310; asc ;;
6: len 3; hex 800310; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800a; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 235 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001445f; asc D_;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039c00dd; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000dc; asc ;;
5: len 3; hex 800340; asc @;;
6: len 3; hex 800340; asc @;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8027; asc ';;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 236 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014460; asc D`;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039c0d3d; asc =;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000e4; asc ;;
5: len 3; hex 800354; asc T;;
6: len 3; hex 800354; asc T;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8009; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 237 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014461; asc Da;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039c1dde; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000000ec; asc ;;
5: len 3; hex 800305; asc ;;
6: len 3; hex 800305; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800e; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 238 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014462; asc Db;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039c2d77; asc -w;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000013a; asc :;;
5: len 3; hex 80042c; asc ,;;
6: len 3; hex 80042c; asc ,;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800c; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 239 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014463; asc Dc;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039c3e18; asc > ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000146; asc F;;
5: len 3; hex 80033d; asc =;;
6: len 3; hex 80033d; asc =;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8016; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 240 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014464; asc Dd;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b3122a8; asc 1" ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000149; asc I;;
5: len 3; hex 80075d; asc ];;
6: len 3; hex 80075d; asc ];;
7: len 1; hex 01; asc ;;
8: len 2; hex 8001; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 241 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014465; asc De;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039d1dbd; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000015c; asc \;;
5: len 3; hex 800316; asc ;;
6: len 3; hex 800316; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801c; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 242 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014466; asc Df;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000039d2b04; asc + ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000163; asc c;;
5: len 3; hex 80034d; asc M;;
6: len 3; hex 80034d; asc M;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800c; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 243 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014467; asc Dg;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b312356; asc 1#V;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000183; asc ;;
5: len 3; hex 800726; asc &;;
6: len 3; hex 800726; asc &;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8001; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 244 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014468; asc Dh;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a00e87; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000018a; asc ;;
5: len 3; hex 80023f; asc ?;;
6: len 3; hex 80023f; asc ?;;
7: len 1; hex 00; asc ;;
8: len 2; hex 803f; asc ?;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 245 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014469; asc Di;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a019df; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000196; asc ;;
5: len 3; hex 800253; asc S;;
6: len 3; hex 800253; asc S;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8023; asc #;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 246 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001446a; asc Dj;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a0342b; asc 4+;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000199; asc ;;
5: len 3; hex 800131; asc 1;;
6: len 3; hex 800131; asc 1;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8077; asc w;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 247 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001446b; asc Dk;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b31243e; asc 1$>;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001a5; asc ;;
5: len 3; hex 800652; asc R;;
6: len 3; hex 800652; asc R;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 248 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001446c; asc Dl;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a10e45; asc E;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001b6; asc ;;
5: len 3; hex 800223; asc #;;
6: len 3; hex 800223; asc #;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8057; asc W;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 249 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001446d; asc Dm;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a1172a; asc *;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001c5; asc ;;
5: len 3; hex 80033d; asc =;;
6: len 3; hex 80033d; asc =;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801b; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 250 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001446e; asc Dn;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a129fc; asc ) ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001c9; asc ;;
5: len 3; hex 800243; asc C;;
6: len 3; hex 800243; asc C;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8032; asc 2;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 251 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001446f; asc Do;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a1369e; asc 6 ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001d1; asc ;;
5: len 3; hex 800243; asc C;;
6: len 3; hex 800243; asc C;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801d; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 252 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014470; asc Dp;;
1: len 6; hex 00000003da32; asc 2;;
2: len 7; hex 0200000adb2327; asc #';;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001db; asc ;;
5: len 3; hex 800428; asc (;;
6: len 3; hex 800428; asc (;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8012; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 253 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014471; asc Dq;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a613d0; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001dd; asc ;;
5: len 3; hex 800463; asc c;;
6: len 3; hex 800463; asc c;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8007; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 254 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014472; asc Dr;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b3125d4; asc 1% ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001e3; asc ;;
5: len 3; hex 800447; asc G;;
6: len 3; hex 800447; asc G;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8003; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 255 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014473; asc Ds;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a6346d; asc 4m;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001e8; asc ;;
5: len 3; hex 80034d; asc M;;
6: len 3; hex 80034d; asc M;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801c; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 256 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014474; asc Dt;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a801e5; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001f5; asc ;;
5: len 3; hex 80041f; asc ;;
6: len 3; hex 80041f; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8005; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 257 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014475; asc Du;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a8159e; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 000001fa; asc ;;
5: len 3; hex 80043c; asc <;;
6: len 3; hex 80043c; asc <;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8027; asc ';;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 258 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014476; asc Dv;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a82ba9; asc + ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000202; asc ;;
5: len 3; hex 800204; asc ;;
6: len 3; hex 800204; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 805d; asc ];;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 259 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014477; asc Dw;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b3126f6; asc 1& ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000204; asc ;;
5: len 3; hex 800717; asc ;;
6: len 3; hex 800717; asc ;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8001; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 260 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014478; asc Dx;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a83f20; asc ? ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000215; asc ;;
5: len 3; hex 800822; asc ";;
6: len 3; hex 800822; asc ";;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 261 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014479; asc Dy;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a910fa; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000217; asc ;;
5: len 3; hex 800316; asc ;;
6: len 3; hex 800316; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8016; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 262 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001447a; asc Dz;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a92327; asc #';;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000021f; asc ;;
5: len 3; hex 800316; asc ;;
6: len 3; hex 800316; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 802c; asc ,;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 263 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001447b; asc D{;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003a92f87; asc / ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000222; asc ";;
5: len 3; hex 80033d; asc =;;
6: len 3; hex 80033d; asc =;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8012; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 264 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001447c; asc D|;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003aa0059; asc Y;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000225; asc %;;
5: len 3; hex 80032e; asc .;;
6: len 3; hex 80032e; asc .;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8017; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 265 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001447d; asc D};;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003aa1811; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000236; asc 6;;
5: len 3; hex 800208; asc ;;
6: len 3; hex 800208; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8057; asc W;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 266 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001447e; asc D~;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003aa20d5; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000243; asc C;;
5: len 3; hex 800316; asc ;;
6: len 3; hex 800316; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801d; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 267 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 0001447f; asc D ;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b3128c6; asc 1( ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000247; asc G;;
5: len 3; hex 800321; asc !;;
6: len 3; hex 800321; asc !;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800e; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 268 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014480; asc D ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003af0b90; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000024f; asc O;;
5: len 3; hex 800046; asc F;;
6: len 3; hex 800046; asc F;;
7: len 1; hex 00; asc ;;
8: len 2; hex 807e; asc ~;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 269 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014481; asc D ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003af1223; asc #;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000250; asc P;;
5: len 3; hex 80022b; asc +;;
6: len 3; hex 80022b; asc +;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8035; asc 5;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 270 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014482; asc D ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003af2051; asc Q;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000255; asc U;;
5: len 3; hex 800253; asc S;;
6: len 3; hex 800253; asc S;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8028; asc (;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 271 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014483; asc D ;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b3129ae; asc 1) ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000257; asc W;;
5: len 3; hex 800316; asc ;;
6: len 3; hex 800316; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8021; asc !;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 272 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014484; asc D ;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b3129e8; asc 1) ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000261; asc a;;
5: len 3; hex 800401; asc ;;
6: len 3; hex 800401; asc ;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800d; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 273 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014485; asc D ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003b30cb9; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000263; asc c;;
5: len 3; hex 800335; asc 5;;
6: len 3; hex 800335; asc 5;;
7: len 1; hex 00; asc ;;
8: len 2; hex 800c; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 274 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014486; asc D ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003b31e20; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000269; asc i;;
5: len 3; hex 800243; asc C;;
6: len 3; hex 800243; asc C;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8016; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 275 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014487; asc D ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003b32ee2; asc . ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000026a; asc j;;
5: len 3; hex 800253; asc S;;
6: len 3; hex 800253; asc S;;
7: len 1; hex 00; asc ;;
8: len 2; hex 801d; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 276 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014488; asc D ;;
1: len 6; hex 00000003d53b; asc ;;;
2: len 7; hex 0200000b312ad0; asc 1* ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 0000026e; asc n;;
5: len 3; hex 800736; asc 6;;
6: len 3; hex 800736; asc 6;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8001; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
Record lock, heap no 277 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014489; asc D ;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 01000003b50c14; asc ;;
3: len 4; hex 0000012c; asc ,;;
4: len 4; hex 00000273; asc s;;
5: len 3; hex 800828; asc (;;
6: len 3; hex 800828; asc (;;
7: len 1; hex 01; asc ;;
8: len 2; hex 8002; asc ;;
9: len 4; hex 5caf0dc4; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 105 page no 765 n bits 408 index PRIMARY of table `worksome`.`yjob_userrank` trx id 253483 lock_mode X locks rec but not gap waiting
Record lock, heap no 204 PHYSICAL RECORD: n_fields 11; compact format; info bits 0
0: len 4; hex 00014440; asc D@;;
1: len 6; hex 00000003d54b; asc K;;
2: len 7; hex 010000024c32b0; asc L2 ;;
3: len 4; hex 00000129; asc );;
4: len 4; hex 00000630; asc 0;;
5: len 3; hex 800160; asc `;;
6: len 3; hex 800160; asc `;;
7: len 1; hex 00; asc ;;
8: len 2; hex 8076; asc v;;
9: len 4; hex 5caf0dc2; asc \ ;;
10: len 4; hex 5cb43d78; asc \ =x;;
*** WE ROLL BACK TRANSACTION (1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment