Skip navigation links
8.2.3.6 DUMP 2305 »
Section Navigation      [Toggle]

8.2.3.5. DUMP 2304

Code Symbol Kernel Block(s)
2304 --- DBLQH

Description.  This command causes all fragment log files and their states to be written to the data node's out file (in the case of the data node having the node ID 1, this would be ndb_1_out.log). The number of fragment log files is controlled by the NoOfFragmentLogFiles data node configuration parameter (default value: 16).

Sample Output.  The following is taken from ndb_1_out.log for a cluster with 2 data nodes: 

LP 2 state: 0 WW_Gci: 1 gcprec: -256 flq: -256 currfile: 32 tailFileNo: 0 logTailMbyte: 1
  file 0(32)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 1  currentFilepage 55
  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 state: 0 WW_Gci: 1 gcprec: -256 flq: -256 currfile: 48 tailFileNo: 0 logTailMbyte: 1
  file 0(48)  FileChangeState: 0  logFileStatus: 20  currentMbyte: 1  currentFilepage 55
  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

Additional Information.  The next 2 tables provide information about file change state codes and log file status codes as shown in the previous example.

FileChangeState Codes
Value File Change State
0 Content row 1, column 2
1 NOT_ONGOING
2 BOTH_WRITES_ONGOING
3 LAST_WRITE_ONGOING
4 WRITE_PAGE_ZERO_ONGOING
LogFileStatus Codes
Value Log File Status Description
0 LFS_IDLE Log file record not in use
1 CLOSED Log file closed.
2 OPENING_INIT ---
3 OPEN_SR_FRONTPAGE Log file opened as part of system restart; open file 0 to find the front page of the log part.
4 OPEN_SR_LAST_FILE Opening last log file that was written before the system restart.
5 OPEN_SR_NEXT_FILE Opening log file which is 16 files back (to find next available information about GCPs).
6 OPEN_EXEC_SR_START Log file opened while executing the log during a system restart.
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 Log file opened while writing log (normal operation).
12 OPEN_EXEC_LOG ---
13 CLOSING_INIT ---
14 CLOSING_SR Log file closed as part of system restart. Currently trying to find where to start executing the log.
15 CLOSING_EXEC_SR Log file closed as part of log execution during system restart.
16 CLOSING_EXEC_SR_COMPLETED ---
17 CLOSING_WRITE_LOG Log file closed as part of writing log during normal operations.
18 CLOSING_EXEC_LOG ---
19 OPEN_INIT ---
20 OPEN Log file 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 ---

More information about how these codes are defined can be found in the source file storage/ndb/src/kernel/blocks/dblqh/Dblqh.hpp. See also Section 8.2.3.6, “DUMP 2305”.

Copyright © 2003, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices