My Oracle Support Banner

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 SEPTEMBER 06, 2023

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.