mariadb 我遇到了一个innodb无休止的事务问题

sd2nnvve  于 5个月前  发布在  其他
关注(0)|答案(1)|浏览(63)

我正在使用MariaDB版本11.0.2,我遇到了以下问题。我无法对数据库中的相关行执行任何操作。下面的交易文本不以任何方式进行。我不知道该怎么做或如何解决它。我正在Google上进行有关该主题的研究,但解决方案已经过时或我无法获得任何结果。

=====================================
2023-07-16 10:24:13 0x7ff7f81a9640 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 47 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 6794 srv_idle
srv_master_thread log flush and writes: 6794
----------
SEMAPHORES
----------
------------
TRANSACTIONS
------------
Trx id counter 3054
Purge done for trx's n:o < 3054 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 2668, ACTIVE (PREPARED) 6797 sec recovered trx
2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1
--------
FILE I/O
--------
Pending flushes (fsync): 0
3302 OS file reads, 29 OS file writes, 30 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
---
LOG
---
Log sequence number 67754925
Log flushed up to   67754925
Pages flushed up to 67701222
Last checkpoint at  67701206
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 167772160
Dictionary memory allocated 1001072
Buffer pool size   8064
Free buffers       4706
Database pages     3358
Old database pages 1259
Modified db pages  69
Percent of dirty pages(LRU & free pages): 0.856
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3218, created 140, written 0
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 3358, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 read views open inside InnoDB
state: sleeping
----------------------------
END OF INNODB MONITOR OUTPUT
============================

字符串

n1bvdmb6

n1bvdmb61#

线

---TRANSACTION 2668, ACTIVE (PREPARED) 6797 sec recovered trx

字符串
说这是一个在XA PREPARE状态下恢复的事务。在服务器最后一次启动时,在服务器错误日志中是否有任何关于恢复的XA事务的消息?您可以执行命令XA RECOVER来列出所有处于XA PREPARE状态的事务吗?它还应该列出XID,您可以将其传递给XA COMMITXA ROLLBACK语句。这应该是binlog(log_bin)内部使用来保持自身与InnoDB事务提交的一致性。在这种情况下,这应该是一个错误,在崩溃恢复或准备(应用日志)热备份时,XID没有提交或回滚。

相关问题