ndb_print_frag_fileobtains information from a cluster fragment list file. It is intended for use in helping to diagnose issues with data node restarts.

Usage

ndb_print_frag_filefile_name

file_nameis the name of a cluster fragment list file, which matches the patternSX.FragList, whereXis a digit in the range 2-9 inclusive, and are found in the data node file system of the data node having the node IDnodeid, in directories namedndb_nodeid_fs/DN/DBDIH/, whereNis1or2. Each fragment file contains records of the fragments belonging to eachNDBtable. For more information about cluster fragment files, seeNDB Cluster Data Node File System Directory.

Likendb_print_backup_file,ndb_print_sys_file, andndb_print_schema_file(and unlike most of the otherNDButilities that are intended to be run on a management server host or to connect to a management server),ndb_print_frag_file必须运行在集群数据节点,因为它acc吗ses the data node file system directly. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down.

Additional Options

None.

Sample Output

shell> ndb_print_frag_file /usr/local/mysqld/data/ndb_3_fs/D1/DBDIH/S2.FragList Filename: /usr/local/mysqld/data/ndb_3_fs/D1/DBDIH/S2.FragList with size 8192 noOfPages = 1 noOfWords = 182 Table Data ---------- Num Frags: 2 NoOfReplicas: 2 hashpointer: 4294967040 kvalue: 6 mask: 0x00000000 method: HashMap Storage is on Logged and checkpointed, survives SR ------ Fragment with FragId: 0 -------- Preferred Primary: 2 numStoredReplicas: 2 numOldStoredReplicas: 0 distKey: 0 LogPartId: 0 -------Stored Replica---------- Replica node is: 2 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1 LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: valid LcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid -------Stored Replica---------- Replica node is: 3 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1 LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: valid LcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid ------ Fragment with FragId: 1 -------- Preferred Primary: 3 numStoredReplicas: 2 numOldStoredReplicas: 0 distKey: 0 LogPartId: 1 -------Stored Replica---------- Replica node is: 3 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1 LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: valid LcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid -------Stored Replica---------- Replica node is: 2 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1 LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: valid LcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid