MySQL Cluster Schema Changes Delayed 120 seconds; Waiting Max 119 Sec For Distributing; Injector proc_info: Waiting For Event From Ndbcluster Map; [ERROR] NDB Online Alter Table Commit: Distributing ./db1/t1 Timed Out. Ignoring (Doc ID 1551294.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When executing a schema change the statement is delayed by two minutes and the MySQL error log on the node executing the statement contains:

The schema change does not need to be an ALTER TABLE like in the case above; it can be any type of schema change. Likewise it can both happen during the prepare and commit phases.

The issue is more likely to happen for tables that contains BLOB or TEXT columns, but is not exclusive to those tables.

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