<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-restart-info">
      </a>
      25.6.17.53 The ndbinfo restart_info Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045088145008">
  </a>
  <p>
   The
   <code class="literal">
    restart_info
   </code>
   table contains information
        about node restart operations. Each entry in the table
        corresponds to a node restart status report in real time from a
        data node with the given node ID. Only the most recent report
        for any given node is shown.
  </p>
  <p>
   The
   <code class="literal">
    restart_info
   </code>
   table contains the following
        columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       node_id
      </code>
     </p>
     <p>
      Node ID in the cluster
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       node_restart_status
      </code>
     </p>
     <p>
      Node status; see text for values. Each of these corresponds
            to a possible value of
      <code class="literal">
       node_restart_status_int
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       node_restart_status_int
      </code>
     </p>
     <p>
      Node status code; see text for values.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_to_complete_node_failure
      </code>
     </p>
     <p>
      Time in seconds to complete node failure handling
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_to_allocate_node_id
      </code>
     </p>
     <p>
      Time in seconds from node failure completion to allocation
            of node ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_to_include_in_heartbeat_protocol
      </code>
     </p>
     <p>
      Time in seconds from allocation of node ID to inclusion in
            heartbeat protocol
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_until_wait_for_ndbcntr_master
      </code>
     </p>
     <p>
      Time in seconds from being included in heartbeat protocol
            until waiting for
      <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-kernel-blocks-ndbcntr.html" target="_top">
       <code class="literal">
        NDBCNTR
       </code>
      </a>
      master began
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_wait_for_ndbcntr_master
      </code>
     </p>
     <p>
      Time in seconds spent waiting to be accepted by
      <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-kernel-blocks-ndbcntr.html" target="_top">
       <code class="literal">
        NDBCNTR
       </code>
      </a>
      master for
            starting
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_to_get_start_permitted
      </code>
     </p>
     <p>
      Time in seconds elapsed from receiving of permission for
            start from master until all nodes have accepted start of
            this node
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_to_wait_for_lcp_for_copy_meta_data
      </code>
     </p>
     <p>
      Time in seconds spent waiting for LCP completion before
            copying metadata
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_to_copy_meta_data
      </code>
     </p>
     <p>
      Time in seconds required to copy metadata from master to
            newly starting node
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_to_include_node
      </code>
     </p>
     <p>
      Time in seconds waited for GCP and inclusion of all nodes
            into protocols
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_starting_node_to_request_local_recovery
      </code>
     </p>
     <p>
      Time in seconds that the node just starting spent waiting to
            request local recovery
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_for_local_recovery
      </code>
     </p>
     <p>
      Time in seconds required for local recovery by node just
            starting
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_restore_fragments
      </code>
     </p>
     <p>
      Time in seconds required to restore fragments from LCP files
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_undo_disk_data
      </code>
     </p>
     <p>
      Time in seconds required to execute undo log on disk data
            part of records
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_exec_redo_log
      </code>
     </p>
     <p>
      Time in seconds required to execute redo log on all restored
            fragments
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_index_rebuild
      </code>
     </p>
     <p>
      Time in seconds required to rebuild indexes on restored
            fragments
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_to_synchronize_starting_node
      </code>
     </p>
     <p>
      Time in seconds required to synchronize starting node from
            live nodes
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_wait_lcp_for_restart
      </code>
     </p>
     <p>
      Time in seconds required for LCP start and completion before
            restart was completed
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       secs_wait_subscription_handover
      </code>
     </p>
     <p>
      Time in seconds spent waiting for handover of replication
            subscriptions
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total_restart_secs
      </code>
     </p>
     <p>
      Total number of seconds from node failure until node is
            started again
     </p>
    </li>
   </ul>
  </div>
  <h5>
   <a name="idm46045088094112">
   </a>
   Notes
  </h5>
  <p>
   The following list contains values defined for the
   <code class="literal">
    node_restart_status_int
   </code>
   column with their
        internal status names (in parentheses), and the corresponding
        messages shown in the
   <code class="literal">
    node_restart_status
   </code>
   column:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       0
      </code>
      (
      <code class="literal">
       ALLOCATED_NODE_ID
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Allocated node id
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       1
      </code>
      (
      <code class="literal">
       INCLUDED_IN_HB_PROTOCOL
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Included in heartbeat protocol
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       2
      </code>
      (
      <code class="literal">
       NDBCNTR_START_WAIT
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Wait for NDBCNTR master to permit us to
            start
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       3
      </code>
      (
      <code class="literal">
       NDBCNTR_STARTED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       NDBCNTR master permitted us to start
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       4
      </code>
      (
      <code class="literal">
       START_PERMITTED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       All nodes permitted us to start
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       5
      </code>
      (
      <code class="literal">
       WAIT_LCP_TO_COPY_DICT
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Wait for LCP completion to start copying
            metadata
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       6
      </code>
      (
      <code class="literal">
       COPY_DICT_TO_STARTING_NODE
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Copying metadata to starting node
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       7
      </code>
      (
      <code class="literal">
       INCLUDE_NODE_IN_LCP_AND_GCP
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Include node in LCP and GCP protocols
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       8
      </code>
      (
      <code class="literal">
       LOCAL_RECOVERY_STARTED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Restore fragments ongoing
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       9
      </code>
      (
      <code class="literal">
       COPY_FRAGMENTS_STARTED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Synchronizing starting node with live
            nodes
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       10
      </code>
      (
      <code class="literal">
       WAIT_LCP_FOR_RESTART
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Wait for LCP to ensure durability
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       11
      </code>
      (
      <code class="literal">
       WAIT_SUMA_HANDOVER
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Wait for handover of subscriptions
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       12
      </code>
      (
      <code class="literal">
       RESTART_COMPLETED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Restart completed
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       13
      </code>
      (
      <code class="literal">
       NODE_FAILED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Node failed, failure handling in progress
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       14
      </code>
      (
      <code class="literal">
       NODE_FAILURE_COMPLETED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Node failure handling completed
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       15
      </code>
      (
      <code class="literal">
       NODE_GETTING_PERMIT
      </code>
      )
     </p>
     <p>
      <code class="literal">
       All nodes permitted us to start
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       16
      </code>
      (
      <code class="literal">
       NODE_GETTING_INCLUDED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Include node in LCP and GCP protocols
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       17
      </code>
      (
      <code class="literal">
       NODE_GETTING_SYNCHED
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Synchronizing starting node with live
            nodes
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       18
      </code>
      (
      <code class="literal">
       NODE_GETTING_LCP_WAITED
      </code>
      )
     </p>
     <p>
      [none]
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       19
      </code>
      (
      <code class="literal">
       NODE_ACTIVE
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Restart completed
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       20
      </code>
      (
      <code class="literal">
       NOT_DEFINED_IN_CLUSTER
      </code>
      )
     </p>
     <p>
      [none]
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       21
      </code>
      (
      <code class="literal">
       NODE_NOT_RESTARTED_YET
      </code>
      )
     </p>
     <p>
      <code class="literal">
       Initial state
      </code>
     </p>
    </li>
   </ul>
  </div>
  <p>
   Status numbers 0 through 12 apply on master nodes only; the
        remainder of those shown in the table apply to all restarting
        data nodes. Status numbers 13 and 14 define node failure states;
        20 and 21 occur when no information about the restart of a given
        node is available.
  </p>
  <p>
   See also
   <a class="xref" href="mysql-cluster-start-phases.html" title="25.6.4 Summary of NDB Cluster Start Phases">
    Section 25.6.4, “Summary of NDB Cluster Start Phases”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
