在现代企业中，数据库是业务的核心，而MySQL作为全球最受欢迎的关系型数据库之一，承载着大量的关键业务数据。然而，MySQL死锁问题一直是开发和运维团队面临的挑战之一。死锁会导致数据库性能下降、事务回滚甚至服务中断，直接影响用户体验和业务连续性。本文将深入探讨MySQL死锁的原因、排查方法以及高效的解决策略，帮助企业更好地应对这一问题。

什么是MySQL死锁？

MySQL死锁（Deadlock）是指两个或多个事务在访问共享资源时发生相互等待，导致所有相关事务都无法继续执行的情况。简单来说，当两个事务同时请求相同的资源，但资源分配顺序不一致时，就会导致死锁。

例如，事务A持有锁X，事务B持有锁Y，而事务A需要锁Y，事务B需要锁X。由于两个事务都在等待对方释放锁，最终导致双方都无法继续执行，这就是典型的死锁场景。

为什么会发生MySQL死锁？

MySQL死锁的产生通常与以下因素有关：

1. 事务隔离级别事务隔离级别越高，死锁的可能性越大。例如，Serializable隔离级别会严格控制并发访问，但容易导致死锁。

2. 锁竞争当多个事务同时对同一资源加锁时，锁竞争不可避免。如果锁的粒度过细或锁的持有时间过长，死锁的风险会显著增加。

3. 不合理的事务设计事务范围过大或事务中包含复杂的查询操作，会导致锁的范围和时间超出必要，增加死锁的可能性。

4. 并发控制不当如果没有合理的并发控制策略，多个事务可能同时对同一资源加锁，导致死锁。

5. 数据库设计问题数据库表结构设计不合理，索引使用不当，也可能导致死锁。例如，索引缺失会导致全表扫描，增加锁竞争。

如何排查MySQL死锁？

排查MySQL死锁需要从以下几个方面入手：

1. 查看错误日志

MySQL会在错误日志中记录死锁的相关信息。通过查看错误日志，可以快速定位死锁发生的时间、涉及的事务以及具体的锁状态。

# 在MySQL错误日志中查找类似以下信息：2023-10-01 12:34:56 UTC[thread1][ERROR][ mysqld: ] InnoDB: Deadlock found when trying to get lock;   55 lock struct(s), heap size 11264, 55 lock struct(s) waiting for lock

2. 使用SHOW ENGINE INNODB STATUS

SHOW ENGINE INNODB STATUS是一个强大的工具，可以查看InnoDB存储引擎的详细状态，包括死锁信息。

SHOW ENGINE INNODB STATUS;

在输出结果中，查找Deadlock相关的部分：

------------------------LATEST DEADLOCK IN:------------------------*** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s)RECORD LOCKS SPACE: 0 page 293, 1 record(s