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'
Last updated on MARCH 08, 2017
Applies to:MySQL Cluster - Version 7.2 and later
Information in this document applies to any platform.
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.
This issue can start after increasing ndb-batch-size.
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