在数据库系统中，InnoDB存储引擎以其高并发处理能力和事务支持而闻名。然而，随着数据库负载的增加，InnoDB死锁问题也变得日益常见。死锁不仅会导致事务回滚，还可能引发数据库性能下降，甚至影响整个系统的稳定性。对于数据中台、数字孪生和数字可视化等应用场景，数据库的稳定性和性能至关重要。因此，掌握InnoDB死锁的排查和优化技巧，是每一位数据库管理员和开发人员的必修课。

本文将深入探讨InnoDB死锁的原因、日志分析方法以及优化技巧，帮助您快速定位问题并提升数据库性能。

一、InnoDB死锁是什么？

InnoDB存储引擎支持事务，并且默认使用两阶段 locking协议（2PL）来保证事务的隔离性。然而，在高并发场景下，多个事务可能会竞争同一资源，导致死锁的发生。

死锁的定义：当两个或多个事务彼此等待对方释放资源，导致无法继续执行时，就形成了死锁。这种情况下，数据库系统通常会自动选择一个事务进行回滚，以释放被占用的资源。

死锁的特征

1. 事务等待资源：每个事务都在等待其他事务释放资源。
2. 循环依赖：事务之间形成了一个资源等待的循环链。
3. 系统无法自动解除：如果没有外部干预，死锁将无限期持续。

二、InnoDB死锁的原因

InnoDB死锁通常由以下几种原因引起：

1. 事务设计不合理

• 长事务：事务执行时间过长，导致其他事务等待。
• 事务粒度过粗：锁定范围过大，增加了死锁的可能性。

2. 并发控制不当

• 锁竞争：多个事务同时锁定同一资源，导致资源争用。
• 未使用索引：查询未使用索引，导致全表扫描，增加锁竞争。

3. 数据库设计问题

• 表结构不合理：索引设计不合理，导致查询效率低下。
• 约束不足：缺乏适当的约束条件，导致数据不一致。

4. 日志配置不当

• 日志文件过小：日志文件过小会导致频繁的刷盘操作，增加锁竞争。
• 日志缓冲区不足：缓冲区过小会导致日志写入变慢，增加事务等待时间。

三、InnoDB死锁的日志分析

InnoDB会在错误日志中记录死锁的相关信息，通过分析这些日志，可以快速定位问题。

1. 日志定位

InnoDB死锁日志通常包含以下信息：

• 事务ID：发生死锁的事务ID。
• 资源信息：被锁定的资源（如行、锁模式等）。
• 等待关系：事务之间的等待关系。

示例日志：

2023-10-01 12:34:56 UTC 10 [Note] InnoDB: LATEST DETECTED DEADLOCK (0000000012):_mysql_id=12345, db_id=0, trx_id=123456789, trx_state=RUNNING, trx_started=1234567890, trx_requested_lock_id=0, trx_wait_age=123456, trx_wait_for_lock=0, lock_id=1234567890, lock_mode=EXCLUSIVE, lock_type=RECORD, lock_subtype=0, lock_table=table1, lock_row=12345, lock_pos=1234567890, lock_holders=0, lock_waiters=1, lock_request_type=0, lock_is Granted=0, lock_chain=0, lock_chain_len=1, lock_chain_trx_ids=0, lock_chain_trx_ids_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_trx_ids_str=0, lock_chain_trx_ids_str_len=0, lock_chain_tr