死锁日志
分析已备注在日志中了
=====================================
2022-12-09 10:22:13 0x7fcb5ddfb700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 60 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 510419 srv_active, 0 srv_shutdown, 1525200 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 631397
OS WAIT ARRAY INFO: signal count 621687
RW-shared spins 3589, rounds 4389, OS waits 867
RW-excl spins 3072, rounds 61777, OS waits 1369
RW-sx spins 184, rounds 4006, OS waits 98
Spin rounds per wait: 1.22 RW-shared, 20.11 RW-excl, 21.77 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2022-12-09 09:40:00 0x7fcb941aa700
# 事务1的信息
*** (1) TRANSACTION:
# TRANSACTION 7263457 当前事务id
# ACTIVE 0 sec 事务活动时间0秒
# inserting
# inserting 位置还会有其它的几种情况
# 1、starting index read 事务当前正在根据索引读取数据
# 2、fetching rows 表示事务状态在row_search_for_mysql中被设置，表示正在查找记录
# 3、inserting or updating or deleting 表示事务已经真正进入了Insert/Update/delete的函数逻辑（row_update_for_mysql）
# 4、thread declared inside InnoDB 说明事务已经进入innodb层。通常而言 不在innodb层的事务大部分是会被回滚的
TRANSACTION 7263457, ACTIVE 0 sec inserting
# mysql tables in use 1 表示有1个表被占用
# locked 1 有一个表锁
mysql tables in use 1, locked 1
# LOCK WAIT 事务正在等待锁
# 4 lock struct(s) 事务的锁链表的长度为4，每个链表节点代表事务持有的一个锁结构，包括表锁、记录锁、AUTO-INC锁等
# heap size 1136 为事务分配的锁堆内存大小
# 2 row lock(s) 当前事务持有的行锁个数为2个，通过遍历上面提到的4个锁结构，找出其中类型为 LOCK_REC 的记录数
LOCK WAIT 4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2
# MySQL thread id 1718 mysql线程id
# query id 20195790 查询id
# localhost 127.0.0.1 root update root@localhost执行的update操作
MySQL thread id 1718, OS thread handle 140511416137472, query id 20195790 localhost 127.0.0.1 root update
# 正在执行的sql语句，即正在等待锁的语句，处理阻塞状态
insert into tx_nodeinstance (c_agent, c_alias, c_desc, c_endtime, c_instanceid, c_log, c_name, c_outputs, c_starttime, c_state, c_type, c_id) values ('localhost.localdomain:8899', '关系目标表(覆盖)', NULL, NULL, 'Iff8080810184e0f3e0f36a120184f48a122b0be0', 'startDate=20221209', 'JDBC_DATATARGER_OVERWRITE', '{\"code\":200,\"message\":\"OK\",\"outputs\":[{\"order\":0,\"dataType\":\"DATASET\",\"values\":[{\"dataFormat\":\"csv\",\"configs\":{\"columns\":[{\"name\":\"RSAID\",\"alias\":\"销售单ID\",\"dataType\":\"long\"},{\"name\":\"CREDATE\",\"alias\":\"业务日期\",\"dataType\":\"timestamp\"},{\"name\":\"USEDAY\",\"alias\":\"逻辑日期\",\"dataType\":\"timestamp\"},{\"name\":\"PLACEPOINTID\",\"alias\":\"门店ID\",\"dataType\":\"long\"},{\"name\":\"CASHIERID\",\"alias\":\"收银员ID\",\"dataType\":\"long\"},{\"name\":\"INSIDERID\",\"alias\":\"INSIDERID\",\"dataType\":\"long\"},{\"name\":\"CNCA
# 当前事务正在等待的锁
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
# RECORD LOCKS 事务正在等待的锁为记录锁
# space id 1177 表空间号为 1177
# page no 1586 数据页的页号为 1586
# n bits 112 对于行锁来说，一条记录就对应着一个比特位，一个页面中包含很多记录，用不同的比特位来区分到底是哪一条记录加了锁。为此在行锁结构的末尾放置了一堆比特位，这个n_bits属性代表使用了多少比特位
# index PRIMARY 加锁对象是主键
# table `smartbi`.`tx_nodeinstance` 锁的是smartbi库的tx_nodeinstance表
# trx id 7263457 事务id，与上面的 TRANSACTION 7263457 一致
# lock_mode X 加锁模式：排他锁
# 加锁模式类型
# 1、X 排他锁
# 2、S 共享锁
# locks gap before rec insert intention
# 可能性
# 1、locks rec but not gap 记录(行)锁（LOCK_REC_NOT_GAP）
# 2、locks gap before rec 间隙锁（LOCK_GAP）
# 3、 临键锁（LOCK_ORNIDARY）
# 4、locks gap before rec insert intention 插入意向锁（LOCK_INSERT_INTENTION）
# supremum记录上的锁的特殊性
# 1、记录锁 - locks rec but not gap
# 2、间隙锁 -
# 3、邻键锁（Next-key锁） -
# 4、插入意向锁 - insert intention
# waiting 事务正在等待
RECORD LOCKS space id 1177 page no 1586 n bits 112 index PRIMARY of table `smartbi`.`tx_nodeinstance` trx id 7263457 lock_mode X locks gap before rec insert intention waiting
# Record lock 记录锁
# n_fields 14 记录有14列，靠前的是索引信息
Record lock, heap no 17 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
# 0~13 表示等待的行，
# len 30; asc最多显示字节，这里是30个
# hex 313437363564353164346639386435633834376463363438633230616438; 主键id
# asc 14765d51d4f98d5c847dc648c20ad8; 具体值，如果是整形则会显示空
# (total 74 bytes); 实际长度
0: len 30; hex 313437363564353164346639386435633834376463363438633230616438; asc 14765d51d4f98d5c847dc648c20ad8; (total 74 bytes);
1: len 6; hex 00000033b431; asc 3 1;;
2: len 7; hex 81000002060fe8; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae197e21; asc ~!;;
7: len 30; hex 496666383038303831303138336262633762626337656337313031383363; asc Iff8080810183bbc7bbc7ec710183c; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231303132; asc startDate=20221012;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 30; hex 7b22636f6465223a3530302c226d657373616765223a22e58685e983a8e6; asc {"code":500,"message":" ; (total 68 bytes);
11: len 5; hex 99ae197e21; asc ~!;;
12: len 4; hex 4641494c; asc FAIL;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
*** (2) TRANSACTION:
TRANSACTION 7263455, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 1
1160 lock struct(s), heap size 123088, 7987 row lock(s)
MySQL thread id 1727, OS thread handle 140512339863296, query id 20195763 localhost 127.0.0.1 root updating
delete from tx_nodeinstance where c_instanceid='Iff8080810184e0f3e0f36a120184f2a4d7510aab'
# 持有的锁
*** (2) HOLDS THE LOCK(S):
# index PRIMARY 锁的对象是主键
# lock_mode X 持有一个临键锁
RECORD LOCKS space id 1177 page no 1586 n bits 112 index PRIMARY of table `smartbi`.`tx_nodeinstance` trx id 7263455 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 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006de9d6; asc m ;;
2: len 7; hex 02000000b1219f; asc ! ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae912519; asc % ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000848000000010000000000001fbd; asc H ;;
11: len 5; hex 99ae912518; asc % ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 3 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006df274; asc m t;;
2: len 7; hex 02000001b206f3; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae91301a; asc 0 ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000851000000010000000000001fbd; asc Q ;;
11: len 5; hex 99ae913019; asc 0 ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 4 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006dfb40; asc m @;;
2: len 7; hex 010000019c30f4; asc 0 ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae913a18; asc : ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000857000000010000000000001fbd; asc W ;;
11: len 5; hex 99ae913a18; asc : ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 5 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e0402; asc n ;;
2: len 7; hex 02000001511927; asc Q ';;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae91451c; asc E ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000847000000010000000000001fbd; asc G ;;
11: len 5; hex 99ae91451b; asc E ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 6 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e08b8; asc n ;;
2: len 7; hex 01000000e90151; asc Q;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae914a1a; asc J ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000861000000010000000000001fbd; asc a ;;
11: len 5; hex 99ae914a19; asc J ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 7 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e1921; asc n !;;
2: len 7; hex 02000002150f2e; asc .;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae91601a; asc ` ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 000004990000086b000000010000000000001fbd; asc k ;;
11: len 5; hex 99ae91601a; asc ` ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 8 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e1e0c; asc n ;;
2: len 7; hex 01000001ff28a3; asc ( ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae91651a; asc e ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 000004990000086e000000010000000000001fbd; asc n ;;
11: len 5; hex 99ae916519; asc e ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 9 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e270c; asc n' ;;
2: len 7; hex 01000002360151; asc 6 Q;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae91701f; asc p ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000876000000010000000000001fbd; asc v ;;
11: len 5; hex 99ae91701e; asc p ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 10 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e300e; asc n0 ;;
2: len 7; hex 02000001d60d98; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae917a1c; asc z ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323038; asc startDate=20221208;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000875000000010000000000001fbd; asc u ;;
11: len 5; hex 99ae917a1b; asc z ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 11 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e34a9; asc n4 ;;
2: len 7; hex 020000022c1d5f; asc , _;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae920019; asc ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000c43000000010000000000001fb9; asc C ;;
11: len 5; hex 99ae920018; asc ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 12 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e3d82; asc n= ;;
2: len 7; hex 01000000e51ccd; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae920a19; asc ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000c44000000010000000000001fb9; asc D ;;
11: len 5; hex 99ae920a19; asc ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 13 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e4280; asc nB ;;
2: len 7; hex 02000001da155b; asc [;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae921019; asc ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000c54000000010000000000001fb9; asc T ;;
11: len 5; hex 99ae921019; asc ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 14 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e4c6a; asc nLj;;
2: len 7; hex 010000015602cd; asc V ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae92151f; asc ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000c5f000000010000000000001fb9; asc _ ;;
11: len 5; hex 99ae92151a; asc ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 15 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e5c52; asc n\R;;
2: len 7; hex 010000016e069d; asc n ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae921dda; asc ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000c67000000010000000000001fb9; asc g ;;
11: len 5; hex 99ae921dda; asc ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 16 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e62e2; asc nb ;;
2: len 7; hex 01000001a82d44; asc -D;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae922519; asc % ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000c6a000000010000000000001fb9; asc j ;;
11: len 5; hex 99ae922518; asc % ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 17 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313437363564353164346639386435633834376463363438633230616438; asc 14765d51d4f98d5c847dc648c20ad8; (total 74 bytes);
1: len 6; hex 00000033b431; asc 3 1;;
2: len 7; hex 81000002060fe8; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae197e21; asc ~!;;
7: len 30; hex 496666383038303831303138336262633762626337656337313031383363; asc Iff8080810183bbc7bbc7ec710183c; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231303132; asc startDate=20221012;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 30; hex 7b22636f6465223a3530302c226d657373616765223a22e58685e983a8e6; asc {"code":500,"message":" ; (total 68 bytes);
11: len 5; hex 99ae197e21; asc ~!;;
12: len 4; hex 4641494c; asc FAIL;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 19 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e7032; asc np2;;
2: len 7; hex 02000001d22723; asc '#;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae92301b; asc 0 ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000c74000000010000000000001fb9; asc t ;;
11: len 5; hex 99ae923019; asc 0 ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 21 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e7589; asc nu ;;
2: len 7; hex 01000001601bdb; asc ` ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae923518; asc 5 ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000f8c000000010000000000001fb9; asc ;;
11: len 5; hex 99ae923518; asc 5 ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 23 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e7855; asc nxU;;
2: len 7; hex 01000000bb0546; asc F;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae92379b; asc 7 ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000f8f000000010000000000001fb9; asc ;;
11: len 5; hex 99ae92379b; asc 7 ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 25 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e7aa2; asc nz ;;
2: len 7; hex 02000000c82cb9; asc , ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae923a1a; asc : ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000f93000000010000000000001fb9; asc ;;
11: len 5; hex 99ae923a18; asc : ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 27 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e7f73; asc n s;;
2: len 7; hex 010000013202b4; asc 2 ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae92401a; asc @ ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000f95000000010000000000001fb9; asc ;;
11: len 5; hex 99ae92401a; asc @ ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 29 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e86a8; asc n ;;
2: len 7; hex 01000001983035; asc 05;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae924853; asc HS;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000f9d000000010000000000001fb9; asc ;;
11: len 5; hex 99ae924852; asc HR;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 31 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006e8e9c; asc n ;;
2: len 7; hex 02000001b50679; asc y;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae925019; asc P ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000fa4000000010000000000001fb9; asc ;;
11: len 5; hex 99ae925019; asc P ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 33 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006ea08b; asc n ;;
2: len 7; hex 02000001901bea; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae92601e; asc ` ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000fb7000000010000000000001fb9; asc ;;
11: len 5; hex 99ae92601c; asc ` ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 35 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006ea6bd; asc n ;;
2: len 7; hex 02000001bc151a; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae92651a; asc e ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 0000049900000fbd000000010000000000001fb9; asc ;;
11: len 5; hex 99ae926519; asc e ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 37 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006eacbb; asc n ;;
2: len 7; hex 0200000208060e; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae926a1a; asc j ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 000004990000080a000000010000000000001fb9; asc ;;
11: len 5; hex 99ae926a19; asc j ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 39 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006eb1db; asc n ;;
2: len 7; hex 02000002022888; asc ( ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae92701a; asc p ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 000004990000080f000000010000000000001fb9; asc ;;
11: len 5; hex 99ae92701a; asc p ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 41 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006ebae1; asc n ;;
2: len 7; hex 01000001d42ef4; asc . ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae927a19; asc z ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 000004990000082d000000010000000000001fba; asc - ;;
11: len 5; hex 99ae927a18; asc z ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 43 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006ebf81; asc n ;;
2: len 7; hex 02000001c00463; asc c;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae928019; asc ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 00000499000004c4000000010000000000001fbb; asc ;;
11: len 5; hex 99ae928018; asc ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
Record lock, heap no 45 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 313430393831306666363866323835613535323339313833343833336564; asc 1409810ff68f285a552391834833ed; (total 74 bytes);
1: len 6; hex 0000006ecc3f; asc n ?;;
2: len 7; hex 010000022c08cb; asc , ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 23; hex e585b3e7b3bbe79baee6a087e8a1a828e8a686e79b9629; asc ( );;
5: SQL NULL;
6: len 5; hex 99ae92901a; asc ;;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
10: len 20; hex 00000499000004d0000000010000000000001fbc; asc ;;
11: len 5; hex 99ae92901a; asc ;;
12: len 6; hex 46494e495348; asc FINISH;;
13: len 25; hex 4a4442435f444154415441524745525f4f5645525752495445; asc JDBC_DATATARGER_OVERWRITE;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1177 page no 1229 n bits 128 index PRIMARY of table `smartbi`.`tx_nodeinstance` trx id 7263455 lock_mode X waiting
Record lock, heap no 56 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 30; hex 613366303530636264323064656339653662393433366166636232396637; asc a3f050cbd20dec9e6b9436afcb29f7; (total 74 bytes);
1: len 6; hex 0000006ed4e1; asc n ;;
2: len 7; hex 82000000960183; asc ;;
3: len 26; hex 6c6f63616c686f73742e6c6f63616c646f6d61696e3a38383939; asc localhost.localdomain:8899;;
4: len 15; hex e585b3e7b3bbe695b0e68daee6ba90; asc ;;
5: SQL NULL;
6: SQL NULL;
7: len 30; hex 496666383038303831303138346530663365306633366131323031383466; asc Iff8080810184e0f3e0f36a120184f; (total 41 bytes);
8: len 18; hex 7374617274446174653d3230323231323039; asc startDate=20221209;;
9: len 15; hex 4a4442435f44415441534f55524345; asc JDBC_DATASOURCE;;
10: len 20; hex 00000499000004d5000000010000000000001fe4; asc ;;
11: len 5; hex 99ae929a00; asc ;;
12: len 6; hex 494e49544544; asc INITED;;
13: len 15; hex 4a4442435f44415441534f55524345; asc JDBC_DATASOURCE;;
# 回滚了事务1进行解除死锁
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 7265915
Purge done for trx's n:o < 7265914 undo n:o < 0 state: running but idle
History list length 10
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421987466081232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466080368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466079504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466078640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466077776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466076912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466076048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466075184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466074320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466073456, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466072592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466071728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466070864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466070000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466069136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466068272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466067408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466066544, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466065680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466064816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466063952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466063088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466062224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466061360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466059632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466058768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466057904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466057040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466056176, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466055312, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466054448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466053584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466052720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466051856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466050992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466050128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466060496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421987466049264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 2
986038 OS file reads, 8686306 OS file writes, 5752562 OS fsyncs
0.13 reads/s, 16384 avg bytes/read, 6.55 writes/s, 3.65 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 11, seg size 13, 2283 merges
merged operations:
insert 6020, delete mark 1139, delete 841
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 2 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 36 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
1.50 hash searches/s, 1.87 non-hash searches/s
---
LOG
---
Log sequence number 6088790810
Log buffer assigned up to 6088790810
Log buffer completed up to 6088790810
Log written up to 6088790810
Log flushed up to 6088790810
Added dirty pages up to 6088790810
Pages flushed up to 6088790810
Last checkpoint at 6088790810
3531180 log i/o's done, 2.22 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 137363456
Dictionary memory allocated 1992059
Buffer pool size 8192
Free buffers 1024
Database pages 7124
Old database pages 2609
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3146508, not young 9853183
0.00 youngs/s, 0.00 non-youngs/s
Pages read 985425, created 55170, written 4193683
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 23 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7124, unzip_LRU len: 0
I/O sum[129]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=8925, Main thread ID=140511979693824 , state=sleeping
Number of rows inserted 224259, updated 746049, deleted 50148, read 269674107
0.05 inserts/s, 0.50 updates/s, 0.02 deletes/s, 278.41 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
分析结果
事务一正在执行下面语句，等待索引 c_id|14765d51d4f98d5c847dc648c20ad8 上的锁，
insert into tx_nodeinstance (c_agent, c_alias, c_desc, c_endtime, c_instanceid, c_log, c_name, c_outputs, c_starttime, c_state, c_type, c_id) values (
)
事务二正在执行下面语句，等待索引 c_id|a3f050cbd20dec9e6b9436afcb29f7 上的锁
持有 supremum 锁
delete from tx_nodeinstance where c_instanceid='Iff8080810184e0f3e0f36a120184f2a4d7510aab'