文档首页
NDB 集群内部
相关文档
MySQL NDB Cluster 8.1 手册
MySQL NDB Cluster 8.0 手册
NDB Cluster API 开发人员指南
下载本手册
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb

2.42 DUMP 2304

代码

2304

符号

---

内核块

DBLQH

描述.  此命令将所有片段日志文件及其状态写入数据节点的 out 文件（如果数据节点的节点 ID 为 5，则此文件为 ndb_5_out.log）。片段日志文件数量由 NoOfFragmentLogFiles 数据节点配置参数控制。

示例输出.  以下内容来自具有 2 个数据节点的 NDB 集群中的 ndb_5_out.log

Press CTRL+C to copy
 
LP 0 blockInstance: 1 partNo: 0 state: 0 WW_Gci: 1 gcprec: -256 flq: 4294967040 4294967040 currfile: 0 tailFileNo: 0 logTailMbyte: 2 cnoOfLogPages: 1016 problems: 0x0
  file 0(0)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 2  currentFilepage 75
  file 1(1)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 0  currentFilepage 0
  file 2(2)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 3(3)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 4(4)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 5(5)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 6(6)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 7(7)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 8(8)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 9(9)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 10(10)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 11(11)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 12(12)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 13(13)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 14(14)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 15(15)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
LP 1 blockInstance: 1 partNo: 1 state: 0 WW_Gci: 1 gcprec: -256 flq: 4294967040 4294967040 currfile: 16 tailFileNo: 0 logTailMbyte: 2 cnoOfLogPages: 1016 problems: 0x0
  file 0(16)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 2  currentFilepage 69
  file 1(17)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 0  currentFilepage 0
  file 2(18)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 3(19)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 4(20)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 5(21)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 6(22)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 7(23)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 8(24)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 9(25)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 10(26)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 11(27)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 12(28)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 13(29)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 14(30)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 15(31)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
LP 2 blockInstance: 1 partNo: 2 state: 0 WW_Gci: 1 gcprec: -256 flq: 4294967040 4294967040 currfile: 32 tailFileNo: 0 logTailMbyte: 2 cnoOfLogPages: 1016 problems: 0x0
  file 0(32)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 2  currentFilepage 69
  file 1(33)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 0  currentFilepage 0
  file 2(34)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 3(35)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 4(36)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 5(37)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 6(38)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 7(39)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 8(40)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 9(41)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 10(42)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 11(43)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 12(44)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 13(45)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 14(46)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 15(47)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
LP 3 blockInstance: 1 partNo: 3 state: 0 WW_Gci: 1 gcprec: -256 flq: 4294967040 4294967040 currfile: 48 tailFileNo: 0 logTailMbyte: 2 cnoOfLogPages: 1016 problems: 0x0
  file 0(48)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 2  currentFilepage 69
  file 1(49)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 0  currentFilepage 0
  file 2(50)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 3(51)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 4(52)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 5(53)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 6(54)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 7(55)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 8(56)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 9(57)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 10(58)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 11(59)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 12(60)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 13(61)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 14(62)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0
  file 15(63)  FileChangeState: 0  logFileStatus: 1  currentMbyte: 0  currentFilepage 0

附加信息.  下面两个表提供有关文件更改状态代码和日志文件状态代码的信息，如前例所示。

FileChangeState 代码

表 2.5 FileChangeState 代码状态

值 文件更改状态
0 内容行 1，列 2
1 NOT_ONGOING
2 BOTH_WRITES_ONGOING
3 LAST_WRITE_ONGOING
4 WRITE_PAGE_ZERO_ONGOING

LogFileStatus 代码

表 2.6 LogFileStatus 代码及其状态和描述

值 日志文件状态 描述
0 LFS_IDLE 日志文件记录未使用
1 CLOSED 日志文件已关闭。
2 OPENING_INIT ---
3 OPEN_SR_FRONTPAGE 日志文件在系统重启时打开；打开文件 0 以查找日志部分的首页。
4 OPEN_SR_LAST_FILE 打开系统重启前写入的最后一个日志文件。
5 OPEN_SR_NEXT_FILE 打开 16 个文件之前的日志文件（以查找关于 GCP 的下一条可用信息）。
6 OPEN_EXEC_SR_START 在系统重启期间执行日志时打开日志文件。
7 OPEN_EXEC_SR_NEW_MBYTE ---
8 OPEN_SR_FOURTH_PHASE ---
9 OPEN_SR_FOURTH_NEXT ---
10 OPEN_SR_FOURTH_ZERO ---
11 OPENING_WRITE_LOG 在写入日志（正常操作）时打开日志文件。
12 OPEN_EXEC_LOG ---
13 CLOSING_INIT ---
14 CLOSING_SR 日志文件作为系统重启的一部分关闭。目前正在尝试查找日志执行的起始位置。
15 CLOSING_EXEC_SR 日志文件作为系统重启期间日志执行的一部分关闭。
16 CLOSING_EXEC_SR_COMPLETED ---
17 CLOSING_WRITE_LOG 日志文件作为正常操作期间写入日志的一部分关闭。
18 CLOSING_EXEC_LOG ---
19 OPEN_INIT ---
20 OPEN 日志文件已打开。
21 OPEN_SR_READ_INVALIDATE_PAGES ---
22 CLOSE_SR_READ_INVALIDATE_PAGES ---
23 OPEN_SR_WRITE_INVALIDATE_PAGES ---
24 CLOSE_SR_WRITE_INVALIDATE_PAGES ---
25 OPEN_SR_READ_INVALIDATE_SEARCH_FILES ---
26 CLOSE_SR_READ_INVALIDATE_SEARCH_FILES ---
27 CLOSE_SR_READ_INVALIDATE_SEARCH_LAST_FILE ---
28 OPEN_EXEC_LOG_CACHED ---
29 CLOSING_EXEC_LOG_CACHED ---
值 日志文件状态 描述

有关这些代码定义方式的更多信息，请参阅源文件 storage/ndb/src/kernel/blocks/dblqh/Dblqh.hpp。另请参阅 第 2.43 节，“DUMP 2305”。


上一个   首页   向上   下一个
相关文档
MySQL NDB Cluster 8.1 手册
MySQL NDB Cluster 8.0 手册
NDB Cluster API 开发人员指南
下载本手册
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb