2.42 转储 2304_MySQL NDB Cluster 内部手册

MySQL NDB Cluster 内部手册 / 第 2 章 NDB Cluster 管理客户端 DUMP 命令 / 2.42 转储 2304

2.42 转储 2304

代码: 2304
象征: ---
内核块: DBLQH

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

示例输出。 以下内容取自ndb_5_out.log 具有 2 个数据节点的 NDB Cluster：

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

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

`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	打开_写入_日志	写入日志时打开日志文件（正常操作）。
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”。

2.42 转储 2304

FileChangeState代码

LogFileStatus代码

`FileChangeState`代码

`LogFileStatus`代码