<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-programs-ndb-print-frag-file">
      </a>
      25.5.19 ndb_print_frag_file — Print NDB Fragment List File Contents
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045100069120">
  </a>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-print-frag-file.html" title="25.5.19 ndb_print_frag_file — Print NDB Fragment List File Contents">
    <span class="command">
     <strong>
      ndb_print_frag_file
     </strong>
    </span>
   </a>
   obtains information from
        a cluster fragment list file. It is intended for use in helping
        to diagnose issues with data node restarts.
  </p>
  <h4>
   <a name="idm46045100066160">
   </a>
   Usage
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa71064168"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">ndb_print_frag_file <em class="replaceable">file_name</em></code></pre>
  </div>
  <p>
   <em class="replaceable">
    <code>
     file_name
    </code>
   </em>
   is the name of a cluster
        fragment list file, which matches the pattern
   <code class="filename">
    S
    <em class="replaceable">
     <code>
      X
     </code>
    </em>
    .FragList
   </code>
   ,
        where
   <em class="replaceable">
    <code>
     X
    </code>
   </em>
   is a digit in the range 2-9
        inclusive, and are found in the data node file system of the
        data node having the node ID
   <em class="replaceable">
    <code>
     nodeid
    </code>
   </em>
   ,
        in directories named
   <code class="filename">
    ndb_
    <em class="replaceable">
     <code>
      nodeid
     </code>
    </em>
    _fs/D
    <em class="replaceable">
     <code>
      N
     </code>
    </em>
    /DBDIH/
   </code>
   ,
        where
   <em class="replaceable">
    <code>
     N
    </code>
   </em>
   is
   <code class="literal">
    1
   </code>
   or
   <code class="literal">
    2
   </code>
   . Each fragment file contains records of the
        fragments belonging to each
   <code class="literal">
    NDB
   </code>
   table. For
        more information about cluster fragment files, see
   <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-ndbd-filesystemdir-files.html" target="_top">
    NDB Cluster Data Node File System Directory
   </a>
   .
  </p>
  <p>
   Like
   <a class="link" href="mysql-cluster-programs-ndb-print-backup-file.html" title="25.5.17 ndb_print_backup_file — Print NDB Backup File Contents">
    <span class="command">
     <strong>
      ndb_print_backup_file
     </strong>
    </span>
   </a>
   ,
   <a class="link" href="mysql-cluster-programs-ndb-print-sys-file.html" title="25.5.21 ndb_print_sys_file — Print NDB System File Contents">
    <span class="command">
     <strong>
      ndb_print_sys_file
     </strong>
    </span>
   </a>
   , and
   <a class="link" href="mysql-cluster-programs-ndb-print-schema-file.html" title="25.5.20 ndb_print_schema_file — Print NDB Schema File Contents">
    <span class="command">
     <strong>
      ndb_print_schema_file
     </strong>
    </span>
   </a>
   (and unlike most of the
        other
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   utilities that are
        intended to be run on a management server host or to connect to
        a management server),
   <a class="link" href="mysql-cluster-programs-ndb-print-frag-file.html" title="25.5.19 ndb_print_frag_file — Print NDB Fragment List File Contents">
    <span class="command">
     <strong>
      ndb_print_frag_file
     </strong>
    </span>
   </a>
   must be run on a cluster data node, since it accesses 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.
  </p>
  <h4>
   <a name="idm46045100048848">
   </a>
   Additional Options
  </h4>
  <p>
   None.
  </p>
  <h4>
   <a name="idm46045100047744">
   </a>
   Sample Output
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa95100275"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">ndb_print_frag_file</span> /usr/local/mysqld/data/ndb_3_fs/D1/DBDIH/S2<span class="token punctuation">.</span>FragList
Filename<span class="token punctuation">:</span> /usr/local/mysqld/data/ndb_3_fs/D1/DBDIH/S2<span class="token punctuation">.</span>FragList with size 8192
noOfPages = 1 noOfWords = 182
Table Data
<span class="token property">----------</span>
Num Frags<span class="token punctuation">:</span> 2 NoOfReplicas<span class="token punctuation">:</span> 2 hashpointer<span class="token punctuation">:</span> 4294967040
kvalue<span class="token punctuation">:</span> 6 mask<span class="token punctuation">:</span> 0x00000000 method<span class="token punctuation">:</span> HashMap
Storage is on Logged and checkpointed<span class="token punctuation">,</span> survives SR
<span class="token property">------</span> Fragment with FragId<span class="token punctuation">:</span> 0 <span class="token property">--------</span>
Preferred Primary<span class="token punctuation">:</span> 2 numStoredReplicas<span class="token punctuation">:</span> 2 numOldStoredReplicas<span class="token punctuation">:</span> 0 distKey<span class="token punctuation">:</span> 0 LogPartId<span class="token punctuation">:</span> 0
<span class="token property">-------Stored</span> Replica----------
Replica node is<span class="token punctuation">:</span> 2 initialGci<span class="token punctuation">:</span> 2 numCrashedReplicas = 0 nextLcpNo = 1
LcpNo<span class="token punctuation">[</span>0<span class="token punctuation">]</span><span class="token punctuation">:</span> maxGciCompleted<span class="token punctuation">:</span> 1 maxGciStarted<span class="token punctuation">:</span> 2 lcpId<span class="token punctuation">:</span> 1 lcpStatus<span class="token punctuation">:</span> valid
LcpNo<span class="token punctuation">[</span>1<span class="token punctuation">]</span><span class="token punctuation">:</span> maxGciCompleted<span class="token punctuation">:</span> 0 maxGciStarted<span class="token punctuation">:</span> 0 lcpId<span class="token punctuation">:</span> 0 lcpStatus<span class="token punctuation">:</span> invalid
<span class="token property">-------Stored</span> Replica----------
Replica node is<span class="token punctuation">:</span> 3 initialGci<span class="token punctuation">:</span> 2 numCrashedReplicas = 0 nextLcpNo = 1
LcpNo<span class="token punctuation">[</span>0<span class="token punctuation">]</span><span class="token punctuation">:</span> maxGciCompleted<span class="token punctuation">:</span> 1 maxGciStarted<span class="token punctuation">:</span> 2 lcpId<span class="token punctuation">:</span> 1 lcpStatus<span class="token punctuation">:</span> valid
LcpNo<span class="token punctuation">[</span>1<span class="token punctuation">]</span><span class="token punctuation">:</span> maxGciCompleted<span class="token punctuation">:</span> 0 maxGciStarted<span class="token punctuation">:</span> 0 lcpId<span class="token punctuation">:</span> 0 lcpStatus<span class="token punctuation">:</span> invalid
<span class="token property">------</span> Fragment with FragId<span class="token punctuation">:</span> 1 <span class="token property">--------</span>
Preferred Primary<span class="token punctuation">:</span> 3 numStoredReplicas<span class="token punctuation">:</span> 2 numOldStoredReplicas<span class="token punctuation">:</span> 0 distKey<span class="token punctuation">:</span> 0 LogPartId<span class="token punctuation">:</span> 1
<span class="token property">-------Stored</span> Replica----------
Replica node is<span class="token punctuation">:</span> 3 initialGci<span class="token punctuation">:</span> 2 numCrashedReplicas = 0 nextLcpNo = 1
LcpNo<span class="token punctuation">[</span>0<span class="token punctuation">]</span><span class="token punctuation">:</span> maxGciCompleted<span class="token punctuation">:</span> 1 maxGciStarted<span class="token punctuation">:</span> 2 lcpId<span class="token punctuation">:</span> 1 lcpStatus<span class="token punctuation">:</span> valid
LcpNo<span class="token punctuation">[</span>1<span class="token punctuation">]</span><span class="token punctuation">:</span> maxGciCompleted<span class="token punctuation">:</span> 0 maxGciStarted<span class="token punctuation">:</span> 0 lcpId<span class="token punctuation">:</span> 0 lcpStatus<span class="token punctuation">:</span> invalid
<span class="token property">-------Stored</span> Replica----------
Replica node is<span class="token punctuation">:</span> 2 initialGci<span class="token punctuation">:</span> 2 numCrashedReplicas = 0 nextLcpNo = 1
LcpNo<span class="token punctuation">[</span>0<span class="token punctuation">]</span><span class="token punctuation">:</span> maxGciCompleted<span class="token punctuation">:</span> 1 maxGciStarted<span class="token punctuation">:</span> 2 lcpId<span class="token punctuation">:</span> 1 lcpStatus<span class="token punctuation">:</span> valid
LcpNo<span class="token punctuation">[</span>1<span class="token punctuation">]</span><span class="token punctuation">:</span> maxGciCompleted<span class="token punctuation">:</span> 0 maxGciStarted<span class="token punctuation">:</span> 0 lcpId<span class="token punctuation">:</span> 0 lcpStatus<span class="token punctuation">:</span> invalid</code></pre>
  </div>
 </div>
 <br/>
</div>
