踩雷排雷之路
前言
本篇用于记录工作中项目的踩雷之坑，排雷过程，以及总结。
1.重复新增设备
1.1 复现场景
用户高频率添加设备，很多请求短时间到达后端，第一次的请求标记设备 A 为新增设备，执行批量修改设备（耗时长），此时第二次的请求进来，又标记设备 A 为新增设备，这时候就会造成重复新增设备的问题了
1.2 加锁
- 解决方案：加锁，确保新增设备请求一个一个执行
- 锁的类型：Redisson 的公平锁
- 锁的对象：adddevice_lock用户名
- 依赖：
<!-- redisson -->
<dependency>
<groupId>org.redisson</groupId>
<artifactId>redisson-spring-boot-starter</artifactId>
<version>3.23.4</version>
</dependency>- Reddsion 配置类
@Configuration
public class RedissonConfig {
@Value("${spring.data.redis.host}")
private String host;
@Value("${spring.data.redis.port}")
private String port;
@Value("${spring.data.redis.password}")
private String password;
@Bean
public RedissonClient redissonClient() {
Config config = new Config();
String address = "redis://" + host + ":" + port;
config.useSingleServer()
.setAddress(address)
.setPassword(password)
.setConnectionPoolSize(50)
.setIdleConnectionTimeout(10000)
.setConnectTimeout(3000)
.setTimeout(3000)
.setDatabase(0);
return Redisson.create(config);
}
}- 使用 Redisson 的公平锁
@Autowired
private RedissonClient redissonClient;
@Transactional(rollbackFor = Exception.class)
@Override
public void addDevice(JSONObject json) {
String key = "add_device_lock_" + getUserId();
// 加锁，没有获取到锁的会被阻塞
RLock fairLock = redissonClient.getFairLock(key);
try{
log.info("时间：{},线程：{},获取到锁：{}", LocalDateTime.now(), Thread.currentThread().getName(), key);
final Long userId = getUserId();
final String all = "全部";
// 批量查询设备
// 批量插入、修改设备
}catch (Exception e) {
log.error("批量添加设备出错：{}", e.getMessage());
} finally {
// 解锁
fairLock.unlock();
log.info("时间：{},线程：{},释放锁：{}", LocalDateTime.now(), Thread.currentThread().getName(), key);
}
}2.事务提交在锁释放之后
2.1 问题
在对 “重复新增设备” 的 bug 进行测试时，发现还会出现重复新增设备的问题，通过解锁和获取锁的日志时间发现，上一个线程刚解锁，下一个线程在极短时间内就获取锁了。
- 问题：上一个线程还没有提交事务，就释放锁了
- 思路：确保事务提交在锁释放之后
2.2 改造
- addDevice：不加事务注解 @Transactional
@Override
public void addDevice(JSONObject json) {
String key = "add_device_lock_" + getUserId();
RLock fairLock = redissonClient.getFairLock(key);
// 加锁
fairLock.lock();
try {
log.info("时间：{},线程：{},获取到锁：{}", LocalDateTime.now(), Thread.currentThread().getName(), key);
// 获取当前对象
DeviceServiceImpl deviceService = SpringUtils.getBean(DeviceServiceImpl.class);
deviceService.insertDevice(json);
} catch (Exception e) {
log.error("批量添加设备出错：{}", e.getMessage());
} finally {
// 解锁
fairLock.unlock();
log.info("时间：{},线程：{},释放锁：{}", LocalDateTime.now(), Thread.currentThread().getName(), key);
}
}- 实际操作数据库的方法：
@Transactional(rollbackFor = Exception.class)
public void insertDevice(JSONObject json) {
// 操作数据库
}3.死锁
3.1 发现死锁
- 查看系统错误日志：Deadlock found when trying to get lock（尝试获取锁时发现死锁）
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction- mysql 查看最近一次死锁记录命令：
SHOW ENGINE INNODB STATUS;结果显示三个字段：Type 、Name 、Status ，重点关注 Status ，复制粘贴到 txt 文件
=====================================
2025-09-12 16:56:51 22762938742336 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 37 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 333666 srv_active, 0 srv_shutdown, 621901 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 18500
OS WAIT ARRAY INFO: signal count 17061
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-09-12 15:53:48 22763061405248
*** (1) TRANSACTION:
TRANSACTION 4197328, ACTIVE 0 sec fetching rows
# 表示此事务修改了一个表，锁了一行数据
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 99 row lock(s), undo log entries 2
MySQL thread id 2984, OS thread handle 22762927093312, query id 1759528 8.155.33.36 root updating
UPDATE zet_device d
SET d.ipaddress = '219.136.131.153',
d.nation = '中国',
d.province = '广东省',
d.city = '广州市'
WHERE d.device_identifier = 'E5FC08'
# 事务1 持行级锁，锁的是主键索引，锁的类型为 X（排它锁）
*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 33 page no 5 n bits 128 index PRIMARY of table `zetlight-test`.`zet_device` trx id 4197328 lock_mode X
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 27; compact format; info bits 0
0: len 8; hex 800000000000017f; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 01000002120c52; asc R;;
3: len 6; hex 333933433638; asc 393C68;;
4: len 12; hex 55315f42545f333933433638; asc U1_BT_393C68;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233383031; asc 0x01023801;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000001; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b7948ae4; asc ;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;
Record lock, heap no 3 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000183; asc ;;
1: len 6; hex 000000400b4e; asc @ N;;
2: len 7; hex 02000001a13037; asc 07;;
3: len 6; hex 344136463936; asc 4A6F96;;
4: len 16; hex 46382d4d41585f49495f344136463936; asc F8-MAX_II_4A6F96;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323334343133363436333933363031; asc DD001C010231010234413646393601; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313334343133363436333933363033; asc DD000F010231010134413646393603; (total 38 bytes);
16: len 4; hex 80000000; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b7949c2d; asc -;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 4 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000184; asc ;;
1: len 6; hex 000000400b68; asc @ h;;
2: len 7; hex 02000001b82498; asc $ ;;
3: len 6; hex 303531413932; asc 051A92;;
4: len 16; hex 46382d4d41585f49495f303531413932; asc F8-MAX_II_051A92;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323330333533313431333933323031; asc DD001C010231010230353141393201; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4f; asc O;;
15: len 30; hex 444430303046303130323331303130313330333533313431333933323033; asc DD000F010231010130353141393203; (total 38 bytes);
16: len 4; hex 80000001; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b7949e02; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 5 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000185; asc ;;
1: len 6; hex 000000400ba4; asc @ ;;
2: len 7; hex 010000017a0f6e; asc z n;;
3: len 6; hex 344232363032; asc 4B2602;;
4: len 16; hex 46382d4d41585f49495f344232363032; asc F8-MAX_II_4B2602;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323334343233323336333033323031; asc DD001C010231010234423236303201; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd67; asc g;;
15: len 30; hex 444430303046303130323331303130313334343233323336333033323033; asc DD000F010231010134423236303203; (total 38 bytes);
16: len 4; hex 80000002; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794a4ba; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 6 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000186; asc ;;
1: len 6; hex 000000400b5d; asc @ ];;
2: len 7; hex 020000014f1ebc; asc O ;;
3: len 6; hex 443038304537; asc D080E7;;
4: len 16; hex 46382d4d41585f49495f443038304537; asc F8-MAX_II_D080E7;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323434333033383330343533373031; asc DD001C010231010244303830453701; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313434333033383330343533373033; asc DD000F010231010144303830453703; (total 38 bytes);
16: len 4; hex 80000003; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794a536; asc 6;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 7 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000187; asc ;;
1: len 6; hex 000000400b57; asc @ W;;
2: len 7; hex 020000017b10ab; asc { ;;
3: len 6; hex 304346364533; asc 0CF6E3;;
4: len 16; hex 46382d4d41585f49495f304346364533; asc F8-MAX_II_0CF6E3;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323330343334363336343533333031; asc DD001C010231010230434636453301; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313330343334363336343533333033; asc DD000F010231010130434636453303; (total 38 bytes);
16: len 4; hex 80000004; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794db4f; asc O;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 8 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000188; asc ;;
1: len 6; hex 000000400b46; asc @ F;;
2: len 7; hex 020000014422bb; asc D" ;;
3: len 6; hex 313641413745; asc 16AA7E;;
4: len 16; hex 46382d4d41585f49495f313641413745; asc F8-MAX_II_16AA7E;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323331333634313431333734353031; asc DD001C010231010231364141374501; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313331333634313431333734353033; asc DD000F010231010131364141374503; (total 38 bytes);
16: len 4; hex 80000005; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794db51; asc Q;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 9 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000018a; asc ;;
1: len 6; hex 000000400b5b; asc @ [;;
2: len 7; hex 020000017c0f69; asc | i;;
3: len 6; hex 353435333443; asc 54534C;;
4: len 16; hex 46382d4d41585f49495f353435333443; asc F8-MAX_II_54534C;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323335333433353333333434333031; asc DD001C010231010235343533344301; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313335333433353333333434333033; asc DD000F010231010135343533344303; (total 38 bytes);
16: len 4; hex 80000006; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794db55; asc U;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 10 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000018b; asc ;;
1: len 6; hex 000000400b5c; asc @ \;;
2: len 7; hex 010000022004f7; asc ;;
3: len 6; hex 444630433633; asc DF0C63;;
4: len 16; hex 46382d4d41585f49495f444630433633; asc F8-MAX_II_DF0C63;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323434343633303433333633333031; asc DD001C010231010244463043363301; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313434343633303433333633333033; asc DD000F010231010144463043363303; (total 38 bytes);
16: len 4; hex 80000007; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794db58; asc X;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 11 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000018c; asc ;;
1: len 6; hex 000000400b6b; asc @ k;;
2: len 7; hex 01000001542396; asc T# ;;
3: len 6; hex 353037394134; asc 5079A4;;
4: len 16; hex 46382d4d41585f49495f353037394134; asc F8-MAX_II_5079A4;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323335333033373339343133343031; asc DD001C010231010235303739413401; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd50; asc P;;
15: len 30; hex 444430303046303130323331303130313335333033373339343133343033; asc DD000F010231010135303739413403; (total 38 bytes);
16: len 4; hex 80000008; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e80d; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 12 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000018d; asc ;;
1: len 6; hex 000000400b4a; asc @ J;;
2: len 7; hex 02000001621a99; asc b ;;
3: len 6; hex 313741464335; asc 17AFC5;;
4: len 16; hex 46382d4d41585f49495f313741464335; asc F8-MAX_II_17AFC5;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323331333734313436343333353031; asc DD001C010231010231374146433501; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313331333734313436343333353033; asc DD000F010231010131374146433503; (total 38 bytes);
16: len 4; hex 80000009; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e89c; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 13 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000018e; asc ;;
1: len 6; hex 000000400b60; asc @ `;;
2: len 7; hex 010000016818f9; asc h ;;
3: len 6; hex 304139354139; asc 0A95A9;;
4: len 16; hex 46382d4d41585f49495f304139354139; asc F8-MAX_II_0A95A9;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323330343133393335343133393031; asc DD001C010231010230413935413901; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313330343133393335343133393033; asc DD000F010231010130413935413903; (total 38 bytes);
16: len 4; hex 8000000a; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e89d; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 14 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000018f; asc ;;
1: len 6; hex 000000400b56; asc @ V;;
2: len 7; hex 010000012130c1; asc !0 ;;
3: len 6; hex 324439414138; asc 2D9AA8;;
4: len 16; hex 46382d4d41585f49495f324439414138; asc F8-MAX_II_2D9AA8;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323332343433393431343133383031; asc DD001C010231010232443941413801; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313332343433393431343133383033; asc DD000F010231010132443941413803; (total 38 bytes);
16: len 4; hex 8000000b; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e89f; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 15 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000190; asc ;;
1: len 6; hex 000000400b48; asc @ H;;
2: len 7; hex 010000011e3081; asc 0 ;;
3: len 6; hex 383133374244; asc 8137BD;;
4: len 16; hex 46382d4d41585f49495f383133374244; asc F8-MAX_II_8137BD;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323338333133333337343234343031; asc DD001C010231010238313337424401; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313338333133333337343234343033; asc DD000F010231010138313337424403; (total 38 bytes);
16: len 4; hex 8000000c; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e8a1; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 16 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000191; asc ;;
1: len 6; hex 000000400b55; asc @ U;;
2: len 7; hex 02000001ab2ab0; asc * ;;
3: len 6; hex 343638453946; asc 468E9F;;
4: len 16; hex 46382d4d41585f49495f343638453946; asc F8-MAX_II_468E9F;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323334333633383435333934363031; asc DD001C010231010234363845394601; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313334333633383435333934363033; asc DD000F010231010134363845394603; (total 38 bytes);
16: len 4; hex 8000000d; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e8a2; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 17 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000192; asc ;;
1: len 6; hex 000000400b59; asc @ Y;;
2: len 7; hex 0100000141290c; asc A) ;;
3: len 6; hex 363839333642; asc 68936B;;
4: len 16; hex 46382d4d41585f49495f363839333642; asc F8-MAX_II_68936B;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323336333833393333333634323031; asc DD001C010231010236383933364201; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313336333833393333333634323033; asc DD000F010231010136383933364203; (total 38 bytes);
16: len 4; hex 8000000e; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e8a5; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 18 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000193; asc ;;
1: len 6; hex 000000400b52; asc @ R;;
2: len 7; hex 02000001452167; asc E!g;;
3: len 6; hex 394232423541; asc 9B2B5A;;
4: len 16; hex 46382d4d41585f49495f394232423541; asc F8-MAX_II_9B2B5A;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323339343233323432333534313031; asc DD001C010231010239423242354101; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313339343233323432333534313033; asc DD000F010231010139423242354103; (total 38 bytes);
16: len 4; hex 8000000f; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e91b; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 19 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000194; asc ;;
1: len 6; hex 000000400b54; asc @ T;;
2: len 7; hex 010000016b1695; asc k ;;
3: len 6; hex 444636303936; asc DF6096;;
4: len 16; hex 46382d4d41585f49495f444636303936; asc F8-MAX_II_DF6096;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323434343633363330333933363031; asc DD001C010231010244463630393601; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4e; asc N;;
15: len 30; hex 444430303046303130323331303130313434343633363330333933363033; asc DD000F010231010144463630393603; (total 38 bytes);
16: len 4; hex 80000010; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e91c; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 20 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000196; asc ;;
1: len 6; hex 000000400b67; asc @ g;;
2: len 7; hex 010000013b2743; asc ;'C;;
3: len 6; hex 453738423137; asc E78B17;;
4: len 16; hex 46382d4d41585f49495f453738423137; asc F8-MAX_II_E78B17;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323435333733383432333133373031; asc DD001C010231010245373842313701; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd4f; asc O;;
15: len 30; hex 444430303046303130323331303130313435333733383432333133373033; asc DD000F010231010145373842313703; (total 38 bytes);
16: len 4; hex 80000012; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e920; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 21 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000197; asc ;;
1: len 6; hex 000000400b74; asc @ t;;
2: len 7; hex 010000020a0b21; asc !;;
3: len 6; hex 384330464130; asc 8C0FA0;;
4: len 16; hex 46382d4d41585f49495f384330464130; asc F8-MAX_II_8C0FA0;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323338343333303436343133303031; asc DD001C010231010238433046413001; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd53; asc S;;
15: len 30; hex 444430303046303130323331303130313338343333303436343133303033; asc DD000F010231010138433046413003; (total 38 bytes);
16: len 4; hex 80000011; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794e921; asc !;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 22 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 8000000000000198; asc ;;
1: len 6; hex 000000400b72; asc @ r;;
2: len 7; hex 02000001992fa8; asc / ;;
3: len 6; hex 394541444245; asc 9EADBE;;
4: len 16; hex 46382d4d41585f49495f394541444245; asc F8-MAX_II_9EADBE;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: len 0; hex ; asc ;;
10: len 30; hex 444430303143303130323331303130323339343534313434343234353031; asc DD001C010231010239454144424501; (total 64 bytes);
11: len 0; hex ; asc ;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd52; asc R;;
15: len 30; hex 444430303046303130323331303130313339343534313434343234353033; asc DD000F010231010139454144424503; (total 38 bytes);
16: len 4; hex 80000013; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b794f396; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 23 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000019a; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 01000002120c88; asc ;;
3: len 6; hex 434530324330; asc CE02C0;;
4: len 16; hex 58392d4d41585f42545f434530324330; asc X9-MAX_BT_CE02C0;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233303034; asc 0x01023004;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000002; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b794fe38; asc 8;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;
Record lock, heap no 24 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000019b; asc ;;
1: len 6; hex 000000400b44; asc @ D;;
2: len 7; hex 010000022503b5; asc % ;;
3: len 6; hex 424239334439; asc BB93D9;;
4: len 16; hex 46382d4d41585f49495f424239334439; asc F8-MAX_II_BB93D9;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323432343233393333343433393031; asc DD001C010231010242423933443901; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000000; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b7968e74; asc t;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b0; asc ;;
Record lock, heap no 25 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000019c; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 01000002120cbe; asc ;;
3: len 6; hex 333145314538; asc 31E1E8;;
4: len 12; hex 53315f42545f333145314538; asc S1_BT_31E1E8;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233363031; asc 0x01023601;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000003; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b7968e75; asc u;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;
Record lock, heap no 26 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000019d; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 01000002120cf4; asc ;;
3: len 6; hex 333043413930; asc 30CA90;;
4: len 16; hex 46382d4d41585f42545f333043413930; asc F8-MAX_BT_30CA90;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000004; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b7968e75; asc u;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;
Record lock, heap no 27 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 800000000000019e; asc ;;
1: len 6; hex 0000003ffac8; asc ? ;;
2: len 7; hex 02000001912ac9; asc * ;;
3: len 6; hex 303637344130; asc 0674A0;;
4: len 16; hex 46382d4d41585f49495f303637344130; asc F8-MAX_II_0674A0;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 7; hex 494e495449414c; asc INITIAL;;
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000005; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b7968e75; asc u;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;
Record lock, heap no 28 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001b7; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 01000002120d60; asc `;;
3: len 6; hex 343137443143; asc 417D1C;;
4: len 12; hex 58392d39365f343137443143; asc X9-96_417D1C;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233303032; asc 0x01023002;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000006; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b798a79e; asc ;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;
Record lock, heap no 29 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001b8; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 01000002120d96; asc ;;
3: len 6; hex 453335443234; asc E35D24;;
4: len 12; hex 53315f42545f453335443234; asc S1_BT_E35D24;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233363031; asc 0x01023601;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000007; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b798a7a3; asc ;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;
Record lock, heap no 30 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001b9; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 01000002120dcc; asc ;;
3: len 6; hex 454130363543; asc EA065C;;
4: len 16; hex 46382d50524f5f42545f454130363543; asc F8-PRO_BT_EA065C;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313032; asc 0x01023102;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000008; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b798a7a3; asc ;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;
Record lock, heap no 31 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001ba; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 81000000d30110; asc ;;
3: len 6; hex 313836364230; asc 1866B0;;
4: len 10; hex 4844505f313836364230; asc HDP_1866B0;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303330323034; asc 0x01030204;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000009; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b798a7b1; asc ;;
25: SQL NULL;
26: SQL NULL;
Record lock, heap no 32 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001bd; asc ;;
1: len 6; hex 0000003fbd11; asc ? ;;
2: len 7; hex 010000023e1532; asc > 2;;
3: len 6; hex 333933433638; asc 393C68;;
4: len 12; hex 55315f42545f333933433638; asc U1_BT_393C68;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233383031; asc 0x01023801;;
9: len 0; hex ; asc ;;
10: len 0; hex ; asc ;;
11: len 0; hex ; asc ;;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000014; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b798b997; asc ;;
25: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
26: len 5; hex 99b798be07; asc ;;
Record lock, heap no 33 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001be; asc ;;
1: len 6; hex 0000003fbd11; asc ? ;;
2: len 7; hex 81000000c00110; asc ;;
3: len 6; hex 343137443143; asc 417D1C;;
4: len 12; hex 58392d39365f343137443143; asc X9-96_417D1C;;
5: len 13; hex 31373537363439333636303034; asc 1757649366004;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233303032; asc 0x01023002;;
9: len 0; hex ; asc ;;
10: len 0; hex ; asc ;;
11: len 0; hex ; asc ;;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000015; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6878586a66487a4b; asc hxXjfHzK;;
22: len 8; hex 8000000000013695; asc 6 ;;
23: len 17; hex 313432373938383335354071712e636f6d; asc 1427988355@qq.com;;
24: len 5; hex 99b798be07; asc ;;
25: SQL NULL;
26: SQL NULL;
Record lock, heap no 34 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001bf; asc ;;
1: len 6; hex 000000400bc4; asc @ ;;
2: len 7; hex 010000015026b1; asc P& ;;
3: len 6; hex 354434314239; asc 5D41B9;;
4: len 16; hex 46382d4d41585f49495f354434314239; asc F8-MAX_II_5D41B9;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323335343433343331343233393031; asc DD001C010231010235443431423901; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd60; asc `;;
15: len 30; hex 444430303046303130323331303130313335343433343331343233393033; asc DD000F010231010135443431423903; (total 38 bytes);
16: len 4; hex 80000000; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4a2; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 35 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c0; asc ;;
1: len 6; hex 000000400bc6; asc @ ;;
2: len 7; hex 02000001200ae1; asc ;;
3: len 6; hex 334539453646; asc 3E9E6F;;
4: len 16; hex 46382d4d41585f49495f334539453646; asc F8-MAX_II_3E9E6F;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323333343533393435333634363031; asc DD001C010231010233453945364601; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd70; asc p;;
15: len 30; hex 444430303046303130323331303130313333343533393435333634363033; asc DD000F010231010133453945364603; (total 38 bytes);
16: len 4; hex 80000001; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4a6; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 36 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c1; asc ;;
1: len 6; hex 000000400bb8; asc @ ;;
2: len 7; hex 01000002050be4; asc ;;
3: len 6; hex 444431453245; asc DD1E2E;;
4: len 16; hex 46382d4d41585f49495f444431453245; asc F8-MAX_II_DD1E2E;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323434343433313435333234353031; asc DD001C010231010244443145324501; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd5e; asc ^;;
15: len 30; hex 444430303046303130323331303130313434343433313435333234353033; asc DD000F010231010144443145324503; (total 38 bytes);
16: len 4; hex 80000002; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4a6; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 37 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c2; asc ;;
1: len 6; hex 000000400bc3; asc @ ;;
2: len 7; hex 02000001360395; asc 6 ;;
3: len 6; hex 464635354345; asc FF55CE;;
4: len 16; hex 46382d4d41585f49495f464635354345; asc F8-MAX_II_FF55CE;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323436343633353335343334353031; asc DD001C010231010246463535434501; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd60; asc `;;
15: len 30; hex 444430303046303130323331303130313436343633353335343334353033; asc DD000F010231010146463535434503; (total 38 bytes);
16: len 4; hex 80000003; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4bb; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 38 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c3; asc ;;
1: len 6; hex 000000400b8f; asc @ ;;
2: len 7; hex 010000021f05d9; asc ;;
3: len 6; hex 393234303937; asc 924097;;
4: len 16; hex 46382d4d41585f49495f393234303937; asc F8-MAX_II_924097;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323339333233343330333933373031; asc DD001C010231010239323430393701; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd60; asc `;;
15: len 30; hex 444430303046303130323331303130313339333233343330333933373033; asc DD000F010231010139323430393703; (total 38 bytes);
16: len 4; hex 80000004; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4bb; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 39 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c4; asc ;;
1: len 6; hex 000000400bc2; asc @ ;;
2: len 7; hex 010000022104f7; asc ! ;;
3: len 6; hex 304433453345; asc 0D3E3E;;
4: len 16; hex 46382d4d41585f49495f304433453345; asc F8-MAX_II_0D3E3E;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323330343433333435333334353031; asc DD001C010231010230443345334501; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd60; asc `;;
15: len 30; hex 444430303046303130323331303130313330343433333435333334353033; asc DD000F010231010130443345334503; (total 38 bytes);
16: len 4; hex 80000005; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4cb; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 40 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c5; asc ;;
1: len 6; hex 000000400bab; asc @ ;;
2: len 7; hex 010000015f1a21; asc _ !;;
3: len 6; hex 393537374130; asc 9577A0;;
4: len 16; hex 46382d4d41585f49495f393537374130; asc F8-MAX_II_9577A0;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323339333533373337343133303031; asc DD001C010231010239353737413001; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd61; asc a;;
15: len 30; hex 444430303046303130323331303130313339333533373337343133303033; asc DD000F010231010139353737413003; (total 38 bytes);
16: len 4; hex 80000006; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4ce; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 41 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c6; asc ;;
1: len 6; hex 000000400bb4; asc @ ;;
2: len 7; hex 01000001651b7b; asc e {;;
3: len 6; hex 384638454446; asc 8F8EDF;;
4: len 16; hex 46382d4d41585f49495f384638454446; asc F8-MAX_II_8F8EDF;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323338343633383435343434363031; asc DD001C010231010238463845444601; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd5e; asc ^;;
15: len 30; hex 444430303046303130323331303130313338343633383435343434363033; asc DD000F010231010138463845444603; (total 38 bytes);
16: len 4; hex 80000007; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4d1; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 42 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c8; asc ;;
1: len 6; hex 000000400bbd; asc @ ;;
2: len 7; hex 02000001130d06; asc ;;
3: len 6; hex 343132353038; asc 412508;;
4: len 16; hex 46382d4d41585f49495f343132353038; asc F8-MAX_II_412508;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323334333133323335333033383031; asc DD001C010231010234313235303801; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd61; asc a;;
15: len 30; hex 444430303046303130323331303130313334333133323335333033383033; asc DD000F010231010134313235303803; (total 38 bytes);
16: len 4; hex 80000009; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4d8; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 43 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001c9; asc ;;
1: len 6; hex 000000400bba; asc @ ;;
2: len 7; hex 020000017820a6; asc x ;;
3: len 6; hex 384638363336; asc 8F8636;;
4: len 16; hex 46382d4d41585f49495f384638363336; asc F8-MAX_II_8F8636;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323338343633383336333333363031; asc DD001C010231010238463836333601; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd5e; asc ^;;
15: len 30; hex 444430303046303130323331303130313338343633383336333333363033; asc DD000F010231010138463836333603; (total 38 bytes);
16: len 4; hex 8000000a; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4db; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 44 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001ca; asc ;;
1: len 6; hex 000000400bcb; asc @ ;;
2: len 7; hex 0200000125095f; asc % _;;
3: len 6; hex 343945454539; asc 49EEE9;;
4: len 16; hex 46382d4d41585f49495f343945454539; asc F8-MAX_II_49EEE9;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323334333934353435343533393031; asc DD001C010231010234394545453901; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd70; asc p;;
15: len 30; hex 444430303046303130323331303130313334333934353435343533393033; asc DD000F010231010134394545453903; (total 38 bytes);
16: len 4; hex 8000000b; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4de; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 45 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001cb; asc ;;
1: len 6; hex 000000400bb2; asc @ ;;
2: len 7; hex 020000017e1d21; asc ~ !;;
3: len 6; hex 423736343130; asc B76410;;
4: len 16; hex 46382d4d41585f49495f423736343130; asc F8-MAX_II_B76410;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 444430303143303130323331303130323432333733363334333133303031; asc DD001C010231010242373634313001; (total 64 bytes);
11: SQL NULL;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000001; asc ;;
14: len 5; hex 99b798fd5f; asc _;;
15: len 30; hex 444430303046303130323331303130313432333733363334333133303033; asc DD000F010231010142373634313003; (total 38 bytes);
16: len 4; hex 8000000c; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 6c745438676c524d; asc ltT8glRM;;
22: len 8; hex 800000000000006a; asc j;;
23: len 9; hex e69e97e6b5b7e9b98f; asc ;;
24: len 5; hex 99b798e4e1; asc ;;
25: len 9; hex e69e97e6b5b7e9b98f; asc ;;
26: len 5; hex 99b798e4f9; asc ;;
Record lock, heap no 46 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
0: len 8; hex 80000000000001cc; asc ;;
1: len 6; hex 000000400bb6; asc @ ;;
2: len 7; hex 020000019b2d5c; asc -\;;
3: len 6; hex 364231323134; asc 6B1214;;
4: len 16; hex 46382d4d41585f49495f364231323134; asc F8-MAX_II_6B1214;;
5: len 13; hex 31373537363537393937313131; asc 1757657997111;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233313031; asc 0x01023101;;
9: SQL NULL;
10: len 30; hex 44443030314330313032333.2 分析死锁
3.2.1 事务 1 信息
- TRANSACTION 4197328：此事务 id
- ACTIVE 0 sec：活跃时间 0 秒
- fetching rows：表示事务状态在 row_search_for_mysql 中被设置，表示正在查找记录
- mysql tables in use 1, locked 1：此事务修改了一个表，锁了一行数据
------------------------
LATEST DETECTED DEADLOCK
------------------------
2025-09-12 15:53:48 22763061405248
*** (1) TRANSACTION:
TRANSACTION 4197328, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 99 row lock(s), undo log entries 2
MySQL thread id 2984, OS thread handle 22762927093312, query id 1759528 8.155.33.36 root updating
UPDATE zet_device d
SET d.ipaddress = '219.136.131.153',
d.nation = '中国',
d.province = '广东省',
d.city = '广州市'
WHERE d.device_identifier = 'E5FC08'3.2.2 事务 1 持有的锁
- RECORD LOCKS：表示持有的是行级锁
- index PRIMARY：表示锁的是主键索引
- table
zetlight-test.zet_device，表示锁的具体是哪个表 - trx id 10298：事务 id，和上面的 TRANSACTION 相同。
- lock_mode X ，锁模式：排它锁。（X：排他锁，S：共享锁）
*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 33 page no 5 n bits 128 index PRIMARY of table `zetlight-test`.`zet_device` trx id 4197328 lock_mode X
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 27; compact format; info bits 0
0: len 8; hex 800000000000017f; asc ;;
1: len 6; hex 0000003fa1b7; asc ? ;;
2: len 7; hex 01000002120c52; asc R;;
3: len 6; hex 333933433638; asc 393C68;;
4: len 12; hex 55315f42545f333933433638; asc U1_BT_393C68;;
5: len 13; hex 31373537363434323437383939; asc 1757644247899;;
6: len 1; hex 32; asc 2;;
7: len 7; hex 23464638303030; asc #FF8000;;
8: len 10; hex 30783031303233383031; asc 0x01023801;;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: SQL NULL;
15: SQL NULL;
16: len 4; hex 80000001; asc ;;
17: len 15; hex 3231392e3133362e3133312e313533; asc 219.136.131.153;;
18: len 6; hex e4b8ade59bbd; asc ;;
19: len 9; hex e5b9bfe4b89ce79c81; asc ;;
20: len 9; hex e5b9bfe5b79ee5b882; asc ;;
21: len 8; hex 343136596f657343; asc 416YoesC;;
22: len 8; hex 8000000000015d05; asc ] ;;
23: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
24: len 5; hex 99b7948ae4; asc ;;
25: len 16; hex 3732333637363237384071712e636f6d; asc 723676278@qq.com;;
26: len 5; hex 99b798a7b1; asc ;;3.2.3 奇怪的点
死锁日志里面只有一个事务，但是持有很多行锁，也不显示等待的锁
再次查看关联的 sql 语句：
UPDATE zet_device d
SET d.ipaddress = '219.136.131.153',
d.nation = '中国',
d.province = '广东省',
d.city = '广州市'
WHERE d.device_identifier = 'E5FC08'在到网上查，普通的 update 修改语句是加什么锁？
回答：如果 where 列不是索引列的话加表锁，是索引列加行锁，目前判断是加了表锁（但是为什么日志里面显示的是行锁哩？），导致后台想要更新起的设备数据产生冲突，出现死锁
3.3 解决死锁
- 解决方案：将 device_identifier 添加为索引列
ALTER TABLE zetlight-test ADD INDEX index_name (device_identifier);3.4 预防死锁
以下是网上总结的预防死锁的经验：
- 缩短事务长度
- 同意加锁顺序，打破循环等待
- 减速锁粒度，用行锁
版权所有
版权归属：haipeng-lin