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 AUGUST 19, 2020
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document