INNODB STATUS

=====================================
2025-03-12 20:05:49 22774014244608 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 11 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 6383980 srv_active, 0 srv_shutdown, 12049837 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1294122
OS WAIT ARRAY INFO: signal count 1661642
RW-shared spins 0, rounds 0, OS waits 0
RW-excl spins 0, rounds 0, OS waits 0
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2025-03-09 21:37:00 22773466580736
*** (1) TRANSACTION:
TRANSACTION 108335355, ACTIVE 2 sec fetching rows
mysql tables in use 2, locked 2
LOCK WAIT 1256 lock struct(s), heap size 155768, 49363 row lock(s)
MySQL thread id 64577906, OS thread handle 22772888893184, query id 10030843263 172.31.45.113 admin executing
UPDATE tblConfirmedAllocateShifts c inner join tblJobRequests j on j.HospitalRef = c.HospitalRef
set c.JobId = j.Jobid
where c.JobID is null

*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 983 page no 445 n bits 120 index PRIMARY of table `richmond`.`tblJobRequests` trx id 108335355 lock mode S
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;

Record lock, heap no 2 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b0f; asc K[ ;;
1: len 6; hex 00000595ef7b; asc {;;
2: len 7; hex 0100000f270cc8; asc ' ;;
3: len 4; hex 80000682; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4bc0000; asc ;;
7: len 5; hex 99b4b0cc05; asc ;;
8: len 4; hex 80001ef2; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204d6f7365732041746f; asc Shift Confirmed with Moses Ato; (total 62 bytes);
11: len 9; hex 50726f4865616c7468; asc ProHealth;;
12: len 4; hex 526f7461; asc Rota;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 9964435000; asc dCP ;;
15: len 4; hex 00000000; asc ;;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a33f5; asc g 3 ;;
25: len 11; hex 7a70616c6d65725f706863; asc zpalmer_phc;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: SQL NULL;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 3 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b10; asc K[ ;;
1: len 6; hex 00000595ef9c; asc ;;
2: len 7; hex 020000049919fe; asc ;;
3: len 4; hex 80000682; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4c20000; asc ;;
7: len 5; hex 99b4b0cc17; asc ;;
8: len 4; hex 80001ef2; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204d6f7365732041746f; asc Shift Confirmed with Moses Ato; (total 62 bytes);
11: len 9; hex 50726f4865616c7468; asc ProHealth;;
12: len 4; hex 526f7461; asc Rota;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 9964435000; asc dCP ;;
15: len 4; hex 00000000; asc ;;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3407; asc g 4 ;;
25: len 11; hex 7a70616c6d65725f706863; asc zpalmer_phc;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: SQL NULL;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 4 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b13; asc K[ ;;
1: len 6; hex 00000595f119; asc ;;
2: len 7; hex 820000152b0110; asc + ;;
3: len 4; hex 8000000e; asc ;;
4: len 10; hex 416c6c6f636174696e67; asc Allocating;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4b20000; asc ;;
7: len 5; hex 99b4b0cd83; asc ;;
8: len 4; hex 80001424; asc $;;
9: len 4; hex 80000001; asc ;;
10: len 15; hex 416464656420766961206261746368; asc Added via batch;;
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 996442d780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000001; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a355b; asc g 5[;;
25: len 5; hex 4261746368; asc Batch;;
26: len 14; hex 484341202d20486f73706974616c; asc HCA - Hospital;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343036393838; asc 1024406988;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 5 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b14; asc K[ ;;
1: len 6; hex 00000595fa16; asc ;;
2: len 7; hex 82000012280110; asc ( ;;
3: len 4; hex 8000000e; asc ;;
4: len 10; hex 416c6c6f636174696e67; asc Allocating;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4b20000; asc ;;
7: len 5; hex 99b4b0d306; asc ;;
8: len 4; hex 80000a71; asc q;;
9: len 4; hex 80000001; asc ;;
10: len 15; hex 416464656420766961206261746368; asc Added via batch;;
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 996442d780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000001; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3996; asc g 9 ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343035313832; asc 1024405182;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 6 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b16; asc K[ ;;
1: len 6; hex 00000595fa18; asc ;;
2: len 7; hex 82000012f00110; asc ;;
3: len 4; hex 8000000e; asc ;;
4: len 10; hex 416c6c6f636174696e67; asc Allocating;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4b20000; asc ;;
7: len 5; hex 99b4b0d306; asc ;;
8: len 4; hex 80001424; asc $;;
9: len 4; hex 80000001; asc ;;
10: len 15; hex 416464656420766961206261746368; asc Added via batch;;
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442d000; asc dB ;;
14: len 5; hex 9964433780; asc dC7 ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000001; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3996; asc g 9 ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 14; hex 484341202d20486f73706974616c; asc HCA - Hospital;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234333938363432; asc 1024398642;;
33: SQL NULL;
34: len 4; hex 4c617465; asc Late;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 7 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b18; asc K[ ;;
1: len 6; hex 000005a2d8c1; asc ;;
2: len 7; hex 0100000c7821ef; asc x! ;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4ce0000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 4b617368612044617669657320636f6e6669726d656420436f6e74616374; asc Kasha Davies confirmed Contact; (total 347 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 67236014; asc g#` ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000001; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393330; asc 1024825930;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 8 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b19; asc K[ ;;
1: len 6; hex 000005a4a882; asc ;;
2: len 7; hex 02000013562cb6; asc V, ;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4cc0000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 4e6174616c696120426172616e20636f6e6669726d656420436f6e746163; asc Natalia Baran confirmed Contac; (total 409 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 6724aaf1; asc g$ ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393239; asc 1024825929;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 9 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b1a; asc K[ ;;
1: len 6; hex 000005a2e2f3; asc ;;
2: len 7; hex 02000016280bb6; asc ( ;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4ca0000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 4a6f7920436872697374696e6520466c61747420636f6e6669726d656420; asc Joy Christine Flatt confirmed ; (total 382 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 67236576; asc g#ev;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000001; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393238; asc 1024825928;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 10 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b1b; asc K[ ;;
1: len 6; hex 000005a17dd5; asc } ;;
2: len 7; hex 02000012e72388; asc # ;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4c80000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 4a6f7920436872697374696e6520466c61747420636f6e6669726d656420; asc Joy Christine Flatt confirmed ; (total 413 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 672254f7; asc g"T ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000001; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393236; asc 1024825926;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 11 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b1c; asc K[ ;;
1: len 6; hex 000005a2fac0; asc ;;
2: len 7; hex 01000016cf0d65; asc e;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4c40000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 4b617368612044617669657320636f6e6669726d656420436f6e74616374; asc Kasha Davies confirmed Contact; (total 353 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964428000; asc dB ;;
14: len 5; hex 996442c780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 672376af; asc g#v ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000001; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393235; asc 1024825925;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 12 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b1d; asc K[ ;;
1: len 6; hex 00000595ff7f; asc ;;
2: len 7; hex 0100000f370caf; asc 7 ;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4c20000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 47656e657669657665204d6f737320636f6e6669726d656420436f6e7461; asc Genevieve Moss confirmed Conta; (total 152 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3d3c; asc g =<;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393234; asc 1024825924;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 13 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b1e; asc K[ ;;
1: len 6; hex 00000595ff3a; asc :;;
2: len 7; hex 0100000f0219aa; asc ;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4be0000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 47656e657669657665204d6f737320636f6e6669726d656420436f6e7461; asc Genevieve Moss confirmed Conta; (total 152 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3d15; asc g = ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393233; asc 1024825923;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 14 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b1f; asc K[ ;;
1: len 6; hex 00000595ff10; asc ;;
2: len 7; hex 020000048c23a7; asc # ;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4bc0000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 47656e657669657665204d6f737320636f6e6669726d656420436f6e7461; asc Genevieve Moss confirmed Conta; (total 152 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3cef; asc g < ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393232; asc 1024825922;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 15 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b20; asc K[ ;;
1: len 6; hex 00000595fee4; asc ;;
2: len 7; hex 02000004932933; asc )3;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4ba0000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 47656e657669657665204d6f737320636f6e6669726d656420436f6e7461; asc Genevieve Moss confirmed Conta; (total 152 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3cca; asc g < ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393231; asc 1024825921;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 16 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b21; asc K[!;;
1: len 6; hex 000005960a5c; asc \;;
2: len 7; hex 02000004962c89; asc , ;;
3: len 4; hex 80000599; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4b80000; asc ;;
7: len 5; hex 99b4b0d30a; asc ;;
8: len 4; hex 80001b57; asc W;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 4a6f7920436872697374696e6520466c61747420636f6e6669726d656420; asc Joy Christine Flatt confirmed ; (total 222 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964429000; asc dB ;;
14: len 5; hex 996442e780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a41c2; asc g A ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383235393139; asc 1024825919;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 18 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b24; asc K[$;;
1: len 6; hex 00000595fcc0; asc ;;
2: len 7; hex 020000144e1699; asc N ;;
3: len 4; hex 8000000e; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4b20000; asc ;;
7: len 5; hex 99b4b0d383; asc ;;
8: len 4; hex 800010c9; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 48616e6e6168204d617269652043616c6f7720636f6e6669726d65642020; asc Hannah Marie Calow confirmed ; (total 201 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 996442d000; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3b58; asc g ;X;;
25: len 5; hex 4261746368; asc Batch;;
26: len 3; hex 495455; asc ITU;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 82; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343037303931; asc 1024407091;;
33: SQL NULL;
34: len 3; hex 4c2f44; asc L/D;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 19 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b25; asc K[%;;
1: len 6; hex 00000595fcc0; asc ;;
2: len 7; hex 020000144e17e2; asc N ;;
3: len 4; hex 8000000e; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4b20000; asc ;;
7: len 5; hex 99b4b0d383; asc ;;
8: len 4; hex 800010c9; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 48616e6e6168204d617269652043616c6f7720636f6e6669726d65642020; asc Hannah Marie Calow confirmed ; (total 201 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442d000; asc dB ;;
14: len 5; hex 9964433780; asc dC7 ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a3b58; asc g ;X;;
25: len 5; hex 4261746368; asc Batch;;
26: len 3; hex 495455; asc ITU;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 82; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343037303931; asc 1024407091;;
33: SQL NULL;
34: len 3; hex 4c2f44; asc L/D;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 20 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b28; asc K[(;;
1: len 6; hex 000005966daf; asc m ;;
2: len 7; hex 02000014672964; asc g)d;;
3: len 4; hex 80000035; asc 5;;
4: len 9; hex 43616e63656c6c6564; asc Cancelled;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4ce0000; asc ;;
7: len 5; hex 99b4b0da86; asc ;;
8: len 4; hex 80001d13; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 53686966742043616e63656c6c656420666f7220416e6472657720506869; asc Shift Cancelled for Andrew Phi; (total 268 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442d000; asc dB ;;
14: len 5; hex 9964433780; asc dC7 ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000001; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a76ee; asc g v ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 15; hex 41264520436f6d666f727461626c65; asc A&E Comfortable;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 30393234333739343432; asc 0924379442;;
33: SQL NULL;
34: len 4; hex 4c617465; asc Late;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 21 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b2a; asc K[*;;
1: len 6; hex 000005960b47; asc G;;
2: len 7; hex 01000016c02a14; asc * ;;
3: len 4; hex 800002fc; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4dc0000; asc ;;
7: len 5; hex 99b4b0db04; asc ;;
8: len 4; hex 80000e69; asc i;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 446f6e6e61204c6f756973652054686f6d617320636f6e6669726d656420; asc Donna Louise Thomas confirmed ; (total 165 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427780; asc dBw ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4256; asc g BV;;
25: len 5; hex 4261746368; asc Batch;;
26: len 19; hex 524d4e202d204d656e74616c204865616c7468; asc RMN - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343037313331; asc 1024407131;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 22 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b2b; asc K[+;;
1: len 6; hex 0000059671e2; asc q ;;
2: len 7; hex 0200001208291a; asc ) ;;
3: len 4; hex 800002fc; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4da0000; asc ;;
7: len 5; hex 99b4b0db04; asc ;;
8: len 4; hex 80000e69; asc i;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 446f6e6e61204c6f756973652054686f6d617320636f6e6669726d656420; asc Donna Louise Thomas confirmed ; (total 153 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427780; asc dBw ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a7d0e; asc g } ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 19; hex 524d4e202d204d656e74616c204865616c7468; asc RMN - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343037313330; asc 1024407130;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 23 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b2d; asc K[-;;
1: len 6; hex 00000596719d; asc q ;;
2: len 7; hex 020000120d2659; asc &Y;;
3: len 4; hex 800002fc; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4d60000; asc ;;
7: len 5; hex 99b4b0db04; asc ;;
8: len 4; hex 80000e69; asc i;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 446f6e6e61204c6f756973652054686f6d617320636f6e6669726d656420; asc Donna Louise Thomas confirmed ; (total 153 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427780; asc dBw ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a7cd5; asc g | ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 19; hex 524d4e202d204d656e74616c204865616c7468; asc RMN - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343037313238; asc 1024407128;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 24 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b32; asc K[2;;
1: len 6; hex 00000596145a; asc Z;;
2: len 7; hex 02000004b9172c; asc ,;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4b80000; asc ;;
7: len 5; hex 99b4b0e10a; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204c6973612d4d617269; asc Shift Confirmed with Lisa-Mari; (total 70 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 9964433000; asc dC0 ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a45ca; asc g E ;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 25 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b33; asc K[3;;
1: len 6; hex 000005961462; asc b;;
2: len 7; hex 02000004bf1469; asc i;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4cc0000; asc ;;
7: len 5; hex 99b4b0e10a; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204c6973612d4d617269; asc Shift Confirmed with Lisa-Mari; (total 70 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 9964433000; asc dC0 ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a45ca; asc g E ;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 26 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b34; asc K[4;;
1: len 6; hex 00000596146a; asc j;;
2: len 7; hex 020000145f1cfc; asc _ ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4d00000; asc ;;
7: len 5; hex 99b4b0e10b; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204c6973612d4d617269; asc Shift Confirmed with Lisa-Mari; (total 70 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 9964433000; asc dC0 ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a45cb; asc g E ;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 28 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b38; asc K[8;;
1: len 6; hex 000005961655; asc U;;
2: len 7; hex 01000016f91fcb; asc ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4c60000; asc ;;
7: len 5; hex 99b4b0e295; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204c6973612d4d617269; asc Shift Confirmed with Lisa-Mari; (total 70 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a473d; asc g G=;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 29 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b39; asc K[9;;
1: len 6; hex 00000596165d; asc ];;
2: len 7; hex 0100000f121463; asc c;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4c80000; asc ;;
7: len 5; hex 99b4b0e296; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204c6973612d4d617269; asc Shift Confirmed with Lisa-Mari; (total 70 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a473e; asc g G>;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 30 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b3a; asc K[:;;
1: len 6; hex 000005961717; asc ;;
2: len 7; hex 81000017c10110; asc ;;
3: len 4; hex 80000035; asc 5;;
4: len 10; hex 416c6c6f636174696e67; asc Allocating;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4b00000; asc ;;
7: len 5; hex 99b4b0e306; asc ;;
8: len 4; hex 8000011b; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 15; hex 416464656420766961206261746368; asc Added via batch;;
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442d000; asc dB ;;
14: len 5; hex 9964433780; asc dC7 ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000001; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a47a6; asc g G ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234333931333736; asc 1024391376;;
33: SQL NULL;
34: len 4; hex 4c617465; asc Late;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 31 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b3d; asc K[=;;
1: len 6; hex 00000596171a; asc ;;
2: len 7; hex 82000016350110; asc 5 ;;
3: len 4; hex 8000000e; asc ;;
4: len 10; hex 416c6c6f636174696e67; asc Allocating;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4b00000; asc ;;
7: len 5; hex 99b4b0e306; asc ;;
8: len 4; hex 800013a6; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 15; hex 416464656420766961206261746368; asc Added via batch;;
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442e000; asc dB ;;
14: len 5; hex 9964433780; asc dC7 ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000001; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a47a6; asc g G ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 14; hex 484341202d20486f73706974616c; asc HCA - Hospital;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234333933303834; asc 1024393084;;
33: SQL NULL;
34: len 4; hex 4c617465; asc Late;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 32 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b3e; asc K[>;;
1: len 6; hex 00000596236b; asc #k;;
2: len 7; hex 0200001229019f; asc ) ;;
3: len 4; hex 80000490; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4b80000; asc ;;
7: len 5; hex 99b4b0e384; asc ;;
8: len 4; hex 80001edf; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 4c696e6461202044617669657320636f6e6669726d656420436f6e746163; asc Linda Davies confirmed Contac; (total 371 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442d000; asc dB ;;
14: len 5; hex 9964433780; asc dC7 ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4daf; asc g M ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343037313433; asc 1024407143;;
33: SQL NULL;
34: len 4; hex 4c617465; asc Late;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 33 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b40; asc K[@;;
1: len 6; hex 0000059618d4; asc ;;
2: len 7; hex 020000144c21cb; asc L! ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4ba0000; asc ;;
7: len 5; hex 99b4b0e44d; asc M;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204f6c757761746f6269; asc Shift Confirmed with Oluwatobi; (total 64 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 9964433000; asc dC0 ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a48d9; asc g H ;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 34 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b41; asc K[A;;
1: len 6; hex 0000059618dc; asc ;;
2: len 7; hex 0200000489282d; asc (-;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4c60000; asc ;;
7: len 5; hex 99b4b0e44e; asc N;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204f6c757761746f6269; asc Shift Confirmed with Oluwatobi; (total 64 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 9964433000; asc dC0 ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a48da; asc g H ;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 35 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b42; asc K[B;;
1: len 6; hex 0000059618e4; asc ;;
2: len 7; hex 020000146b1a3f; asc k ?;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4ca0000; asc ;;
7: len 5; hex 99b4b0e44e; asc N;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204f6c757761746f6269; asc Shift Confirmed with Oluwatobi; (total 64 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 9964433000; asc dC0 ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a48da; asc g H ;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 36 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b43; asc K[C;;
1: len 6; hex 0000059618eb; asc ;;
2: len 7; hex 02000012130387; asc ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 0; hex ; asc ;;
6: len 5; hex 99b4d40000; asc ;;
7: len 5; hex 99b4b0e44f; asc O;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204f6c757761746f6269; asc Shift Confirmed with Oluwatobi; (total 64 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 9964433000; asc dC0 ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a48db; asc g H ;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 3; hex 446179; asc Day;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 37 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b44; asc K[D;;
1: len 6; hex 000005961925; asc %;;
2: len 7; hex 020000145d1b4b; asc ] K;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4c20000; asc ;;
7: len 5; hex 99b4b0e4a9; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204e676f6e69647a6173; asc Shift Confirmed with Ngonidzas; (total 71 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4931; asc g I1;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 38 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b45; asc K[E;;
1: len 6; hex 00000596192d; asc -;;
2: len 7; hex 02000012180151; asc Q;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4c40000; asc ;;
7: len 5; hex 99b4b0e4aa; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204e676f6e69647a6173; asc Shift Confirmed with Ngonidzas; (total 71 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4932; asc g I2;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 39 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b46; asc K[F;;
1: len 6; hex 000005961935; asc 5;;
2: len 7; hex 02000004a019f8; asc ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4d00000; asc ;;
7: len 5; hex 99b4b0e4aa; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204e676f6e69647a6173; asc Shift Confirmed with Ngonidzas; (total 71 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4932; asc g I2;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 40 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b47; asc K[G;;
1: len 6; hex 00000596193d; asc =;;
2: len 7; hex 020000145a13bb; asc Z ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4d20000; asc ;;
7: len 5; hex 99b4b0e4ab; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204e676f6e69647a6173; asc Shift Confirmed with Ngonidzas; (total 71 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4933; asc g I3;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 41 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b48; asc K[H;;
1: len 6; hex 0000059619bb; asc ;;
2: len 7; hex 0100000f2e12f1; asc . ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4d40000; asc ;;
7: len 5; hex 99b4b0e51c; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204c6973612d4d617269; asc Shift Confirmed with Lisa-Mari; (total 70 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: len 4; hex 00000000; asc ;;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a499c; asc g I ;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 43 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b4a; asc K[J;;
1: len 6; hex 000005961a53; asc S;;
2: len 7; hex 02000004b824ad; asc $ ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4ca0000; asc ;;
7: len 5; hex 99b4b0e5c6; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204f6c61626f64652041; asc Shift Confirmed with Olabode A; (total 66 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4a3a; asc g J:;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 44 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b4b; asc K[K;;
1: len 6; hex 000005961a5b; asc [;;
2: len 7; hex 020000147f04b7; asc ;;
3: len 4; hex 80000586; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4cc0000; asc ;;
7: len 5; hex 99b4b0e5c6; asc ;;
8: len 4; hex 80001b18; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 536869667420436f6e6669726d65642077697468204f6c61626f64652041; asc Shift Confirmed with Olabode A; (total 66 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 14; hex 4f4f482f4f6e43616c6c2f4e4943; asc OOH/OnCall/NIC;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427000; asc dBp ;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4a3a; asc g J:;;
25: len 13; hex 637068696c6c6970735f726e61; asc cphillips_rna;;
26: len 19; hex 484341202d204d656e74616c204865616c7468; asc HCA - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 4; hex 30303030; asc 0000;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 32; asc 2;;
36: SQL NULL;

Record lock, heap no 45 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b4d; asc K[M;;
1: len 6; hex 0000059625ae; asc % ;;
2: len 7; hex 02000004902ed8; asc . ;;
3: len 4; hex 80000035; asc 5;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4b20000; asc ;;
7: len 5; hex 99b4b0ea86; asc ;;
8: len 4; hex 80000149; asc I;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 416e64726577205068696c6c6970204e65696c20426572727920636f6e66; asc Andrew Phillip Neil Berry conf; (total 175 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 996442d780; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a4f34; asc g O4;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343030353836; asc 1024400586;;
33: SQL NULL;
34: len 5; hex 4561726c79; asc Early;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 46 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b4e; asc K[N;;
1: len 6; hex 000005962659; asc &Y;;
2: len 7; hex 0200001456184a; asc V J;;
3: len 4; hex 80000004; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4b20000; asc ;;
7: len 5; hex 99b4b0ea8b; asc ;;
8: len 4; hex 800000e4; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 5061756c204a6f6e657320636f6e6669726d656420436f6e746163743a20; asc Paul Jones confirmed Contact: ; (total 137 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442d000; asc dB ;;
14: len 5; hex 9964434000; asc dC@ ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a502d; asc g P-;;
25: len 5; hex 4261746368; asc Batch;;
26: len 13; hex 47656e6572616c205761726473; asc General Wards;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383335383037; asc 1024835807;;
33: SQL NULL;
34: len 4; hex 4c617465; asc Late;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 47 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b4f; asc K[O;;
1: len 6; hex 000005963d45; asc =E;;
2: len 7; hex 0100000f0e23b4; asc # ;;
3: len 4; hex 800001bf; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4ba0000; asc ;;
7: len 5; hex 99b4b0ea8b; asc ;;
8: len 4; hex 800009d0; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 52656265636361202042617874657220636f6e6669726d656420436f6e74; asc Rebecca Baxter confirmed Cont; (total 151 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427780; asc dBw ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a5c0e; asc g \ ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 19; hex 524d4e202d204d656e74616c204865616c7468; asc RMN - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383238303932; asc 1024828092;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 48 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b50; asc K[P;;
1: len 6; hex 0000059d575a; asc WZ;;
2: len 7; hex 01000013112554; asc %T;;
3: len 4; hex 800001bf; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4b80000; asc ;;
7: len 5; hex 99b4b0ea8b; asc ;;
8: len 4; hex 800009d0; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 52656265636361202042617874657220636f6e6669726d656420436f6e74; asc Rebecca Baxter confirmed Cont; (total 149 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427780; asc dBw ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000000; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671fa16d; asc g m;;
25: len 5; hex 4261746368; asc Batch;;
26: len 19; hex 524d4e202d204d656e74616c204865616c7468; asc RMN - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383238303930; asc 1024828090;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 49 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b51; asc K[Q;;
1: len 6; hex 000005977597; asc u ;;
2: len 7; hex 01000014d01bd4; asc ;;
3: len 4; hex 800001bf; asc ;;
4: len 9; hex 436f6e6669726d6564; asc Confirmed;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4b60000; asc ;;
7: len 5; hex 99b4b0ea8b; asc ;;
8: len 4; hex 800009d0; asc ;;
9: len 4; hex 80000002; asc ;;
10: len 30; hex 52656265636361202042617874657220636f6e6669726d656420436f6e74; asc Rebecca Baxter confirmed Cont; (total 353 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427780; asc dBw ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000001; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000001; asc ;;
21: len 4; hex 80000001; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671b46e2; asc g F ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 19; hex 524d4e202d204d656e74616c204865616c7468; asc RMN - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234383238303839; asc 1024828089;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 50 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b2c; asc K[,;;
1: len 6; hex 000005b2778a; asc w ;;
2: len 7; hex 01000014e005ee; asc ;;
3: len 4; hex 800002fc; asc ;;
4: len 9; hex 43616e63656c6c6564; asc Cancelled;;
5: len 5; hex 4e69676874; asc Night;;
6: len 5; hex 99b4d80000; asc ;;
7: len 5; hex 99b4b0db04; asc ;;
8: len 4; hex 80000e69; asc i;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 53686966742043616e63656c6c656420666f7220446f6e6e61204c6f7569; asc Shift Cancelled for Donna Loui; (total 253 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964433000; asc dC0 ;;
14: len 5; hex 9964427780; asc dBw ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000001; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 672f38b7; asc g/8 ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 19; hex 524d4e202d204d656e74616c204865616c7468; asc RMN - Mental Health;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343037313239; asc 1024407129;;
33: SQL NULL;
34: len 5; hex 4e69676874; asc Night;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;


*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 983 page no 980 n bits 112 index PRIMARY of table `richmond`.`tblJobRequests` trx id 108335355 lock mode S waiting
Record lock, heap no 29 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5f59; asc K_Y;;
1: len 6; hex 000005bc62fb; asc b ;;
2: len 7; hex 0100000f161754; asc T;;
3: len 4; hex 8000000e; asc ;;
4: len 9; hex 43616e63656c6c6564; asc Cancelled;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4e40000; asc ;;
7: len 5; hex 99b4b6dd82; asc ;;
8: len 4; hex 800001db; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 53686966742043616e63656c6c656420666f7220436174686572696e6520; asc Shift Cancelled for Catherine ; (total 318 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 996442d000; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000001; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 6737342e; asc g74.;;
25: len 5; hex 4261746368; asc Batch;;
26: len 3; hex 434355; asc CCU;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 82; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343038333934; asc 1024408394;;
33: SQL NULL;
34: len 3; hex 4c2f44; asc L/D;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;


*** (2) TRANSACTION:
TRANSACTION 108335357, ACTIVE 2 sec starting index read
mysql tables in use 4, locked 4
LOCK WAIT 2278 lock struct(s), heap size 254072, 87985 row lock(s)
MySQL thread id 64578776, OS thread handle 22773140190976, query id 10030843300 172.31.45.113 admin executing
UPDATE tblJobRequests j2
INNER JOIN
(SELECT j.jobid
FROM upload_cwmtaf c
JOIN tblJobRequests j
on c.requestid = j.HospitalRef
INNER JOIN tblHospitals h
ON h.hospitalid = j.hospitalid
WHERE
j.`Status` in ('Cleared', 'Cancelled', 'Given Back')

AND h.healthboard = 'Cwm Taf'

) AS j1
ON j1.jobid = j2.jobid
SET j2.`status` = 'Allocating',
`NursesNeeded` = 1,
`NursesFound`= 0,
`InitialNoNeeded`=1,
`NoConfirmed`=0,
`NoCancelled`=0,
`NoGivenBack`=0,
`NoPulled`=0,
`NoCancelled2`=0,
j2.Notes= concat('Reinstated via batch import at ',date_format(now(), '%d-%m-%y %H:%i'), '
', j2.Notes)

*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 983 page no 980 n bits 112 index PRIMARY of table `richmond`.`tblJobRequests` trx id 108335357 lock_mode X locks rec but not gap
Record lock, heap no 29 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5f59; asc K_Y;;
1: len 6; hex 000005bc62fb; asc b ;;
2: len 7; hex 0100000f161754; asc T;;
3: len 4; hex 8000000e; asc ;;
4: len 9; hex 43616e63656c6c6564; asc Cancelled;;
5: len 5; hex 4561726c79; asc Early;;
6: len 5; hex 99b4e40000; asc ;;
7: len 5; hex 99b4b6dd82; asc ;;
8: len 4; hex 800001db; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 53686966742043616e63656c6c656420666f7220436174686572696e6520; asc Shift Cancelled for Catherine ; (total 318 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 9964427000; asc dBp ;;
14: len 5; hex 996442d000; asc dB ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000001; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 6737342e; asc g74.;;
25: len 5; hex 4261746368; asc Batch;;
26: len 3; hex 434355; asc CCU;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 82; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343038333934; asc 1024408394;;
33: SQL NULL;
34: len 3; hex 4c2f44; asc L/D;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

Record lock, heap no 43 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5f5a; asc K_Z;;
1: len 6; hex 000005bc62fb; asc b ;;
2: len 7; hex 0100000f161846; asc F;;
3: len 4; hex 8000000e; asc ;;
4: len 9; hex 43616e63656c6c6564; asc Cancelled;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4e40000; asc ;;
7: len 5; hex 99b4b6dd82; asc ;;
8: len 4; hex 800001db; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 53686966742043616e63656c6c656420666f7220436174686572696e6520; asc Shift Cancelled for Catherine ; (total 318 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442d000; asc dB ;;
14: len 5; hex 9964433780; asc dC7 ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000001; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 6737342e; asc g74.;;
25: len 5; hex 4261746368; asc Batch;;
26: len 3; hex 434355; asc CCU;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 82; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 31303234343038333934; asc 1024408394;;
33: SQL NULL;
34: len 3; hex 4c2f44; asc L/D;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;


*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 983 page no 445 n bits 120 index PRIMARY of table `richmond`.`tblJobRequests` trx id 108335357 lock_mode X locks rec but not gap waiting
Record lock, heap no 20 PHYSICAL RECORD: n_fields 37; compact format; info bits 64
0: len 4; hex 804b5b28; asc K[(;;
1: len 6; hex 000005966daf; asc m ;;
2: len 7; hex 02000014672964; asc g)d;;
3: len 4; hex 80000035; asc 5;;
4: len 9; hex 43616e63656c6c6564; asc Cancelled;;
5: len 4; hex 4c617465; asc Late;;
6: len 5; hex 99b4ce0000; asc ;;
7: len 5; hex 99b4b0da86; asc ;;
8: len 4; hex 80001d13; asc ;;
9: len 4; hex 80000001; asc ;;
10: len 30; hex 53686966742043616e63656c6c656420666f7220416e6472657720506869; asc Shift Cancelled for Andrew Phi; (total 268 bytes);
11: len 8; hex 526963686d6f6e64; asc Richmond;;
12: len 5; hex 4261746368; asc Batch;;
13: len 5; hex 996442d000; asc dB ;;
14: len 5; hex 9964433780; asc dC7 ;;
15: len 4; hex 00000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 4; hex 80000000; asc ;;
18: SQL NULL;
19: len 4; hex 80000001; asc ;;
20: len 4; hex 80000000; asc ;;
21: len 4; hex 80000001; asc ;;
22: len 4; hex 80000000; asc ;;
23: len 1; hex 80; asc ;;
24: len 4; hex 671a76ee; asc g v ;;
25: len 5; hex 4261746368; asc Batch;;
26: len 15; hex 41264520436f6d666f727461626c65; asc A&E Comfortable;;
27: len 4; hex 80000000; asc ;;
28: len 4; hex 80000000; asc ;;
29: SQL NULL;
30: len 1; hex 80; asc ;;
31: len 1; hex 80; asc ;;
32: len 10; hex 30393234333739343432; asc 0924379442;;
33: SQL NULL;
34: len 4; hex 4c617465; asc Late;;
35: len 1; hex 35; asc 5;;
36: SQL NULL;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 108614018
Purge done for trx's n:o < 108614018 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 304249852405200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304249852404392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304249852402776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304249852401968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304249852401160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304249852403584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304249852400352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 304249852399544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests ((null))
I/O thread 1 state: waiting for completed aio requests (insert buffer thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:
Pending flushes (fsync) log: 0; buffer pool: 0
3041865 OS file reads, 90444039 OS file writes, 51727822 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.50 writes/s, 0.25 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 120, seg size 122, 44869 merges
merged operations:
insert 62902, delete mark 27634, delete 18341
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 143 buffer(s)
Hash table size 276707, node heap has 201 buffer(s)
Hash table size 276707, node heap has 344 buffer(s)
Hash table size 276707, node heap has 33 buffer(s)
Hash table size 276707, node heap has 317 buffer(s)
Hash table size 276707, node heap has 322 buffer(s)
Hash table size 276707, node heap has 350 buffer(s)
Hash table size 276707, node heap has 1291 buffer(s)
57.81 hash searches/s, 3.55 non-hash searches/s
---
LOG
---
Log sequence number 204687047961
Log buffer assigned up to 204687047961
Log buffer completed up to 204687047961
Log written up to 204687047961
Log flushed up to 204687047961
Added dirty pages up to 204687047961
Pages flushed up to 204687047961
Last checkpoint at 204687047961
Log minimum file id is 1107
Log maximum file id is 1137
39718560 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 4931638
Buffer pool size 65531
Free buffers 8202
Database pages 54328
Old database pages 19894
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 102892564, not young 953838750
7.00 youngs/s, 0.00 non-youngs/s
Pages read 3040346, created 35916980, written 30854589
0.00 reads/s, 1.00 creates/s, 0.25 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 4 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 54328, unzip_LRU len: 0
I/O sum[168]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 8191
Free buffers 1026
Database pages 6789
Old database pages 2486
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14529443, not young 101958743
0.00 youngs/s, 0.00 non-youngs/s
Pages read 385687, created 4286095, written 4867781
0.00 reads/s, 0.00 creates/s, 0.00 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: 6789, unzip_LRU len: 0
I/O sum[21]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 8192
Free buffers 1024
Database pages 6784
Old database pages 2484
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 13466773, not young 98679348
0.00 youngs/s, 0.00 non-youngs/s
Pages read 398394, created 4091697, written 4480239
0.00 reads/s, 0.00 creates/s, 0.00 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: 6784, unzip_LRU len: 0
I/O sum[21]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 8191
Free buffers 1025
Database pages 6788
Old database pages 2485
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11970204, not young 106425146
0.00 youngs/s, 0.00 non-youngs/s
Pages read 385727, created 4052636, written 2117671
0.00 reads/s, 0.00 creates/s, 0.00 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: 6788, unzip_LRU len: 0
I/O sum[21]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 8191
Free buffers 1025
Database pages 6799
Old database pages 2489
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 13484287, not young 135262718
0.00 youngs/s, 0.00 non-youngs/s
Pages read 368249, created 4981062, written 1841709
0.00 reads/s, 0.00 creates/s, 0.00 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: 6799, unzip_LRU len: 0
I/O sum[21]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 8192
Free buffers 1025
Database pages 6789
Old database pages 2486
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12906698, not young 194336356
0.00 youngs/s, 0.00 non-youngs/s
Pages read 366188, created 6241517, written 4016349
0.00 reads/s, 0.00 creates/s, 0.00 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: 6789, unzip_LRU len: 0
I/O sum[21]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 8191
Free buffers 1025
Database pages 6805
Old database pages 2492
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 15154164, not young 113932988
0.00 youngs/s, 0.00 non-youngs/s
Pages read 378724, created 4715778, written 5082796
0.00 reads/s, 0.00 creates/s, 0.00 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: 6805, unzip_LRU len: 0
I/O sum[21]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 8191
Free buffers 1025
Database pages 6784
Old database pages 2484
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 10155586, not young 108838984
0.00 youngs/s, 0.00 non-youngs/s
Pages read 370630, created 3847377, written 2167714
0.00 reads/s, 0.00 creates/s, 0.00 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: 6784, unzip_LRU len: 0
I/O sum[21]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 8192
Free buffers 1027
Database pages 6790
Old database pages 2488
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11225409, not young 94404467
7.00 youngs/s, 0.00 non-youngs/s
Pages read 386747, created 3700818, written 6280330
0.00 reads/s, 1.00 creates/s, 0.25 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 40 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6790, unzip_LRU len: 0
I/O sum[21]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=870, Main thread ID=22773449611008 , state=sleeping
Number of rows inserted 110133072, updated 11336286, deleted 11015536, read 3198557390839
1.82 inserts/s, 0.00 updates/s, 0.00 deletes/s, 39892.83 reads/s
Number of system rows inserted 1356124, updated 720172, deleted 1068681, read 228622335
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

---

Process List

5	event_scheduler	localhost		Daemon	18441888	Waiting on empty queue
64482446	rdsadmin	localhost	mysql	Sleep	12
64694382	admin	172.31.45.113:49806	richmondua	Sleep	297
64694386	admin	172.31.45.113:49814	richmondua	Sleep	296
66092427	admin	172.31.45.113:41552	richmond	Sleep	12
66092430	admin	172.31.45.113:41554		Sleep	11
66099010	admin	172.31.45.113:50230	richmond	Query	0	init	show full processlist
66099011	admin	172.31.45.113:50232	richmond_registrations	Sleep	0
66099012	admin	172.31.45.113:50234	data_warehouse	Sleep	0

---

Running Transactions