Setting ndb-batch-size Causes: Error 1205 Lock wait timeout exceeded; Error 4012 'Request ndbd time-out, maybe due to high load or communication problems'; Error 218 'Out of LongMessageBuffer'; Error 1218 'Send Buffers overloaded in NDB kernel' (Doc ID 1904610.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When attempting to make a change that pushes large amounts of data from the mysqld node to the data nodes - such as ALTER TABLE innodb_table ENGINE=NDBCluster or a large INSERT - with ndb-batch-size set to a larger than default values, one of the following errors occur:

 

The table being updated may have a unique key, but this is not a requirement.

Changes

This issue can start after increasing ndb-batch-size.

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