Datatanode starts slow as it is unable to use LCP to restore data

(Doc ID 2223767.1)

Last updated on JANUARY 24, 2017

Applies to:

MySQL Cluster - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

In a cluster all nodes except one take normal time for start up, all start phases are executed more or less in parallel. But one node completes start phase 2 only after all the nodes reached the "started" state.

Having a cluster with 4 datanodes, 3 of the datanodes starting up very quickly (aprox. 30 minutes) all stat phases executed more or less in parallel. The 4th (nodeid=6) node completing Start phase 2 only after all the nodes reached the "started" state.

In the problematic node out log the following entries may be seen:

Looks like the datanode was not restored from LCP/REDO log, but by copying fragments from other nodes.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms