Добрый день!
Столкнулся с дедлоками, хотелось бы послушать опытных товарищей как с этим быть.
Описание:
Есть табличка
CREATE TABLE `Domain_Site_Sync` (
`id_domain_site` bigint(20) unsigned NOT NULL DEFAULT '0',
`id_site_task` bigint(20) unsigned NOT NULL,
`datetime_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`state` tinyint(4) NOT NULL DEFAULT '0',
`lock` tinyint(4) NOT NULL DEFAULT '0',
`datetime_processed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lock_domain` tinyint(4) unsigned NOT NULL DEFAULT '0',
`datetime_lock_domain` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`block` tinyint(3) NOT NULL DEFAULT '0',
`sign` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_domain_site`),
KEY `datetime_check` (`lock`,`state`,`block`,`lock_domain`,`datetime_check`,`id_domain_site`),
KEY `sign` (`sign`),
KEY `lock_domain` (`lock_domain`,`datetime_lock_domain`),
KEY `lock` (`lock`,`datetime_processed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Через ХП над ней производятся две операции
1. Забираем из таблицы любые 10 записей подходящие под условия. Выставляем dss.sign = _var_sign, где _var_sign это UUID_SHORT().
Это позволяет знать какие записи были забраны, и с ними можно работать в дальнейшем.
update `Domain_Site_Sync` as dss
force key(datetime_check)
set
dss.`lock` = 1,
dss.datetime_processed = _var_datetime_now,
dss.sign = _var_sign
where
dss.`lock` = 0 and
dss.`lock_domain` = 0 and
dss.`block` = 0 and
dss.state = 1 and
dss.datetime_check <= now()
limit 10;
2. Особождаем запись в Domain_Site_Sync зная _var_id_domain_site.
При этом гарантируется что запись с _var_id_domain_site не может участвовать в выборке в п.1 т.к. она логически исключается из выборки выставлением dss.`lock` = 1
update `Domain_Site_Sync` as dss
set
dss.id_site_task = _var_id_site,
dss.datetime_check = _var_datetime_check,
dss.state = _var_state_domain_sync,
dss.lock = 0
where dss.id_domain_site = _var_id_domain_site;
Периодически возникают дедлоки
Вот что пишет иннтоп
________________________________________________________ Deadlock Transactions ________________________________________________________
ID Timestring User Host Victim Time Undo LStrcts Query Text
236 2012-11-06 12:02:49 root 172 No 00:00 0 9 update `Domain_Site_Sync` as dss force key(datetime_check) set dss.
240 2012-11-06 12:02:49 root 172 Yes 00:00 1 4 update `Domain_Site_Sync` as dss set dss.id_site_task = NAME_CONST(
___________________________________ Deadlock Locks ___________________________________
ID Waiting Mode DB Table Index Special Ins Intent
236 0 X rts Domain_Site_Sync datetime_check rec but not gap 0
236 1 X rts Domain_Site_Sync datetime_check rec but not gap 0
240 1 X rts Domain_Site_Sync datetime_check rec but not gap 0
Используется уровень изоляции - read-committed
Почему происходят дедлоки?
Ведь в апдейты выборки проходят по разным индексам + записи в апдейтах не пересекаются по primarykey - все записи выбранные в п.1 исчезают из поля выборки до тех пор пока их не освободят в п.2
Вывод инндоб монитора
=====================================
121106 12:04:37 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 1 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 7285 1_second, 7282 sleeps, 725 10_second, 272 background, 272 flush
srv_master_thread log flush and writes: 5009
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 577177, signal count 1161902
Mutex spin waits 13035853, rounds 25601502, OS waits 56837
RW-shared spins 544869, rounds 8330042, OS waits 190050
RW-excl spins 1157922, rounds 14873987, OS waits 304258
Spin rounds per wait: 1.96 mutex, 15.29 RW-shared, 12.85 RW-excl
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log 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 (read thread)
I/O thread 7 state: waiting for completed aio requests (read thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
I/O thread 10 state: waiting for completed aio requests (write thread)
I/O thread 11 state: waiting for completed aio requests (write thread)
I/O thread 12 state: waiting for completed aio requests (write thread)
I/O thread 13 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
302467 OS file reads, 592895 OS file writes, 52862 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1.00 writes/s, 1.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 53124251, node heap has 5447 buffer(s)
4200.80 hash searches/s, 6996.00 non-hash searches/s
---
LOG
---
Log sequence number 37452584568
Log flushed up to 37452403018
Last checkpoint at 37041935460
Max checkpoint age 1303885210
Checkpoint age target 1263138798
Modified age 410649108
Checkpoint age 410649108
0 pending log writes, 0 pending chkp writes
12321 log i/o's done, 1.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 27577548800; in additional pool allocated 0
Internal hash tables (constant factor + variable factor)
Adaptive hash index 514241872 (424994008 + 89247864)
Page hash 3321064 (buffer pool 0 only)
Dictionary cache 106423717 (106250096 + 173621)
File system 96752 (82672 + 14080)
Lock system 73924352 (73919464 + 4888)
Recovery system 0 (0 + 0)
Dictionary memory allocated 173621
Buffer pool size 1638392
Buffer pool size, bytes 26843414528
Free buffers 1315423
Database pages 317522
Old database pages 117046
Modified db pages 2111
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 9976, not young 714813
0.00 youngs/s, 0.00 non-youngs/s
Pages read 302278, created 19007, written 324019
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: 317522, unzip_LRU len: 0
I/O sum[15528]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 204799
Buffer pool size, bytes 3355426816
Free buffers 164271
Database pages 39838
Old database pages 14685
Modified db pages 306
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1160, not young 66361
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37999, created 2359, written 39398
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: 39838, unzip_LRU len: 0
I/O sum[1941]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 204799
Buffer pool size, bytes 3355426816
Free buffers 164148
Database pages 39954
Old database pages 14728
Modified db pages 417
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1266, not young 77107
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37858, created 2423, written 41434
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: 39954, unzip_LRU len: 0
I/O sum[1941]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 204799
Buffer pool size, bytes 3355426816
Free buffers 164595
Database pages 39533
Old database pages 14573
Modified db pages 426
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1250, not young 63948
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37916, created 2061, written 42346
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: 39533, unzip_LRU len: 0
I/O sum[1941]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 204799
Buffer pool size, bytes 3355426816
Free buffers 164324
Database pages 39834
Old database pages 14684
Modified db pages 510
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1242, not young 66805
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37828, created 2566, written 44927
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: 39834, unzip_LRU len: 0
I/O sum[1941]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 204799
Buffer pool size, bytes 3355426816
Free buffers 164362
Database pages 39767
Old database pages 14659
Modified db pages 405
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1330, not young 89785
0.00 youngs/s, 0.00 non-youngs/s
Pages read 38044, created 2216, written 43777
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: 39767, unzip_LRU len: 0
I/O sum[1941]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 204799
Buffer pool size, bytes 3355426816
Free buffers 164510
Database pages 39617
Old database pages 14604
Modified db pages 3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1306, not young 96332
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37783, created 2244, written 37011
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: 39617, unzip_LRU len: 0
I/O sum[1941]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 204799
Buffer pool size, bytes 3355426816
Free buffers 164251
Database pages 39843
Old database pages 14687
Modified db pages 32
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1175, not young 139306
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37834, created 2472, written 37471
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: 39843, unzip_LRU len: 0
I/O sum[1941]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 204799
Buffer pool size, bytes 3355426816
Free buffers 164962
Database pages 39136
Old database pages 14426
Modified db pages 12
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1247, not young 115169
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37016, created 2666, written 37655
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: 39136, unzip_LRU len: 0
I/O sum[1941]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
---OLDEST VIEW---
Normal read view
Read view low limit trx n
4D237D2
Read view up limit trx id 4D237D2
Read view low limit trx id 4D237D2
Read view individually stored trx ids:
-----------------
Main thread process no. 734, id 140099245221632, state: sleeping
Number of rows inserted 2938088, updated 11325586, deleted 0, read 144054643
102.90 inserts/s, 526.47 updates/s, 0.00 deletes/s, 2138.86 reads/s
------------------------
LATEST DETECTED DEADLOCK
------------------------
121106 12:02:49
*** (1) TRANSACTION:
TRANSACTION 4C84232, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1
MySQL thread id 240, OS thread handle 0x7f6b65df2700, query id 133577190 172.16.50.26 root Updating
update `Domain_Site_Sync` as dss
set
dss.id_site_task = NAME_CONST('_var_id_site',383733),
dss.datetime_check = NAME_CONST('_var_datetime_check',_latin1'2012-11-06 12:02:49' COLLATE 'latin1_swedish_ci'),
dss.state = NAME_CONST('_var_state_domain_sync',1),
dss.lock = 0
where dss.id_domain_site = NAME_CONST('_var_id_domain_site',6852)
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 155 page no 712 n bits 672 index `datetime_check` of table `rts`.`Domain_Site_Sync` trx id 4C84232 lock_mode X locks rec but not gap waiting
Record lock, heap no 248 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000001ac4; asc ;;
*** (2) TRANSACTION:
TRANSACTION 4C84234, ACTIVE 0 sec
mysql tables in use 1, locked 1
9 lock struct(s), heap size 3112, 105 row lock(s)
MySQL thread id 236, OS thread handle 0x7f6b578c4700, query id 133577180 172.16.50.26 root Searching rows for update
update `Domain_Site_Sync` as dss
force key(datetime_check)
set
dss.`lock` = 1,
dss.datetime_processed = NAME_CONST('_var_datetime_now',_latin1'2012-11-06 12:02:49' COLLATE 'latin1_swedish_ci'),
dss.sign = NAME_CONST('_var_sign',1319722768425817402)
where
dss.`lock` = 0 and
dss.`lock_domain` = 0 and
dss.`block` = 0 and
dss.state = 1 and
dss.datetime_check <= NAME_CONST('_var_datetime_now',_latin1'2012-11-06 12:02:49' COLLATE 'latin1_swedish_ci')
limit 10
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 155 page no 712 n bits 672 index `datetime_check` of table `rts`.`Domain_Site_Sync` trx id 4C84234 lock_mode X locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 00000000000063ef; asc c ;;
Record lock, heap no 9 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 00000000000054a2; asc T ;;
Record lock, heap no 13 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008cfd; asc ;;
Record lock, heap no 33 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000007568; asc uh;;
Record lock, heap no 35 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008ac7; asc ;;
Record lock, heap no 39 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006a2a; asc j*;;
Record lock, heap no 40 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000007ba3; asc { ;;
Record lock, heap no 44 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008bc9; asc ;;
Record lock, heap no 47 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000006cbb; asc l ;;
Record lock, heap no 57 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008bae; asc ;;
Record lock, heap no 65 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 000000000000642c; asc d,;;
Record lock, heap no 66 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000079e3; asc y ;;
Record lock, heap no 73 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008bbd; asc ;;
Record lock, heap no 79 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000087a3; asc ;;
Record lock, heap no 86 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008651; asc Q;;
Record lock, heap no 89 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000005ca5; asc \ ;;
Record lock, heap no 93 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008660; asc `;;
Record lock, heap no 101 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000003545; asc 5E;;
Record lock, heap no 106 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000006f2f; asc o/;;
Record lock, heap no 132 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000078b6; asc x ;;
Record lock, heap no 137 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000001ac4; asc ;;
Record lock, heap no 142 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000005021; asc P!;;
Record lock, heap no 144 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008bb7; asc ;;
Record lock, heap no 151 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000007992; asc y ;;
Record lock, heap no 153 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 000000000000643e; asc d>;;
Record lock, heap no 155 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000046a0; asc F ;;
Record lock, heap no 157 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008bbd; asc ;;
Record lock, heap no 191 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000002642; asc &B;;
Record lock, heap no 198 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008cfb; asc ;;
Record lock, heap no 202 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000086c0; asc ;;
Record lock, heap no 203 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 00000000000086dd; asc ;;
Record lock, heap no 216 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000007f31; asc 1;;
Record lock, heap no 218 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008ac7; asc ;;
Record lock, heap no 219 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000005ca5; asc \ ;;
Record lock, heap no 237 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 000000000000714f; asc qO;;
Record lock, heap no 246 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000002fa2; asc / ;;
Record lock, heap no 248 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000001ac4; asc ;;
Record lock, heap no 250 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000006f59; asc oY;;
Record lock, heap no 253 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 00000000000086c0; asc ;;
Record lock, heap no 254 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000085fd; asc ;;
Record lock, heap no 257 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008660; asc `;;
Record lock, heap no 270 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000087c7; asc ;;
Record lock, heap no 280 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008cfe; asc ;;
Record lock, heap no 286 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000077e5; asc w ;;
Record lock, heap no 288 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000007f31; asc 1;;
Record lock, heap no 289 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008cfe; asc ;;
Record lock, heap no 298 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000007f5e; asc ^;;
Record lock, heap no 300 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006f59; asc oY;;
Record lock, heap no 302 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000004159; asc AY;;
Record lock, heap no 303 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008651; asc Q;;
Record lock, heap no 305 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008bae; asc ;;
Record lock, heap no 317 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000086dd; asc ;;
Record lock, heap no 322 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000006a2a; asc j*;;
Record lock, heap no 325 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008adf; asc ;;
Record lock, heap no 332 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 00000000000087c7; asc ;;
Record lock, heap no 337 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000006247; asc bG;;
Record lock, heap no 343 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000062f1; asc b ;;
Record lock, heap no 352 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000061aa; asc a ;;
Record lock, heap no 353 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008ac9; asc ;;
Record lock, heap no 354 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000002643; asc &C;;
Record lock, heap no 360 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008cfb; asc ;;
Record lock, heap no 361 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 00000000000086ee; asc ;;
Record lock, heap no 370 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000003e82; asc > ;;
Record lock, heap no 379 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000004159; asc AY;;
Record lock, heap no 389 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006cb2; asc l ;;
Record lock, heap no 390 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008cfd; asc ;;
Record lock, heap no 400 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 000000000000861c; asc ;;
Record lock, heap no 407 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000007ba3; asc { ;;
Record lock, heap no 418 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000003e82; asc > ;;
Record lock, heap no 426 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 00000000000078b6; asc x ;;
Record lock, heap no 434 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008ac6; asc ;;
Record lock, heap no 435 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000072a6; asc r ;;
Record lock, heap no 439 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000003545; asc 5E;;
Record lock, heap no 442 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006247; asc bG;;
Record lock, heap no 445 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000005021; asc P!;;
Record lock, heap no 461 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 00000000000077e5; asc w ;;
Record lock, heap no 467 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000002643; asc &C;;
Record lock, heap no 476 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006a21; asc j!;;
Record lock, heap no 488 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008ac6; asc ;;
Record lock, heap no 489 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006677; asc fw;;
Record lock, heap no 496 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000063ef; asc c ;;
Record lock, heap no 511 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006ca2; asc l ;;
Record lock, heap no 521 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000004327; asc C';;
Record lock, heap no 530 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 000000000000665d; asc f];;
Record lock, heap no 535 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000046b2; asc F ;;
Record lock, heap no 541 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000007163; asc qc;;
Record lock, heap no 553 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000007163; asc qc;;
Record lock, heap no 555 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008bc9; asc ;;
Record lock, heap no 557 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000008ac9; asc ;;
Record lock, heap no 563 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000002642; asc &B;;
Record lock, heap no 565 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000008adf; asc ;;
Record lock, heap no 570 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe38; asc L a 8;;
5: len 8; hex 0000000000006a21; asc j!;;
Record lock, heap no 575 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000054a2; asc T ;;
Record lock, heap no 580 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006f2f; asc o/;;
Record lock, heap no 588 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 00000000000086ee; asc ;;
Record lock, heap no 589 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006f5a; asc oZ;;
Record lock, heap no 596 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 80; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000006cbb; asc l ;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 155 page no 712 n bits 672 index `datetime_check` of table `rts`.`Domain_Site_Sync` trx id 4C84234 lock_mode X locks rec but not gap waiting
Record lock, heap no 59 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 1; hex 81; asc ;;
1: len 1; hex 81; asc ;;
2: len 1; hex 80; asc ;;
3: len 1; hex 00; asc ;;
4: len 8; hex 8000124ccf61fe39; asc L a 9;;
5: len 8; hex 0000000000001ac4; asc ;;
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 4D23BE9
Purge done for trx's n
< 4D237D1 undo n
< 0
History list length 2658
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 4D23BBE, not started
MySQL thread id 243, OS thread handle 0x7f6b57956700, query id 136649304 172.16.50.26 root
---TRANSACTION 4D23BDE, not started
MySQL thread id 242, OS thread handle 0x7f6b5747d700, query id 136649454 172.16.50.26 root
---TRANSACTION 4D23B91, not started
MySQL thread id 241, OS thread handle 0x7f6b57be7700, query id 136649101 172.16.50.26 root
---TRANSACTION 4D23BA0, not started
MySQL thread id 240, OS thread handle 0x7f6b65df2700, query id 136649154 172.16.50.26 root
---TRANSACTION 4D23BE8, not started
MySQL thread id 239, OS thread handle 0x7f6b57b0c700, query id 136649497 172.16.50.26 root
---TRANSACTION 4D23BAA, not started
MySQL thread id 238, OS thread handle 0x7f6b57cc2700, query id 136649218 172.16.50.26 root
---TRANSACTION 4D23B94, not started
MySQL thread id 237, OS thread handle 0x7f6b57633700, query id 136649144 172.16.50.26 root
---TRANSACTION 4D23BCA, not started
MySQL thread id 236, OS thread handle 0x7f6b578c4700, query id 136649347 172.16.50.26 root
---TRANSACTION 4D23BB4, not started
MySQL thread id 234, OS thread handle 0x7f6b57c79700, query id 136649261 172.16.50.26 root
---TRANSACTION 4D23BD4, not started
MySQL thread id 235, OS thread handle 0x7f6b65cce700, query id 136649411 172.16.50.26 root
---TRANSACTION 0, not started
MySQL thread id 22, OS thread handle 0x7f6b65da9700, query id 136642160 172.16.50.11 root
---TRANSACTION 4C64699, not started
MySQL thread id 4, OS thread handle 0x7f6b65e3b700, query id 132996126 172.16.50.26 root
---TRANSACTION 45B2576, not started
MySQL thread id 3, OS thread handle 0x7f720006b700, query id 136649539 172.16.50.26 root
SHOW ENGINE INNODB STATUS
----------------------------
END OF INNODB MONITOR OUTPUT
============================
ps: просьба не ругаться - бб код спойлера не нашел)
